Hi all,
I created a script in Make to find a random record in the database, i tried to use these two formulas from the screenshots.
I don’t understand why sometimes it works fine and shows one record, and sometimes it shows 0 or 2 records, which is supposed to be impossible because I filtered the lists by one random number from 1 to 1000, and all the records in my collection have different IDs from 1 to 1000.
Can you please help me out - what am I missing?
Thanks
