I am working on two tables of independent data: Tables A and B. The common denominator for each table is that they have a date value that I and other team members need to track.I've been able to create an automation where every time a new value on Ta...
Thank you! But wouldn't I need each lookup field to be linked to table A or table B? In other words, in Table C I'd need to have a Lookup A and Lookup B set of fields? Maybe I'm not understanding what you mean on the less work way.
Update: I might have found a workaround/solution:Trigger: When any relevant value on Table A is updated,Action: Find record on Table C that matches with the common value between Tables A and CUpdate record, Using the record ID as what's suggested un...
