Sep 23, 2021
Hey there !
I’m struggling to automatically update some records that are in airtable bases.
I’ve got a flow into a google sheet with clean url, that I would match to same url into Airtable (but those may not be all clean.)
In Google sheet my urls are without “/” at the end
In Airtable 80% of urls are with " / " at the end, 20 % not.
Do you know how should I write my formula to search both case each time and update the record in question ?
thank you in advance !
Sep 24, 2021
Hi @William_Bet !
What should the formula search for and what do you want the output to be? Do you want the formula to remove the backslash at the end of the URL if there is one? If so, here’s a formula for that:
IF(RIGHT(URL, 1) = "/", LEFT(URL,LEN(URL)-1), URL)
Change “URL” to the name of your URL field.