Automation for related table

[umin-kyaw]

Hello Dear Sir,

I'll like to know how to do related data list in automation by using start and end expression.

I did create docs with start and end expression but didn't get related data list after generated docs.pdf.

Let see in attached files.

 

Please let me know how to do it.

Thanks 

[Aurelien]

Hi @umin-kyaw 

You syntax looks correct.

Would you mind checking and sharing us an app screenshot showing that this key does have any related drink?

Alternatively, when clicking on Data > Tables > (pick your table name) > button "View Data", you can check which related drinks are going with this item. Can you share a screenshot as well ?

[umin-kyaw]

Thanks Sir for your reply.

Let see my column details of two tables.

Drink Table 

Sale Table

Check view data

Please let me guide how to do Sir.

Thanks 

[Aurelien]

Thank you for your screenshots.

In the table "Sale", I see no column Drink with type Ref, refering to the table Drink.

Is it this one ? If so, you may want to name it "Sale" instead, so that you know that is a Ref column 😉

If my understanding is correct, this is what you currently have:

Can you check, when clicking on "View data" for the table Sale, that you retrieve a similar list under "Related Drinks" for the row a4cde723 ?

[umin-kyaw]

Dear Sir,

I can't do it according to your suggestions.

Please help me more.

[Aurelien]

@umin-kyaw 

Here:

[umin-kyaw]

I checked and see it.

[Aurelien]

Ok, this looks good so far.

Can you confirm that with this id, for example:

In the "view data" feature you can see any matching "related drinks" result ?

My assumption is that you generated a document about a sale record that does not have any related drink at the moment it is generated.

Would that make sense ?