lookup table with a single column full of characters that you want to include (in my case, I exclude some numbers and letters are they might be confusing to read or say)
in the table where I will need the code, my two-character code is made up of two single value columns, both picking random values from the lookup + a template column that combines them together
in my app, I have a moment when the user needs to click on a button to initiate a process. At that point I have an action that does Set Columns, taking the continuously changing 2-char string… and bakes it into a ‘Code’ column, to set it for the process.
Magic! And gets rid of the last GSheet formula I was stuck with
Would a combo action fire quick enough if you include a relation to check for duplications, then if the relation is not empty, let’s say reshuffle and then set column?
As I was typing this, I’m thinking if it generates a duplicate again then it also won’t work
in my case the only issue would be the same user gets the same code at some point over the next months. It is not a disaster though, as the user needs to also do a drawing… and they have to use the camera (on mobile) to upload their photos. And we do a date check in the EXIF data from the photo to see when the photo was originally saved… and validate that against the timestamp of when the process started.
