Re: Template using Google Docs

paula · 03-14-2023 02:00 AM

Hi all,

For my email template, I'm using the table Form to get the details like client name, address, etc. But I want to display the items too - which is in a different table. Is there a way to do so? Thanks a lot in advance!

Aurelien

Hi @paula

You may need to have a look to the documentation:

Use Start expressions in templates - AppSheet Help

Otherwise, here are some posts that may illustrate how to do so:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Template-Extra-Line-in-Nested-Tables/m-p/277790

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Aligning-Table-Rows-in-Template/m-p/313331

paula

Thank you sir!

However, if I correctly understand, they're talking about the Tables in the google docs, while I'm talking about the Table inside the Bot from which I'm getting the data.

This are the tables, I want to get details from Add Items table to put in my email template.

Thanks again!

Aurelien

OK, thanks for clarifying.

However, is this statement still correct?

@paula wrote:

For my email template, I'm using the table Form to get the details like client name, address, etc. But I want to display the items too - which is in a different table. Is there a way to do so? Thanks a lot in advance!

If so, you probably have a column named "Related Add Itemss" in your table Form.

And then, your expression would then be:

<<Start:[Related Add Items]>> {your information to display} <<End>>

Can you confirm?

paula

Thank you again,

Yes, that's correct. I see that you're talking about the related item which should be the child table of my parent table Form. I'm still reading the Start Expression article. Slowly trying to understand and relate to what I'm doing though it's written in simple words. One more thing please, where do I put that expression? Is it in the template? In which part if so? Thank you so much!

Aurelien

@paula wrote:

Slowly trying to understand and relate to what I'm doing though it's written in simple words.

You may want to read this for a better understanding:

References between tables - AppSheet Help

@paula wrote:

One more thing please, where do I put that expression? Is it in the template? In which part if so?

You may want to try it this way (this is a random example, you need to adapt it to your case):

TimeStamp	Item description	Item picture	Item quantity
<<Start:[Related Add Itemss]>><<[timestamp]>>	<<[description]>>	<<[photo]>>	<<[quantity]>><<End>>

paula

This is the child table,

Then, say this is what I wanna get from that table,

Then should I do it like this?

Thank you!!!

Aurelien

The child table should a a Ref type column to your parent table. Otherwise, the "Related XXX" should not work.

I think the table structure needs to be reviewed.

Can you read this?

@Aurelien wrote:

References between tables - AppSheet Help

Otherwise, your template looks almost correct. Just set the <<End>> in the last cell, on the very right.

paula

Thanks!

I already referenced the child table,

And this is now what's in my template,

But why is this not working?

Aurelien