Create multiple records in “child” table conditionally

[Alison]

Hi,

Can someone share a solution which allows me to create multiple records in “child” table conditionally? 
I have a table “Parent” in which there are two fields “date from” and “date to”, so I need to create 3 child records if for an example I select date from 09/28/2018 and date to 10/01/2018.

Thanks,
 

[Vitalikssssss]

Hi @Alison,

You can design Trigger in such a way which allow you to achieve the desired functionality.

You need to make sure that:

1. Your parent/child table has one-to-many relationship;

2. You create a special table which will be used as insert template.

3. Please note that you would need to list the same number of records in insert template as the number of days which you could have in the date range.

4. You need to create a Trigger.

You may import my example into your account and check the structure there. 

Regards,

vitalikssssss

Submit_multiple_records_date_range_1_0_2018-Sep-28_1423.zip

[kcastagnaro]

Hi, Vitalikssssss & Alison,

 

I have a similar situation to Alison. I imported the solution above but it doesn't seem to be working for me. I get 15 records added when the day count is 5. Any help would be greatly appreciated. 

[Vitalikssssss]

Hi @kcastagnaro,

Well, Caspio has release some Triggered Action enhancement called "Loops" that could simplify the solution.

As of now you would need to have two tables (i.e. three before). First table would hold event name and start and end date. The second table would hold each day of the event as a separate record. So the Triggered Action would look like the following:

The package with tables and Triggered action here.

Hope this helps.

Regards,

vitalikssssss

 

[kcastagnaro]

vitalikssssss! this worked great! Thank you so much!