This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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”.