i want two randomly chosen entries from the same collection displayed - for the user to chose 1
when they click on one the page refreshes and another two are shown - with never the same item in both spots ? - any ideas how I could achieve this? - i thought a list - with only 2 items shown (and no sorting)- but then not sure how to get this to refresh and show another 2 items - randomly selected…
Just one question …
If the lists have items in them that can be created and deleted by users …
I may end up with holes in id numbering - do you know if this will confuse the random picker?
Speaking seriously - item creation should not break this, as long as you assign ID automatically based on ID → Maximum → + 1 (or Count +1).
But deleting items will definitely break the solution: it’s not the random picker, but rather the list which will not display the item with nonexistent ID.
And here unfortunately no easy solution comes to my mind.
You could try to recalculate ID for all the collection, but this will require some external service.
You could try to mark items as “deleted”, and after the random picker chooses the value, check if the item is “deleted” and re-choose the value. This could be done with similar logic which I showed (additional condition on screen enter). But if users delete items frequently, the “ID re-selection loop” will happen too often.
Another option - use external service, like Integromat or Zapier, to make the random choices
May be storing the records in Airtable could help - so that upon deletion you could implement some Airtable functionality to auto-update the IDs. But I’m not sure if this is possible or not.
