Query parameters airtable

Hi. It seems that the query is not working for airtable. I would like to make a chart from data filtered by a specific user. Thanks in advance for any help. Regards

Hi @jorgemartins55

Welcome to the forum!

You can use the filterByFormula query to filter records in to show in lists and charts. Can you share some screenshots of your setup so far? When you say filtered by a user, do you have your users also in Airtable?

LINK CONNECTION AIRTABLE1

Those are the pictures with config of Adalo with Adalo.

Thanks in advance for your help

Hi @jorgemartins55,

Seems that your filter in Query Parameter is not correct.
See here: Filtering Airtable Lists - Adalo Resources

Name - you put filterByFormula
Value - you put ({user} = ‘aa@aa.com’)

Best,
Victor

1 Like

Hi Vitor. Thanks for your help. I followed your suggestions but query is not working. is there any alternative ?
regards,

Captura de ecrã 2021-02-18, às 09.05.31

1 Like

@jorgemartins55 hey your query parameter should be in the editor while filtering the results, no in the external collections setup.

1 Like

Hi @jorgemartins55 ,

@bhanu is 100% correct. There is no need to use filterByFormula in the connection setup. Use it later, when you do the actual list filtering.

Best,
Victor