Archived from the Bravo community forum (2021–2026). Some answers may refer to older versions of Bravo.
i have a airtable base with all the payment done by my clients
in 1 column there are all the email in an other one all the payments done by that email (some payments are repeated many time from the same email )
all this email I add manually on firebase this because I had all this data already so no one has to sign up because I add each user manually to firebase………
my question is……
how can I get a list of the payment show only the payment done by that user ???????
when the user log on the app and go to the “invoice page” how can I show only the payments done by him alone ?
I did already filterbyformula like MIKE explain on YouTube but doesn’t work……
on the screen shot you can see
firebase Authentication (only 2 user are at the moment)
Airtable set up
get list address
bravo vision test still show all the payments /
18 replies
Sorry what does it mean ?
Set up the filter by formula like this on the GET request
@Valter Guerreiro I can do same with user.email right ??
@Valter Guerreiro @andrea Borrelli Yes, that should work! 🙌
https://api.airtable.com/v0/YOUR_BASE_ID/YOUR_TABLE_NAME?filterByFormula={Userid}="${user.id}"
or with email
https://api.airtable.com/v0/YOUR_BASE_ID/YOUR_TABLE_NAME?filterByFormula={emailid}="${user.email}"
Make sure to use test values 😃
@andrea Borrelli if you dont have a login guess not
@Marielle Ibias emailid should be the name of the coloumn I want to be filtered right ????
Where I will put all the email of my clients
@andrea Borrelli yes! It’s the name of the field you want to be filtered
@Marielle Ibias
hy I did filterbyformula but no data appear
@Marielle Ibias hy I did the get list request with filter by formula
I tried to log with some clients email but when I go to the invoice page still I can see all the invoice and not only the one belong the the user 😭
@andrea Borrelli can you share the url request so I can test? Its not clear in the image
@Marielle Ibias Hy did you receive the URL ??
Hey @andrea Borrelli, I’ve received and reviewed.
Your API request URL looks mostly correct, but there's a small mistake in the way you're using the filterByFormula parameter. The correct syntax for filtering by a field named "emailid" with a specific email value would be as follows:
https://api.airtable.com/v0/appYjbwILk3zR9IEs/Ricevute?filterByFormula=({emailid}="${user.email}")
Make sure that the field name "emailid" is indeed correct and matches the field name in your Airtable base. Also, ensure that you replace ${user.email} with the actual email value you want to use for filtering.
Remember to include the necessary authentication headers in your request, such as the "Authorization" header with your API key.
@Marielle Ibias Ok the airtable the field name match (emailid)
What does it mean
“Also, ensure that you replace ${user.email} with the actual email value you want to use for filtering.“
What does it mean
“Remember to include the necessary authentication headers in your request, such as the "Authorization" header with your API key”
Thanks
@Marielle Ibias I send you a screenshot of my App on bravo vision
1st page (authentication)
MENU PAGE
Invoice page
But as you can see in the screenshot in invoice keg there are to many records that should be only the one belong to the email I entered
@andrea Borrelli
- About the ${user.email} variable, add a test values with an existing email in your Airtable and test the request if its being filtered. I’m using [email removed] but use any from your Airtable.
- About “Remember to include the necessary authentication headers in your request, such as the "Authorization" header with your API key”. Replace the XXXX with the personal access token.
- Is your login configured Firebase? Please follow this guide: https://docs.bravostudio.app/get-started/help-and-tutorials/app-cases/build-a-notes-app-with-user-id-and-email-from-firebase
@Marielle Ibias hi
I did the test with some email from sortable and when I send the request still all the data appear and it is not filtered 😟
Wrote something in this thread and want it removed? Request removal
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