Often we need a found set to work from. Orders to be processed that day, list of customer IDs to go off and get info for…
And we need that as a ‘list’
But first we need to explain the context of ‘lists’ within Claris’ FileMaker.
[1] List view. Layouts can be seen in page (one record at a time that you click to go to next/previous record), list (many records – can be one line per record, or a pile of fields with images that you scroll up/down through the records) or table view (like a spreadsheet grid).
[2] the function List ( field {; field…} ) is a left over from repeating fields. It only lists the values in one record.
[3] I haven’t found yet a list of values from the same field from a found set. Point me in the right direction if I’ve missed something or it’s new.
I tend to do this various ways…
• Export records and open the text file and cut/paste the list. Remember to sort before export. Then access the individual values by looping through and using the FileMaker function GetValue(listOfValues;valueNumber)
Set Variable [ $i ; Value: 1 ]
Loop
GetValue ( $Value ; $i ) // GetValue ( listOfValues ; valueNumber )
Exit Loop If [ $Value = “” ] // or Exit Loop If [ IsEmpty( $Value )
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter the script steps here to do whatever you need to do with this value.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Set Variable [ $i ; $i + 1 ]
End Loop
• Export records to a temp file then import in to an interim table, where I can scroll trough to remove duplicates, sort etc.
• Open a new window where I go off and get the info I need, using the first one as my list ,and toggle between the two. Using Go to Record/Request/Page [ Next ] ; Exit after last : On ]
[4] A Brian Dunning custom function called FoundList ( field ; start ) at https://www.briandunning.com/cf/1058