James-Trory - profile

James-Trory · Mar 06, 2021

Formulas in Airtable can be as simple or as complex as you need them to be. When writing a formula with many conditions it can get particularly difficult. You may have run into the case yourself where you have written a complex formula and somewhere ...

James-Trory · Mar 07, 2021

You could try using a Rollup field instead of a Lookup. Rollups work similarly to Lookups, but in a Rollup at the bottom of the field configuration, you are able to add formulas (some of which it will give you examples of) in order to manipulate what...

James-Trory · Mar 07, 2021

I’m sincerely interested to learn how you think the formula could be improved upon. As a simple technique to combine many formulas into one, I see this as being the most simple to understand. It may not, admittedly, be the best example I could have g...

James-Trory · Mar 06, 2021

If you’re looking for the word “data” somewhere in a field, why not remove “the” from the FIND() formula and look only for “data”? That way you’ll pick up anywhere where that word occurs, regardless of what else might be in the string. FIND("data",LO...

User Statistics

User Activity

How to write complex formulas more easily

Re: Using REGEX on a lookup field

Re: How to write complex formulas more easily

Re: Search for partial match formula