
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 28, 2020 09:17 AM
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 04, 2020 09:22 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 28, 2020 09:39 AM
Assuming the filter is correct, that URL needs to be URL-encoded.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 28, 2020 09:42 AM
can you pls hlp me to this url

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 28, 2020 10:57 AM
Sure, simply take the URL to this site and it will URL-encode it for you.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2020 10:38 AM
It’s not working for me :frowning:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2020 10:55 AM
This is not enough information for anyone to help you.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 04, 2020 09:22 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 04, 2020 09:30 AM
Thank you for your feedback
