Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Integromat Search Airtable module - Formula to find 2 possible url finishing by "/" or not by "/"

Topic Labels: Automations
239 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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 !
Will

1 Reply 1

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.