Help

How to performe a Reverse FilterByFormula ?

Topic Labels: Automations
277 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jean-Philippe_E
7 - App Architect
7 - App Architect

Hello,
I don't know how to perform the following query in a Script code:

1. I have a table A of records with field short URL

  1. https://my.url/path1
  2. https://my.url/path2/path3

2. I have a table B of records with field long URL (like https://my.url/path2/path3/path5?x=y )

Given a record from table B, how can I find all records from table A that have a short URL starting like the long URL ?

  • Should I iterate on all records of Table B and check if shortURL indexOf my longURL
  • I can't short/cut my longURL then query Table B (because I don't know where to cut)
  • May be there is an AirTable formula? that check if record's field is part of my longURL ?

Thanks

0 Replies 0