Start expressions did not get any value from child table

[frankwanglinked]

Hi, I use a bot to generate a pdf, but when i trying to modify pdf temples using start/end expressions, and I just test the bot, seems working good, the pdf can get all the child table values. But when i operate in the app, the pdf did not get any value from child table.  Am i missing anything? Please help me out, thanks ahead.

Here are some screen shots:

[AleksiAlkio]

It sounds like you are adding childs at the same time than the parent because of the "Is part of". Am I right?

[frankwanglinked]

seems yes.

[frankwanglinked]

I got Receiving table as parent, ReceivingLog table as child. This pdf bot is going to triggered when receiving form saved, and for sure, the receiving log was submitted at the same time when receiving form saved. Could you share with me any solutions on this?

[AleksiAlkio]

The reason is simple.. the Bot is triggered before child records are saved. That is because the parent needs to be saved first so the Child records would have a valid parent ID.

If you trigger the Bot later, it works because all child records are already saved.

Now you need to trigger the Bot with Updates, not with Adds. To do that, you need to have an Event action triggered from the Parent_Form. The action needs to update something in the parent..  like for example a timestamp with NOW().

[frankwanglinked]

I've tried this method, but cannot trigger the bot...

[AleksiAlkio]

What does the Audit history say for the reason? 

[frankwanglinked]

the condition always False, seems like the status did not changed

[AleksiAlkio]

This is not from the Audit history. You can find it from Editor > Manage > Monitor > Audit history > Launch log analyzer

[frankwanglinked]

pdf bot not showing up

[AleksiAlkio]

Have you specified that the Bot should run with Updates only?

[frankwanglinked]

yes, i did.

[AleksiAlkio]

Does it work if you open the existing parent record and then modify it keeping the [Status] as "Run"?

[frankwanglinked]

it seems status not been set to Run. But I do following that instructions...

[AleksiAlkio · Accepted solution]

Use a DateTime column and then use NOW(). That you don't need to reset as it is always different.

[frankwanglinked]

Sounds would work, but I am a newbie on appsheet, could give me more detials about how to doing this? Thank you.

[frankwanglinked]

Hi, AleksiAlkio

finally, I think I just worked it out!! thanks you so much for your patient, i looked back to all my forms, turns out i put the set status from run to blank to a system generated form, but actually, the form that i use for is another one which i created from a slice table. 🤣 i was so stupid....

[AleksiAlkio]

Good to hear!