PDF does not show information from child tables

[ECardoso]

Good afternoon from Brazil.

Dear community friends, I have a table where I have several child tables.

When I create a bot to generate a pdf, it only populates the parent tables. Child tables are not populated.

I see that this is the doubt of several people and I can't find a solution.

Can anyone tell me what happens?

I remember having created other bots in appsheet with these same functions and that didn't happen.

Can someone explain to me ??

@Steve 

[jkevz]

Make your parent table reference (ref) to the child table. So that it displays the  related child table in your parent table detail view.

[ECardoso]

my friend, My template is this... automatically generated. When I create a form with this configuration, only the parent table is populated. the rest is blank.

[ECardoso]

this is the example of what i mean

[jkevz]

Remove the "s" in id column.

<<Start: [Related child table]>><<[id]>>

Other than that there's no problem with your template, unless you remove as an outline the child table 

[ECardoso]

Can you understand ??

What did I do and how did it turn out

[jkevz]

Can you show me your detail view?

[ECardoso]

look

[jkevz]

From your detail view, where did you place your action? You place it as "Display in Primary"?

[jkevz]

This is my detail view 👇

This is my template 👇

This is the result 👇

Do not change something that may cause the outline of your template will get affected 

[ECardoso]

is the item description column the key ?

can you show me the screenshot of your atomation

event and step

[jkevz]

My item description is not the key. I have "key column" that I hide and it's related to the parent table.

My automations 👇

 

 

[ECardoso]

And in every app I create, it looks like this

[jkevz]

From your detail view, where did you place your action? You place it as "Display in Primary" or "Display Prominently"?

[jkevz]

Try to "Display Prominently" or "Display Inline" your actions and try to generate again.

[ECardoso]

I didn't create an action.

I created a Bot so that every time I save a form, that form is saved in my google drive in PDF format.

Then I create an action that allows me to open this file that I had just saved.

[jkevz]

Show me your bot (screenshot)

[SkrOYC]

If you have those "IsPartOf?", you need to create the child records first, then generate the report.
This means that a report made on parent creation won't work as you expect

[ECardoso]

this is not good,

first I have to create the child records and then the parent, for it to work.

What do I need to do to make it work in order: parent - child

[ECardoso]

@jkevz07 

Do you create the child record first and then the parent ???

[jkevz]

Nope. I created parent then child.

I think you should add an action and display Prominently or Display Inline in your detail view of your parent table. 

[ECardoso]

So I understand that it is already displayed Inline

[ECardoso]

My automation

Events

Process

[SkrOYC]

---

@ECardoso wrote:

first I have to create the child records and then the parent, for it to work.

---

No, you just have to change your trigger event.
This is clearly explained inside the documentation, you can't print a row and it's children when adding children as part of a IsPartOf? workflow because AppSheet saves records sequentially.
If you expect to have the children but your bot is fired on parent creation, when the parent is added the bot is fired but the children are added after that

[Steve]

Send an email only after adding a parent record and all of its children

[ECardoso · Accepted solution]

I created a column called status - type number

I created a DATA action: set the values ​​of some columns in this row

Set These columns status --> [Status]+1

In the Ref Views of my Form in Behavior - Form Saved I pointed to status

In Automation EVENT I put the condition [_thisrow].[status] > 0

IT WORKED!!

[oybek94]

Hi, I have the same problem as you. I'm having a hard time understanding what you wrote. Please show me how you did it with a picture

[ECardoso]

1 - in the parent table I created a column named trigger
2 - I put the type of this column as number
3 - I created an action like: DATA: Set the values ​​of some columns in this row where
Set these columns Trigger with [Trigger] + 1
4 - in ux Table Form UX/Ref Views/Behavior/Event Actions/From Saved
place the previously created action
5 - In the event of your automation

put the condition

[_thisrow].[trigger]>0

6- See the magic happen

Hope this helps

[oybek94]

Everything worked out. You gave a wonderful explanation, thank you.