Filterbyformula in two fields

[clement_desrues]

Hello,

With the API custom with a filterbyformula, I would like to collect all record, corresponding to my needs, from two differents fields.

“Conversation?filterByFormula=%7Bexpediteur%7D%20%3D%20%27${user.email}%27”

Like, in this case i would like to get all records into “expediteur” field where {user.email} corresponding. But now in my case, I would like the same but into two fields. (expediteur & destinataire) is it possible ? And how to write that ? Thanks you

[kuovonne]

First build your formula in the Airtable user interface. You will probably need to use the AND() or OR() function in your formula to combine the conditions. Once you have a working formula, the rest is string manipulation.

[clement_desrues]

This is not exactly what I need. Actually, i want to add another field into my API. I don’t know how to add another field next to “expediteur” …

[kuovonne]

What do you want the formula to look like before url encoding?

[clement_desrues]

I would like to search the records where the fiels DESTINATAIRE or the field EXPEDITEUR is equal to the {user.email}.

[kuovonne]

You cannot simply add a new field name to the filterByFormula value. You need to construct a valid Airtable formula.

For example, if the email is me@example.com, your formula before url encoding would need to look like

OR(
  {DESTINATAIRE} = "me@example.com",
  {EXPEDITEUR} = "me@example.com"
)

Once you remove white space you would have …

OR({DESTINATAIRE}="me@example.com",{EXPEDITEUR}="me@example.com")

After url encoding you would have …

OR%28%7BDESTINATAIRE%7D%3D%22me%40example.com%22%2C%7BEXPEDITEUR%7D%3D%22me%40example.com%22%29

[clement_desrues]

Thanks this is exactly what i need! Thank you