Inculing a script as part of a calculation field

[alopas]

Hi,

Is it posible to include a "perform script" option as part of a calculation field?

Thanks in advance

[LaRetta]

Hi alopas! Welcome to the Forum!

Well, you can use a global field which your script sets (depending upon other criteria or calculations), and then that global can be used within a calculation to produce the results you wish. Without more information, I'm afraid we couldn't answer your question appropriately.

Describe what you're trying to do and why. And give us the field names (and their data types) and we'll try to help you with it. But no, you can't 'run' a script from a calculation but there are probably other ways to accomplish what you wish.

LaRetta

[alopas]

Hi LaRetta,

Thank you . OK ... the thing is that I made a script that is activated after clicking on a field (the script shows a message, and the outcome depends on the option selected).

As you need to click on the field to activate the script, I thought that it would be easier if after pressing "tab", the script was activated

(I'm getting lazy ... I was hoping that I wouldn't need to write the sequence again as a calculation field)

[LaRetta]

Alopas said...I was hoping that I wouldn't need to write the sequence again as a calculation field)

I'm unsure why you need the calculation. Depending upon what the User selects in your script Show Message dialog, what happens then? Does it set another field? And then does a calculation need to display, showing the results of this field (in conjunction with other calculation criteria)?

Why would you need to write the sequence again in a calculation field, can you explain more? The reason for using a calculation is so that it will update whenever values in a field change. Executing a script upon field exit is possible, although tricky (without a plugin). I'm unclear on what your calculation would produce or what your script does. Can you say a bit more about it?

LaRetta

[alopas]

OK, I'll be a little bit more specific: I have two FMP files ("A" and "B") with some common fields. I have a field called "X" in database "A" with two possible inputs: "Yes" and "No". What I would like to do is the following:

- If the input in field "X" (of database "A") is "Yes", then copy the info to database "B" in a new record

- If the input in field "X" (of database "A") is "No", then just go to the next record

I did it with a script, but in order to activate it I need to press a button. I was wondering the script can be activated just after selecting either "Yes" or "No" in field "X", without needing to press the button.

Thanks a lot!

[-Queue-]

Yes, if you make the activation of "X" part of a script. Make two invisible buttons, one covering each radio button (assuming that is what you're using) option. Have one script set the field to 'Yes' and create a new record in "B". Have the other script set the field to 'No' and continue to the next record.

[alopas]

Yes, that works for me. Thanks!