Skip to main content
โ† Data, API & Backend
Data, API & Backend September 8, 2022 ยท 4 replies

2 filterbyformula

Archived from the Bravo community forum (2021โ€“2026). Some answers may refer to older versions of Bravo.

How to construct url with 2 filterbyformula
filterByFormula=search("${user.id}",arrayjoin(userId))
and
filterByFormula=search("${day}",arrayjoin(day))

4 replies

Aymeric September 8, 2022

filterByFormula=AND(search('${parameter1}'%2Carrayjoin(parameter1)),search('${parameter2}'%2Carrayjoin(parameter2)))

Jen September 8, 2022

I already tried this and did not work when there's a variable.
This works

AND({userId}="0123",{Day}="Day 001")

But not this one

AND({userId}="${user.id}",{Day}="${day}")

Also does that work with arrayjoin?

Wrote something in this thread and want it removed? Request removal

Still stuck?

Ask the community on Discord

This archive is read-only. New questions, office hours and product updates now happen in the Bravo Discord.

Join the Discord