Accessing Data from Second Level Connected Database

Hey @Ezequiel Souza 

I actually discovered how Pipefy implements the structure from above natively.

Here’s the solution:

1. Add a field to store the specific field from database 2 in database 1 (e.g. numeric field if it’s numeric data, with same name as the field in database 2).
2. Add connected field to database 1 - to database 2 records
3. Click “Advanced” on the connection field options
4. Click “Autofill Fields wtih connected card information”
5. Select the new field you created in database 1 and connect the database 2 field you want added to it.
6. Repeat step 1 and 5 as needed.

Hope this is helpful to someone else 😀

As for the process/ logic, I don’t understand your comment - and this could be my lack of understanding.

How I understand things, is that I was attempting to mimic something that’s used in standard practice to link database tables via ID fields. This is how relationships are established between databases.

In Pipefy the Connection Field takes the role of the ID relationship (simplified).

Perhaps I’m misunderstanding something here. Would love to learn - so if you have any ideas on how this could be structured simpler please let me know. Simpler is always better.