A few columns, one of those (CPO) is LINKed to secondary database. I selected the entry number 4.
Now if I click the “4”, it will show the structure of another DB with values of the 4th entry. All right:
Now my question is, how can I extract those values when working with the main database row? Let’s say I need the CPO_BB value.
Case 1: using “row created in main db” as a trigger, it won’t let me extract any values except the main one:
Case 2: I don’t see any way to automatically extract CPO_BB value to the INSERT_HERE column in the main DB. This way I could relate to the INSERT_HERE column instead
Hi @anp, at the moment, automations can’t directly read or “expand” values from a linked field.
If you need to use data from the secondary database (or multiple databases), add a Get Records action in your automation to retrieve the related records from that database.
If you always link the CPO field manually, you can set the INSERT_HERE field in the main database as a Lookup field. This will automatically display the CPO_BB value from the linked record — no automation needed.
Thanks @Thea, the Lookup did the trick partially. So it would load up the data in the database.
However there are two major downsides: 1) It won’t allow editing the fields in the row because that’s a hard link. 2) It won’t show the values in the Form. So after selecting the CPO it looks like this:
The desired workflow would be something like that after selecting the CPO in the Form it would duplicate hard-coded corresponding CPO values from the secondary db to the current row of the main db, update them in the form and allow them to be edited.
Is this achievable in the current state?
Hi @anp , thanks for the details. This is a known feature request — we’ve already added it to our backlog for future optimization. You can follow our release notes here for updates:
