Bubble Airtable Client Portal - Help Needed Please

Need help APIs
1

Hey all, first forum post from me. Just looking for some help regarding the Airtable API and displaying data to only the relevant clients.

So here’s what I need to do. A client logs/signs up into the portal, and from there they can view campaign stats, reports, graphs etc. which are generated from data that is in Airtable and is already associated with the client via email address, company name, and website etc. I’m struggling to find a way to set up these constraints currently.

I’m also struggling with manipulating groups to just show a number/small set of data with the above constraints. Here’s an example of how I’m trying to get it to look like.

image
image980×147 5.28 KB

Any help here would be hugely appreciated!
Thanks.

2

You can leverage the Airtable API. Use “FilterbyFormula” and “Sort” features.

Go to your Airtable API list and create the URL that satisfies your requirement.

For example-

To fetch the list of records that have email “ankur@nocodetalks.co”- Url will be

https://api.airtable.com/v0/appbrOC2rNGKMq4wB/tblg6Qh7mNTfp8NCC?filterByFormula=SEARCH("ankur%40nocodetalks.co"%2C+email)