I have 2 tables “Issues” and “Maintenance” Issues table has a column called “ID” with UNIQUEID(), this is the key column , and column called “Issue”.
Within the Maintenance table I have a column called “Issue” with a reference to the parent table [Issues].[Issue] to allow me to select from
a filtered list depending on which property name I select. What I would like to achieve is, when creating a row in the Maintenance table, I would like to edit the parent row / Issue from the Issues table i.e. once I select an Issue in the Maintenance table and say it is “Repaired” I would like to edit the appropriate Issue row to set the column “Issue Resolved” to TRUE.
I had thought I could use a webhook / API to achieve this however in order to point it at the right row I need to have the Key ID for my JSON body (I think). So, is there a better way I could do this, or if I am on the right track is there a way to initialise a column with the value from a Key Column in another table? I have tried to use the app formula within column “ID Match” in the Maintenance table [Issue].[ID] and whilst this expression is valid it does not populate the cell with the UNIQUEID() from the referenced Issues table.