Good day, I would like to ask assistance on how I can do the function described below.
I have a form where I can input NAME and select a desired COURSE.
Name: Juan dela Cruz
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.