Adding Items to Item Group in Seperate Table

1

Hey! So, in my project I have a table where a user can input procedures (name, description, etc.) and a different table where the user can add steps on how to complete the procedure. I linked the tables, but I am not sure how to add a text input that allows the user to select the procedure by its ID and add steps to it. Thanks

2

Two approaches come to mind:

  1. Have an interactive table widget with a record placeholder for the Procedures table, and have the user select the row in the table corresponding to the procedure for which tesps need to be created/added.
  2. Create a table query/aggregation combination on the Procedures table to return an array of the Procedure IDs, and use this array as the data source for the selectable options for a single-select widget.
2 Likes