How do I display a single row from one DB based on a cell variable on another DB (Video)

Need help Database
1

Hey everybody, thanks in advance.

I am trying to display based on an ‘if contains’ statement based on two databases to display.

Example:
If user inputs order 17699, then it looks that value up in database 1, then, if trello_list_id matches 283ydw62yw61ys61ys61, then display row 4 in database 2.

Here is a 2-minute explainer video showing what I am trying to do and the actual data I am working with. Video link via slack: https://slack-files.com/T09H0GB3L-F01HB7UGV3Q-10ceb24e15

2

Hey, welcome to the Bubble forum :slight_smile:
Just so I understand correctly, are you trying to map each order to a single status type? How does the Trello id map to the order status types?

3

You got it.

So basically and maybe to help with clarity:

If order ID in Database 1 has one of about 20 different trello list IDs, it will display a specific response in Database 2. Not sure if that makes it clearer.

For a more visual response:
Database 1:
Order ID: 17699
TrelloID: 283ydw62yw61ys61ys61

Database 2:
Trello ID: 283ydw62yw61ys61ys61
Trello Description: This is a generic description.

So… if someone searches number 17699, I want to display the text in database two that says “This is a generic description”.

4

OK, couple of ways you could approach this.
You could add a field in your ‘List of statues’ called ‘Trello List ID’ and tick the list option when you add it. Then you would add the Trello IDs to each relevant List of status. In the editor, you’re then doing a search for: List of statues (with search constraints being Trello ID contains Order x’s Trello ID).
If you can share the Editor then I may be able to help

5

The other way would be to create a mapping data type called Trello ID with a column for List of status (type is List of status) and a column for Trello ID. You then have a 1:1 mapping for every Trello ID.
To fish out your order status, you’d do order x’s Trello ID’s List of status. This would avoid having to do a search. The data structure is more complex but might be better performance.

6

Thanks. I am looking into now. How do I share the editor with you? I only see a way to collaborate via email invite.

7

Settings >> General , change Application rights to Everyone can view or Everyone can edit, and then copy the URL to the editor of any page in your project and send (or DM) the URL.

Or make a test app and share it (if you don’t to share your app)

8

Hi Simon, I am such a new user I don’t think DMs are activated. Can you send me a DM and I can reply back with the URL.