Automating Scripts

[mborgens]

I have a text field with a value list assigned to it. Each value is tied a different script action. Once the user selects a popup value, then a button must be pushed to activate the script. Is there a way to lose the button and make the script occur after making a selection from the list? Advanced Thanks, mb

[LiveOak]

You will need one of the script scheduling plug-ins. Take a look at www.troi.com.

-bd

[keshalyi]

Another option might be:

1) Set up a button, for the field that has the drop down list. Have this button switch to an identical outlet, with a portal hanging below the field, to LOOK like a dropdown list. Then make a button for the choices in the portal, that sets the original field to the value, and runs a script based on that value

[IdealData]

I wrote a solution that uses the "pause" facility to check the content of the field displaying the value list. If it's valid then go on and process, otherwise pause another second.

I use a 3 second time limit to terminate the loop.

Works for me.

[mborgens]

Thanks for the advice.

I'm sorry; I couldn't find a plug-in that fit my needs at www.troi.com.

If I understand keshalyi's solution, it is based off of the tabbed interface concept. I like the idea and will use it on smaller databases, but this is one is already huge.

Mark, I don't think I get your solution. In my database, the user can access value list field at any time. Is your solution running the entire time, moving in and out of a paused state and then checking if something is in the field and performing the matched script if found every 3 seconds?

Thank you for your time. mb

[SteveB]

Try www.wmotion.com for another plugin

[ldebondt]

I have a field "zBIO Fac" that is formated as a drop down menu. User has option of 4 fiscal years. The user selects "2002" and a script is automatically run.

Goto Field (Select/perform, "zBIO Fac")

Pause/Resume Script ("0:00:01")

If ("zBIO Fac = "2002"")

Goto Layout ("Fac 02 Rpt")

Perform Script (Sub-Scripts, "Bio Fac 02")

Else

If( "zBIO Fac = "2003"")

Goto Layout ("Fac 03 Rpt")

Perform Script (Sub-Scripts, "Bio Fac 02")

End If

[BobWeaver]

You might be able to adapt a technique that I posted in development standards a while back:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB8&Number=1388&page=0&view=collapsed&sb=5&o=all&fpart=1

I also posted a link to an example file. The link in the original message is no longer current, but I posted a new link at the bottom of the thread.

[mborgens]

As to ldebondt's post, what initiates the script? I understand you have a drop down menu list with years, a year is selected, then what? Do you have a button next to the field?

[Keith M. Davie]

Mark Dore, you wrote, "I wrote a solution that uses the "pause" facility to check the content of the field displaying the value list. If it's valid then go on and process, otherwise pause another second.

"I use a 3 second time limit to terminate the loop."

Is yours a multi-user peer-to-peer solution? If so, what happens during the running of this script if a second user makes a script request during its running? When a script is running, since ScriptMaker is single-threaded, a second request will not run. But if the script which is running enters a pause mode, and while in that mode, another script request is made, the second request will be recoginzed by ScriptMaker which is free to accept it because of the pause, and which then puts the first script in jeopardy of not completing.

Your solution raises a question in my mind, "How do you allow for this?"

[ldebondt]

No button next to field. When you select the "year" it goes to that years layout (uses the "IF" statement to determine which layout) and performs the sub-script.

[mborgens]

I played around with it and it works! If I'm going to use it, I will need to have it start back up as each script on the layout ends. A 3 second delay seems to work well.

[Rigsby]

I