Issue with filtering data for email summary report

[alohaluxurycars]

I'm trying to set my Bot up to send a daily and/or weekly summary report of all the vehicles in my fleet with an upcoming service. I've been on the forum trying to work through it and have solved a few issues but I can't seem to get all the way there. I am able to filter data and generate an email on a "ForEachRowInTable" basis but can't get the summary to work. 

The error is with the Columns in the email template. The Start Expression seems to be working

I'm pulling from a Service Schedule table.

Thank for the help!

[Marc_Dillon]

Looks like you're missing an <<END>>

https://help.appsheet.com/en/articles/961746-template-start-expressions

[alohaluxurycars]

Sorry, <<end>> is out of the screen shot.

[Marc_Dillon]

Ok, so what else are you leaving out?

[alohaluxurycars]

Here's the whole template.

[Marc_Dillon]

Just as I thought...

[alohaluxurycars]

Ah, so no text can be in between the <<start>> and <<end>> expressions. Thanks! I'm still not getting any data filtered though. I get the attached email which does not include the rows that should be filtered from the database (attached).

[alohaluxurycars]

Figured it out. Had to adjust the Start Expression formula from:

FILTER(Service Schedule,AND([Service Date]<Today()+30,[Service Is Scheduled]=no,[Service Is Completed]=no))

To:

FILTER(Service Schedule,AND([Service Date]<Today()+30,[Service Is Scheduled]<>yes,[Service Is Completed]<>yes))

Not sure why it didn't recognized the "no" in the filter but it's working now. 

[Suvrutt_Gurjar]

You may want to try the START expression with a syntax of 

FILTER(Service Schedule,AND([Service Date]<Today()+30,NOT([Service Is Scheduled]),NOT([Service Is Completed])))

A Yes/No column stores status in Boolean form TRUE/FALSE , so it can be simply checked by [Service Is Scheduled] for TRUE and NOT([Service Is Scheduled]) for FALSE.

[Steve]

Also, it's a good idea to quote the table name: FILTER("Service Schedule", ...)

[alohaluxurycars]

Awesome! Thanks guys!