Hi Dan, welcome to the board!
You’re on the right track with FIND(), but you need to combine it with the MID() function to extract text from {UPS Email}.
MID() takes three arguments:
The string from which to extract.The starting position of the subst...
We need some formulas which can collect the aggregate value of a field to either the table or group level.
For example;
I have a field “Sale Amount”, I’d like to create another field which is “% of Total Sales”. To achieve this currently requires an...
createdTime is always included, regardless of whether or not a column exists for it on the table. If you look at the example JSON I provided, “createdTime” is not inside the fields object, but at the same level as “id”.