Surface data from one database, based on data from another database being passed through URL

I have four user types: ‘Users’, ‘Companies’, ‘Sparks’, Contacts.

Contacts belong to sparks, sparks belong to companies, and companies belong to users. By default, I want a user to be able to click on a company, and see a list of sparks. When clicking on a spark, I want the user to see a list of contacts, linked to that spark.

In the Company database, I have a field ‘user_link’, set to ‘User’ type.
In the Sparks database, I have a field ‘company_link’, set to ‘Company’ type
In the Contacts database, I have a field ‘spark_link’, set to ‘Spark’ Type.

The user will view a repeating group with their list of companies, each with a button called ‘view’. This should send the user to a ‘company’ page, where all sparks, for that company are listed. I’m able to pass the company name through the URL, and retrieve this on the company page, but I am having difficulty creating a repeating group to show a list of sparks, constrained only to the company that was passed through the URL.

I haven’t built anything in my life, and this is my first experience with Bubble, so anything you can provide would be a huge help!

It’s simple…

On the Company page, as the datasource for the RG, just do a search for Sparks who’s Company is the current page’s Company.

Just figured this out also, thank you so much! I’m a noob to this… I’ll get there eventually :slight_smile: