I’m trying to use data from a lookup field in a formula and keep getting #ERROR!.
The formula (below) works with a plain text field created to test, but not the lookup field.
IF({CITIZEN SLACKIDS}=BLANK(),’’,
‘<@’ & SUBSTITUTE(VALUE({CITIZEN SLACKID...
Hello Airtable Community,
We’re Airtable addicts and need some help with Javascript.
We’ve looking to append UTM codes to links in HTML blocks.
See our post: Extracting text from between consistent characters
After this task…
We’ve built an economy o...
I’m trying to grab a variable amount of text from between two consistent characters, > and <, to format HTML. I’m using Zapier to convert rich text to HTML and then using an Airtable formula to modify the URLs with UTM codes. Example below.
Starting ...
Thank you, Scott!
Your lookup field is an array that Airtable is visually separating with commas.
SUPER helpful to know, for this and other bits.
Created the formula in the other table as recommended and got the desired result (below). It’s a bit c...
Thank you @openside!
(1) https://clearbit.com/logo as a formula field with (2) the MIniExtensions bit Convert URLs to Attachments in Bulk on Airtable, and (3) their Cloudinary bit was EXACTLY the recipe I was looking for.
Thank you Justin!
I’ve just posted that request here.
We, along with the former CFO of Second Life, have built an economy on Airtable. We were in the beta for scripting blocks, but other projects took priority. Excited and terrified (by legacy code) ...
Thanks for these questions, Justin. And for the extraordinary detail, you continue to provide fantastic reflections of this process and it seems apt to explain the flow in which this is embedded.
We have (1) an Artable form with a rich text field tha...
