Intersect Airtable list with Custom state list

dimitri2 · 2024-07-31T19:47:53.877Z

I’ve linked an Airtable database to my Bubble app. In Airtable, I have a table of ‘Experts’ and a table of ‘Competencies’ (specialties). These are linked together, so an Expert can have multiple specialties.

I also have that same Competency list in Bubble as an Option set.

In the Bubble Airtable plugin, I have the tables set up correctly, with the Experts table linked to the Competencies table, with “list of records” marked yes.

I have a page with a repeating group of Experts.

I also have a filter panel, which is a repeating group using the Competencies Option set.

There’s a custom state for the page ‘admin’ called “Competencies filter” .

I have workflows that add/remove Competencies from the Custom state when you check/uncheck the option.

I’m now trying to filter the Repeating group of Experts using an intersect, between their Airtable competency list and the Custom state. However, this is producing an error.

Is there a way to set this up?

Zeroic · 2024-07-31T19:58:28.934Z

I think it might be taking it as an intersect with between your list of texts and the This Expert’s Competencies:count

Instead, what you can do is; go to Settings → Versions → scroll down toBeta Features and check the Expression Paranthesis

Ideally, then set the condition as:
(expert’s Competency filter intersect with This Experts’s Competencies):count is not 0

dimitri2 · 2024-07-31T21:01:07.810Z

It’s still asking for More from the Airtable “This Expert’s Competencies”

dimitri2 · 2024-07-31T23:42:35.370Z

I figured it out:

You need to reference each item’s Name, which is the specific field within the Competency table.

system · 2024-10-09T19:48:09.231Z

This topic was automatically closed after 70 days. New replies are no longer allowed.