Trigger to Create Multiple New Entries on a Different Table

[matrix1108]

Hi everyone! I'm looking for help with the following:

For my project, an "Enrollment"  will consist multiple "Lessons". The number of lessons each enrollment has could vary. It could have 6 lessons, 12 lessons, 18 lessons, etc. (also known as lesson_total)

To give you an idea, here's how they are related.

I created a DataPage so that the user can add entries in tbl_enrollment.

I want to set up a trigger so that if an entry in tbl_enrollment is created, multiple entries under tbl_lesson will be created, with the same enrollment_ID's. The number of entries created will depend on lesson_total in tbl_enrollment.

For example, if user inputted "12" in lesson_total (in tbl_enrollment), there would be 12 new lesson_ID's with the same enrollment_ID in tbl_lesson.

 

I hope someone could help me! Thanks!! 

[Aether]

Hi @matrix1108 - You may try using this trigger setup for your workflow:

[Aether]

If you're unfamiliar with loops and variables, you may want to check this tutorial by Ned:

 

[NiceDuck]

Adding this here. Just converted the trigger to adapt to bulk inserts.

 
 

[telly]

Hi ,

For more information about triggered action, you may refer to this article:
https://howto.caspio.com/tables-and-views/triggered-actions/