Is it possible to link an API column to a bubble table column?

Need help APIs
1

I have the following two data sources:

Table 1 - People (Bubble Table)

+---------------------+
| person_id | person |
+---------------------+
| 1       | John   |
+---------------------+
| 2       | Ash    |
+---------------------+
| 3       | Jane   |
+---------------------+

Table 2 - Purchases (API)

+-----------------------+
| person_id | purchase |
+-----------------------+
| 1       | Shoe     |
+-----------------------+
| 1       | Wallet   |
+-----------------------+
| 1       | Ring     |
+-----------------------+
| 2       | Wallet   |
+-----------------------+
| 2       | Shoe     |
+-----------------------+
| 3       | Shoe     |
+-----------------------+

API Link

How do I filter a repeated group table of people based on the ‘Purchase’ value as such:

Repeated Group

Selected Dropdown: (Wallet)
+---------+
| Person  |
+---------+
|  John  |
+---------+
|   Ash  |
+---------+
4

I think the repeating group’s source would look something like do a search for users and – inside of that – a constraint would be person_id _ is in _get data from API's person_id

5

@rico.trevisan

The constraint you suggested isn’t an option unfortunately.

Screenshot 2023-04-19 at 00.55.15
Screenshot 2023-04-19 at 00.55.151834×792 118 KB

The available option is person_id _ is in _get data from API's: EACH ITEM'S person_id which didn’t work

Would you please be able to look at the live editor below?

6

@rico.trevisan

I’ve now tried a 2nd method which was able to filter the table correctly, however it involves ungrouping the dropdown choices. (Which wouldn’t be a viable method due to it showing duplicate options)

I’ve added this second method to the editor. Any ideas?

Screenshot 2023-04-19 at 07.42.02
Screenshot 2023-04-19 at 07.42.022212×630 110 KB

7

I’ve updated it. Now you got 2 methods that work. See if it makes sense to you.

1 Like
8

Thanks @rico.trevisan , you absolute legend!

I had spent 2 days trying every possible iteration trying to figure it out.

For those in the future reading this after the editor trial has expired, here’s the solution:

DropDown Settings

  • Choice Source: Purchases: grouped by purchase
  • Option caption: Current option's purchase

Repeated Group Settings

  • Data Source: Search for people
  • Type value: person_id is_in Purchases:filtered's person_id
  • For the above ‘filtered’, set purchase = Dropdown value's purchase
1 Like