AnsweredAssumed Answered

Generate a different random set of records

Question asked by clomama :D on Oct 19, 2015
Latest reply on Oct 26, 2015 by clomama :D

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!