Help

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

Topic Labels: Automations
1869 1
cancel
Showing results for 
Search instead for 
Did you mean: 
William_Bet
4 - Data Explorer
4 - Data Explorer

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
Per_Carlen
7 - App Architect
7 - App Architect

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.