AnsweredAssumed Answered

Generate a different random set of records

Question asked by clo mama on Oct 19, 2015
Latest reply on Oct 26, 2015 by clo mama

Hi all,


My first find was to find one type of food & the remark as "Cooked", & omit records. From the found list, pick 5 random records & then when the script runs again, pick another random set from the remaining records. Here is my script. 


Go to Layout ["RecipeName" (RecipeName)]

Show All Records

Enter Find Mode [Pause]

Set Field []

New Record/Request

Insert Text [Select; RecipeName::Remark; ""Cooked""]

Omit Record

Perform Find []

Replace Field Contents [No dialog; RecipeName::Random; Random]

Sort Records by Field [Ascending; RecipeName::Random]

Go to Record/Request/Page [First]

Omit Multiple Records [No dialog; 5]

Show Omitted Only


How can I modify the script?


Thanks in advance for any help!