I’ve searched various threads for this answer and I’m still not sure if this is possible or not. I have Table 1 (let’s say) that has a formula field which constructs a url from another field and the record id. It looks like this
With an automation ...
Hey Eric, I have a question first. It looks like your field {State (from State Ref)} is a lookup field. Could you reply with a screen shot of where that comes from? What is the “State Ref” table?
To make the state/abbrev table:
The table I was refer...
Hi Eric. Do you need the non-abbreviated state string for anything? Or are you only going to use the abbreviation. If not, I would just save yourself the hassle and let the user select an abbreviation.
Otherwise, it looks like your long State field...
Hi Ivan. In Excel, VLOOKUP works because you have already defined the relationship between “100011010” and “blue” (and many others) in a set of columns. Airtable can do the same thing.
You need the table that contains the translations (let’s call it ...
