I would like to populate a linked filed with the lookup field coming from different table. How do I automate this
Solved
Update Field in table to match lookup value
+2Best answer by Kamille_Parks11
You can achieve the same result by selecting a different trigger.
You can try “when record is updated” and select either the Lookup field or the Link to Record field as the “watched” field. The field you select depends on your use case:
- If the value should always match the look up field, even if the look up value changes long after the record is created, select the lookup field.
- If the value should match the lookup field at first, but not auto-updated itself forever, select the link to record field.
+31Does this look right? If so I’ve set it up here for you to check out!
Here’s how the Lookup table’s data is structured and the automation setup:
The tricky bit is setting the value for the Linked table field and here’s a gif of how to do that:
+12As Adam mentioned would be the way.
But, from a database design perspective, that’s duplication of data. With properly designed bases, such workarounds shouldn’t be required. Rollups and Lookups should be used due to reliability.
For frontend design in apps like Softr, I rollup/lookup recordIDs instead for easy filtering etc.
+2While I agree with you 100% that I will have duplication of data. I have an issue because in my table some rows the user needs to input linked field and in other rows the linked field is per-populated. So my thinking is if the row has per-populated data, then the automation will update the blank manual linked field with the per-populated one..Do you see any other option?
+2Thanks Adam…. that worked with a checkbox. How do I achieve the same result without user intervention of a checkbox? i.e, behind the scene.
+27You can achieve the same result by selecting a different trigger.
You can try “when record is updated” and select either the Lookup field or the Link to Record field as the “watched” field. The field you select depends on your use case:
- If the value should always match the look up field, even if the look up value changes long after the record is created, select the lookup field.
- If the value should match the lookup field at first, but not auto-updated itself forever, select the link to record field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.