Currently I have 2 tables and would like a row on driver list(table2) to be updated when an action is run on open runs(table1).
Mostly I need help figuring out the referenced rows expression. Currently I have this
FILTER(“Driver List”, Name = [Assigned Driver].Name)
But it doesn’t seem to be finding any driver/row on the driver list table.
Assigned Driver is a reference field on the open runs table, referring to a row on the driver list table.
A similar question seemed to have been asked before, but they didn’t directly discuss the expression and I am stuck at the moment.
Any help is appreciated!!