How to get data from Airtable of a specific user to show up in Weweb?

Hi, I am needing to display some client specific data from Airtable onto Weweb.

I have a “Customer” database in Airtable, and I have another table called “Data” in Airtable. I am also using Xano for auth so I also have another “user” table in Xano. These 2 (“Customer” and “User”) are identical.

My question: How do I “Get” all the records of a certain user from my “Data” table in Airtable? I hope this makes sense. I know how to get all the records of a particular table, but I only want records by the logged in user, and to be able to do so without compromising the security of the data.

Hi @raelyn :wave:

I guess you could use the “Filter by formula” option when creating a One user data collection.

Bear in mind that filters by formula are a performance tool, not a security or privacy tool because the query parameters are visible in the API call that is made to Airtable by the frontend.

This is not specific to WeWeb. It is how Airtable’s API currently works.

Does that help?