Populate a second table based on form input and reference data

[M_Felix]

Hi Community,

Good day, I would like to ask assistance on how I can do the function described below.

Example:

I have a form where I can input NAME and select a desired COURSE.

Name: Juan dela Cruz
Course: IT

After I save the form, a second table “MySubjects” needs to be populated automatically. I have two reference tables.

CoursesReference - contain the list of courses that can be selected in the form SubjectsReference - contains the subjects that should be assigned to the person depending on the course he chose.

I have attached a screenshot on how I envision the tables.

I believe this kind of function is possible by performing a group of Actions.
I am still new to Appsheet so any help will be greatly appreciated.

Thanks.

[1minManager]

You’ll need to create an Automation bot which looks for these new rows being created. Then you’ll need to cerate an action to “execute an action on a set of rows” to look at the CoursesReference table. This will then call an “add a new row to another table using data from this table” action to create the rows.

To make it easier, I’d strongly suggest merging the CoursesReference and SubjectsReference tables.

I don’t think you’ll need to MySubjects table at all if your users are going to have a login. You can just create a slice using UserEmail()

[M_Felix]

Hi @1minManager ,

I am already able to select the data which I need to write on the second table but I cannot formulate the action to write the result.

This is the action I have

This is the result of the action

[1minManager]

You need another action of type = “execute an action on a set of rows” The action above would then call this new action

[Steve]

https://community.appsheet.com/search?q=@steve%20faq%20rows

[M_Felix · Accepted solution]

Thanks @Steve,

I was able to achieve the workflow from this FAQ.

FAQ: add a set of rows Tips & Tricks 💡

When a row is added to a table, add a set of rows to another table. Try the sample app! This example uses three tables: Master Table: when a new row is added here, all rows from Source Table will be copied to Target Table and linked back to the new Master Table row. This table must allow adds. Source Table, from which all rows will be copied to Target Table. Target Table, to which all rows from Source Table will be copied. This table must allow adds. Action 1: Copy Source Table row…