Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 12, 2020 09:38 AM
Use case:
At the end of my estimates (page designer), I want to put in an inspiring or humourous quote… but I don’t want to type it myself, just collect them in a field somewhere and have them appear with a formula.
What kind of formatting/formula would I need to have one long-not used quote selected from the list and popped on the paper?
Is there some kind of CHOOSE RANDOM FROM LIST function?
Thanks!
Insert inspiring quote here
Oct 12, 2020 12:31 PM
There is no random function in Airtable formulas. You need to use a script in order to generate a random value.
Oct 13, 2020 12:22 PM
As per @kuovonne, there is no random function, but this might be a suitable workaround:
I’ve got 3 fields here:
DATETIME_FORMAT(CREATED_TIME(), 'X')
which gives the unix time in secondsMOD({Created time}, 5)
. This gives the remainder when the created time is divided by 5SWITCH(
MOD,
0, 'Quote A',
1, 'Quote B',
2, 'Quote C',
3, 'Quote D',
4, 'Quote E',
'Quote F'
)
So, based on the result of the MOD field, this will display Quote A, Quote B etc.
Not random at all, but unless there’s a very strict timing pattern when you are creating records, I’m sure you will get a reasonable spread of quotes across a number of records. You can extend to 10, 20, 30 quotes by changing the divisor on the MOD field.
Oct 13, 2020 12:41 PM
Awesome, thanks! I’ll give it a go!