8 Replies Latest reply on Oct 26, 2015 10:16 PM by clomama :D

    Generate a different random set of records

    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!