In Table 1, I have various columns and one relationship array column which stores all the teachers mail id. For example: Row 1 will have following data
Lesson Plan [Maths, Triangle, Teacher1, Teacher2]
There is a tab based on Sheet 1 (Lesson Plan) and there is a button (open form) which take other field entries and upon clicking which will add row in Sheet 2 after asking certain more field value as describe above.
Now, I need 2 rows in sheet 2 (Homework Assignment).
How do i achieve this? Attaching screen shot with what i tried. But it is not working. Please Help!!
I wrote the above sequence as per my attached image: What system does is it add rows in my Sheet2 once when user click “submit” and then it starts the sequence and goes to “else” section. Again next time, it does the same activity. This mat all the time the sequence takes the “else” route.
Thanks Santiago for helping me out. Based on your advice i did few changes and could achieve the result.
Basically, in your master table, you need to pull the user profile mail id and make a template column on the uniqueness between the two tables. Then make a relationship between master and detail table.
While updating the records now, you can check the count status of relationship and take necessary action.
Thanks to [Robert Petitto] for helping me out through his videos.