Creating and adding childrecords

[BertM]

This is the issue: I want to create child records and than count  the number of child records that was created. And store that number in a data field in the parent record. Probably in one triggered action, because different triggered actions is not allowed. What to do?

[NiceDuck]

@BertM If the creation of child records will originate from creating parent record as well, you can use this trigger on the parent table.

If you dont have an update trigger on the parent table, this should work properly with @AtayBalunbalunan's trigger. Otherwise, you would have an cascading error.

@AtayBalunbalunan, thank you for the tip about getting the count, I did not know that you can get the count of records with just the 'expression field', I thought that a group function is required for that.



 

[AtayBalunbalunan]

This may be possible using triggered action depending on your workflow. How are you going to add new child records?

If you are stamping an ID from the parent record to the child record upon insertion, you can update the value of the total number of child records in the parent record. Below is a sample.

Your trigger will be different based on your table design.

[BertM]

On 8/9/2020 at 11:17 PM, BertM said:

This is the issue: I want to create child records and than count  the number of child records that was created. And store that number in a data field in the parent record. Probably in one triggered action, because different triggered actions is not allowed. What to do?

@AtayBalunbalunan and @NiceDuck Thank you, problem solved