Workflow Order

[jujogar10]

I have to workflows, on the parent table and other on the children table. I need that the workflow on the children table runs first. The workflow on the parent table sends an email. the email is leaving with blank info, it seems that is going out before the workflow on the children table.

[MultiTech]

Unfortunately work flows will only go in the order in which the records are synced, and you can’t create a child record without creating the parent record first; what I mean is when you’re using the app you’ll create the parent record first, which then causes your work loaded fire off.

If you want it to wait till after the child record, you’ll have to create a system that watches for the right condition, something like the related child records isn’t blank, then it fires off.

But you’ll have to initiate that off of the child table save, or initiate another few actions that trigger the workflow for your parent table.

[jujogar10]

Do you know if I triggered from the children table, does every record trigger the workflow? or It will triger only once?

[MultiTech]

Depends on the workflow:

for adds, it only runs when adding a new records;
updates run on every save after the first;
delete runes only when deleted.

If you don’t put a condition on the update workflow, then yes it will fire off on every update.

You can read more on workflows here:

help.appsheet.com

Workflow

Send Email, SMS or Notifications on Add, Update, or Delete.

[Phil]

I am not sure if it is relevant but topic “Sending Email After Adding a Parent Record and All of Its Children” in this article may be helpful https://help.appsheet.com/en/articles/961707-workflow

[jujogar10]

Thanks, I tried this and the form saved event is not working, any ideas why. I have followed the article instructions.