I have a base where I have a table that is a list of product names. I have another table in the base which is a synced source of data from emails, where I have the same product names and a few other fields coming in. Basically, the goal of the exercise is to somehow indicate to the person creating a new record that the name they just created already exists in the synced table. Ideally, this would be a signal in another field on the table, such as a flag (already exists). In which direction do I need to do a linked record field? I can’t use the product name as the linked record because they may actually be creating a brand new one that doesn’t exist in the synced table, and that’s fine.
How do I pull in other fields from another synced table if the record name matches the other table? I can’t figure out how to arrange my fields.
Synced Table (the one I want to pull stuff from):
This feels exceptionally simple and I’m way overcomplicating something but I’ve been going in circles for too many hours now. :slightly_smiling_face: