Can I have a field "name" and perform a FIND on the result from its dropdown list? If it's a script can someone help me with the script.
Start by doing a script that uses:
Enter Find Mode
Set Field [Field to search on; Value to search]
This is a much more flexible way of programming finds than using Perform Find.
You can e.g. add If/else if/end if to specify which field to search on.
Another option is using Set field by name instead of Set Field, but that may be less straighforward for a first go at scripting finds.
If users enter the find criteria into fields, you are going to need to use Set variable before Enter Find mode to temporarily store the values to search on (unless you are using global fields fir entering search criteria).
Can you please expand on what you mean by ”the result from its dropdown list”?
If you can upload an example file, that’s even better!
Thanks for that quick reply!
Having had lunch I have modified my request!!! But I am still stuck. Here
is my problem:
I have a list of Journal entries. Purchases, sales, bank movements etc. It
is a double entry journal and all the general ledgers are simply finds from
The journal Fields, among others, are: Names, Category, How paid (Cheque/CC
etc.). Those mentioned have a dropdown list. Could be a popup list is
I can use the "Find" button on the Status Bar: "Find" / choose 1 or several
criteria from the layout and use the dropdown list and/or select from
another field on the list, then click the "Perform Find" button on the
But I don't want the Status bar on top as it takes up space!
As the Journal layout is a list, I would like to put 2 buttons "Find" and
"Perform Find" on the header part of the layout. I would also add a sort to
If I add "Perform Find" to a script it asks me to specify the criteria.
However I can't place the specific name there as it will be one of many
possibilities, hence the dropdown list. And it's hidden in a script.
That's what I can't see how to do it.
Hope that makes sense,
To replicate the actions from the status tool bar,
enter find mode [ pause:off ]
Perform Find [ ]
note the brackets are empty for perform find. While you can specify find criteria for this step, you don’t have to.
I think I have solved my problem. Finds aren't easy!
Thank you both and perfect.
You might find the first part of this discussion thread worth a read:
Scripted Find Examples
Retrieving data ...