Update Field in table to match lookup value

Does 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:

As 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.

While 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?

Thanks Adam…. that worked with a checkbox. How do I achieve the same result without user intervention of a checkbox? i.e, behind the scene.

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.