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?
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.