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 !