Filter Bubble Table by Airtable email

Need help Plugins
1

Hi all -

We store our data in AirTable and want to use Bubble to visualize it. I’m having trouble figuring out how to filter the AirTable data in Bubble however. Specifically:

  • In the Bubble table, we need to filter the AirTable data to display only rows where the Bubble User’s email is contained in the AirTable record’s ‘emails’ field.

To explain more step-by step:

  • We have two groups: “owners” and “requirers,” stored in two tables in AirTable
  • In Bubble, our Requirer logs in (they are the user), and we want to show them a list of Owners (from AirTable), but want to filter only for the Owners associated with that requirer
  • In the Owners table in AirTable, we have a ‘requirer_emails’ field that lists the emails of all the requirers that the owner is associated with
  • So we would like to filter the Bubble table’s list of owners to include only those owners whose ‘requirer_emails’ field contains the Bubble User’s email

I thought that would be best achieved as follows:
image
i.e. set the data source to:
Airtable: owners:each item's requirer_emails contains Current User's email
Unfortunately that is throwing an error. I suspect that is because requirer_emails is showing up as a list of text, and Current User’s email is a single text?

Thank you for any advice!

2

RESOLVED: if anyone else encounters this, it’s pretty simple:

  • You should not put constraints in the “Data Source” field. in Data Source just put the table and value you want, and in the Constraints of that data source add the filters you want