this is my table
https://api.airtable.com/v0/app7MvgC7cKX7Zq7n/student?filterByFormula=class="2"&sex="male"
Solved
I want to filter multiple data using json url
+4Best answer by Justin_Barrett
First, your formula should be a valid Airtable formula. In Airtable’s formula syntax, the & operator combines items into a string. To get a valid test of both conditions, you will need to wrap the test in Airtable’s AND() function. Also, Airtable’s string comparisons are case-sensitive, so “male” should be “MALE” to match the data in your table. The modified formula should be:
AND(class="2", sex="MALE")
Then, as @Bill.French pointed out, you need to properly URL-encode that formula.
can you pls hlp me to this url
Sure, simply take the URL to this site and it will URL-encode it for you.
+4Sure, simply take the URL to this site and it will URL-encode it for you.
It’s not working for me :frowning:
+21First, your formula should be a valid Airtable formula. In Airtable’s formula syntax, the & operator combines items into a string. To get a valid test of both conditions, you will need to wrap the test in Airtable’s AND() function. Also, Airtable’s string comparisons are case-sensitive, so “male” should be “MALE” to match the data in your table. The modified formula should be:
AND(class="2", sex="MALE")
Then, as @Bill.French pointed out, you need to properly URL-encode that formula.
+4First, your formula should be a valid Airtable formula. In Airtable’s formula syntax, the & operator combines items into a string. To get a valid test of both conditions, you will need to wrap the test in Airtable’s AND() function. Also, Airtable’s string comparisons are case-sensitive, so “male” should be “MALE” to match the data in your table. The modified formula should be:
AND(class="2", sex="MALE")
Then, as @Bill.French pointed out, you need to properly URL-encode that formula.
Thank you for your feedback
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.