The challenge - how to make a unique random code in Glide … without using GSheets (slow, etc).
The @Darren_Murphy trick:
- 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