FilterByFormula - Exact match for Multi-Value Colu...

[Jean-Philippe_E]

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