How can an end-user add a row to Table 2 by clicking an ‘Add’ button in Table 1’s layout? I am looking for a way to set up a user interface where a button click in one table prompts the addition of a new row in a different table.
You can use an Add row action and specify the table you want to create a row in
Yes row action only work on the same table as row in it not on the different table.
The Add Row action can add a row to any table you want. You just need to configure the action to do so.
Please set up two tables: Table 1 (Course) and Table 2 (Lessons). In Table 2, create two rows, each representing a different lesson. Then, conceal Table 2 in the layout view. In this layout, you’re an end-user without admin rights and no direct access to the tables. When you navigate to a course in Table 1 (Course) and select it, you should see a list of the two lessons from Table 2(Lessons), including an option (a plus sign) to add more lessons.
Now, suppose you add a new course to Table 1. This new course initially has no associated lessons in Table 2. How can you, as an end-user, add lessons to this newly created course?
On your Courses detail screen, add a collection and set the source to be your Lessons table. Apply a filter to that Collection: CourseID is Screen->RowId. Allow adding records to that Collection. Done.
2 Likes