I have a table that registers appointments, including the person for whom the appointment is made. In the people’s table, there is a column called status, which changes over time. In the appointments table, there is a column where I want to save the status of the person at the time the appointment was made by linking the status.
My issue is that the status I save in the appointments table is a computed column, so it reflects the status in real time. I want to save the actual value of the status at the moment the appointment is created, rather than just linking to the real-time status.
I think you could submit the status through a user profile column when you create the new row.
You’ll need one more column in the appointments table to hold the status value.
Thank you for the suggestion! I don’t mind creating a new column, but I need to apply this to the rows that have already been created. Is there a way to save the status for the existing rows as well?
How many rows? Could you just update existing rows manually through the data editor?
Otherwise you could add a temporary collection to any screen pointing to the appointments table and filter it to show rows where the new column is empty. Then set the click action on the collection to Set Column and have it copy the computed column value to the new column. Then rapid click through all items in the collection until all of them are gone. Finally you can remove that collection from the screen since you won’t need it anymore.