Problem in creating a detail record from master record

Hello Experts,

I have two sheet for this particular query of mine.

Sheet 1 - Lesson Plan [Subject | Topic | Array of Teacher mail]

Sheet 2 - Homework Assignment [Subject | Topic | Teacher | Initiated | Alloted Time]

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!!



Hola @Kamal_K_Jalan

I am having trouble understanding:

What exactly do you need in Table 2?

Table2 is my Sheet2.

There is an relationship set up in my sheet 1 with some other table. For example, lets say that there are 3 values in that array field.

Now in my sheet 2, I will have 3 records each corresponding to one value of the array and it should not be duplicated.

Hope i am clear, if not request you to please have a 10 mins google meet session as per your time availability.

Regards

Just to mention,

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.

So you want to pass info from your table 1 to table 2 through the form, right?

To do so you can click on the + sign as in adding components and scroll down to screen columns.

This gives you access to the columns on your table 1, provided your form is in table 1, then you can add them to your table 2 through your form.

I hope this helps.

Thats ok and straight forward if I do not want to validate before adding rows. I guess if you dig a little deeper in my question.

I need to pass the values to Table 2 based on certain conditions and those conditions I want to check through the action sequence before adding the row.

Thats where I am facing issue.

Have you tried to use a custom form?

This way you can set better conditions to your actions as these will be set before sending the info to table 2.

1 Like

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.

2 Likes