blank email template fields in start expression

[Hyman_van_Zyl]

Hi, 

Have any of you experienced receiving all blank fields in an email template table with a start-end expression while the number of table rows produced in the template corresponds with the in-app virtual column formula-produced rows which are not blank?

I was hoping there is maybe a simple trick about this.

Thank you,

Hyman

[Hyman_van_Zyl]

So the table in the email template shows the correct number of rows that there should be but the values are blank. In the app, it works fine.

[Steve]

Huh?

[Hyman_van_Zyl]

Hi Steve, thanks for having a look. Yes, double huh : )

I use this formula in the app: SELECT(Category Report[EntryID],NOT([Full Report Sum]=0)) where [Full Report Sum] is - SWITCH([FPeriod], "Custom",[Full Custom], "This Financial Year",[Full This Year], "Previous Financial Year",[Full Previous Year],[Full Transactions])

This gives a Ref List to the Category Report table which is a Slice. In the app it works perfect like this:

But when I try to display that in an email template using this:

Categories

Categories Balance: <<[Sum Full Report]>>

Category	Total	Budget
<<Start: [Custom Categories]>><<[Category]>>	<<[Full Report Sum]>>	<<[Program Budget Total]>><<End>>

I get something like this which has the correct number of table rows but they are empty:

Thank you,

Hyman

[Steve]

Where does [Custom Categories] come from? What does it contain?

[Hyman_van_Zyl]

Hi Steve,

Sorry, should have been clearer, [Custom Categories] contains the insert called Full Category Report of the cellphone view I added above. That list of transactions is what is generated by this formula in the app under the virtual column called Custom Categories: SELECT(Category Report[EntryID],NOT([Full Report Sum]=0))

In that app view it shows a different heading as I changed the display name.

Thank you

[Hyman_van_Zyl]

@Steve please don't give up on me 😀

Thank you

[Steve]

So [Custom Categories] is a list of Ref. What table do those Ref values refer to? Please post a screenshot of the columns of that table.

[Hyman_van_Zyl]

Hi Steve, 

Not sure how to get all the columns in one screenshot. But here goes the top ones. The [Custom Catergories] REF is referencing its own table, this one, but a Slice thereof.

If you send me your email I can share the Google Sheet and App with you.

Thanks so much

Hyman

[Steve · Accepted solution]

Looks to me like your key column is misconfigured:

Change this:

To this:

FILTER("Category Report", NOT([Full Report Sum]=0))

[Hyman_van_Zyl]

Hi Steve,

You are a star. Amazing how you figure these things out. Thank you, problem solved.

[GV]

Hi @Hyman_van_Zyl  I have tried to send you a direct message but it does not seem to work.

I am trying to do the same as you (with a less complex underlying page).

But I got stuck as AppSheet does not recognize my parameters.

Link -> Template

Screenshot G Sheet - the idea is to send on a weekly basis all the tab with a filter depending status.

Do you think you could help ?

Thanks

[Hyman_van_Zyl]

Hi,

So what is the problem? Do you also get a table with blank rows in the resulting document? 

[GV]

Hi Hyman,

Thanks for your answer, I don't even have the blank rows because my function Start does not work. I wrote you down more explanations on my issue.

G Sheet

Business need : I want to send on a weekly basis a report that takes all the data from a certain tab ("Suivi de Chantier") with a filter on the column Status (only 2 status). The idea is to send this report to all the stakeholders (customers, craftmen, and architect) to make sure the To Do list is cristal clear. 

 So far, I have created an automation triggered on a weekly basis, 

with this templates using the Start Expression but App Sheet does not recognize my parameter. I am quite new in the App Sheet community and this is definitely the hardest thing I had to do.

Thanks for your help

[Hyman_van_Zyl]

Hi GV,

You have intercepted my problem now preventing me to receive any help. Please log your problem separately under its own question. There are people much more experienced than me to assist you.

In the meantime, if you are sure the automation is triggered, I think scheduled triggers are dependent on your level of subscription, then you can check for an error descriptions by going to Manage>Monitor>Audit History

[GV]

Hi Hyman,

Sorry I did not know, thanks for your reply 😉

[Suvrutt_Gurjar]

@GV ,

Please start a new thread as suggested by @Hyman_van_Zyl 

Please try with a START expression of 

<<START: SELECT(Suivi de Chantier[Key Column of the table Suivi de Chantier], [Status]="Status You want the report for")>>