Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 05, 2020 12:44 AM
I’m using integromat to automate some data from google sheets to airtable.
In this automation flow, I’m using ({record ID} = ‘string’) formula to match the g sheet cell with the airtable record id. For the most part this worked just fine until it came across a record that also had ’ in the record. This, I presume caused an error in the formula to not match the string as it stopped after the ’ character thinking that was the end of the string.
Is there an escape character I can use in this formula to solve this issue? Or is this something I have to solve in the google sheet for the matching strings?
Mar 05, 2020 08:28 AM
One option is to use double rather than single quotes.
"StringWith'Apostrophe"
Otherwise you could escape it like this:
'StringWith\'Apostrophe'
Mar 09, 2020 02:45 AM
Thanks Zollie,
Will give it a try!