Hello Everyone,
In my task application, I created a new table for recurring options and added it as a reference row to the tasks table using [Group ID] so that I can update the recurring option for all tasks in the same group at once. This allows me to update the recurring option for all tasks in a group simultaneously. However, I also need to record the ID of the specific task from which the update was made in this table.
How can I achieve this?
I am not clear on your app data structure. However, whenever there is a struggle of updating a column in one table with a value from another table, it usually means you need to use the INPUT() function. This function serves 2 purposes:
a) provides a pop-up for user to enter a value
b) allows to dynamically pass a value between actions.
I think useage b) is the one you need. You can get more details on how to use the function in this way here
I hope this helps!