Select a script from pop-up field

[stephiesmith]

Don't know if it's possible to select a script from a pop-up field or if there is a better way to do this. Here is what I want to do:

I'd like the user to be able to click a "run report" button that gives him a pop-up list of the various FIND scripts (e.g., Find Q1 records, Find Q2, etc.) and then allows him to choose the report he wants for that period out of a list of possible reports that have already been scripted.

So, he would click the Run Report button and he would get a message that says "choose Find critera" and there would be a list of those scripts:

Q1 records

Q2 records

Q3 records

Q4 records

1st Half

2nd Half

Fiscal Year

Then once he has decided which period of time he wants to report on, he would get a message that says "choose report" and again a pop-up list of scripted reports such as:

Labor Projection by Employee

Project Summary Report

Revenue summary by Month (...etc.)

Is it possible and if so, has it been covered somewhere here?

Thanks!!

[JPaul]

Hello Stephie,

if your problem is that after clicking a choice from pop up the subsequent tests of your script seem ignored (i.e. FM seems sliding up) it is, for me (and for you - see your search script) a well known problem:

you can fix it simply by inserting, before tests, a Pause / Resume Script with the timing-delay set to 0 secs.

This seems refresh FM brain ....!

Don't forget to investigate the files i' ve sent: they are a real 'cornucopia' of ideas about searching.

Greetings from Holy Lands

[ June 05, 2001: Message edited by: JPaul ]

[bobsmith]

You should be able to do what you want with fields using menu or pop up and a continue button. The script would go to the period field and pause, click the continue button, then go to the report layout field and pause, click the continue button. You will probably have to use sub scripts for the different finds for the periods and maybe two different layouts one for each field entry. Hope this hepls.

[stephiesmith]

After receiving Bob's reply that it could be done as well as his tip on what was needed to do it, I found a simple script in the Scriptology CD that outlined the steps (I'm not from Missouri, but usually need to be shown anyway!). I included JPaul's suggestion to "refresh the FM brain" while I was at it. This is what I did (and I do have one question at the end of this information if anyone wants to answer it):

I scripted the individual Finds I wanted to do, using the error capture and status messages to show if no records match, etc.

Then I created a field called FIND REQUEST and formatted it as a pop-up value list of same name that listed the scripted finds I wanted to offer (Q1, Fiscal Year, etc).

Then I wrote a script called CHOOSE FIND REQUESTS that said:

If[Find Request = "Q1"]

Perform Script [sub-scripts, "Find Q1 Records"]

Else

If[Find Quest = "Fiscal Year"]

Perform Script [sub-scripts, "Find Fiscal Year Records"]

End If

End If

I did the same for the list of reports that I wanted to offer (Revenue by Employee, Project Revenues by Month, etc.)and called that script CHOOSE REPORT.

Then I wrote a script called RUN REPORT which says:

Set Error Capture [On]

Perform Script [sub-scripts: "Choose Find Request"]

Pause/Resume Script (set to 0 seconds)

Perform Script [sub-scripts: "Choose Report"]

I put the 2 pop-up menus on the layout and a button above them that is formatted with the Run Report script. The button says (just so there is no confusion for the user) Choose Period and Report below, then click HERE.

My question is this...I have the error capture set to on for the individual finds and layout set-ups and for the Run Report. Do I need to also have it on the CHOOSE REPORT script and the CHOOSE FIND script? When exactly should the error capture be used? Did I need it for the individual finds if it is in the final script?

Everything seems to be working correctly, but then I probably haven't intentionally made a bad choice to see what happens.

Thanks for your help Bob and JPaul.

Steph

[stephiesmith]

Oh...and obviously, this isn't exactly the same as my original "wish" request, i.e., the user clicks on the pop-up menus first and then clicks on Run Report instead of the other way around as I said in my first email, so I didn't need to have messages come up that say "Choose Report to Run" and such. I'm sure that would have been more involved.

[JPaul]

Hi Stephie,

look at your mail box ...........!

Greetings