Hi, I am using the calendar app to create a ...

expressions
(Eli) #1

Hi,

I am using the calendar app to create a weekly employee schedule. I would like to be able to print up this schedule as well, however, I am struggling with the format of the template. Here are my template expressions

<<Start: Select(Employee Schedule[_RowNumber], TRUE)>> Production Detail Id: <<[Production Detail Id]>> Employee: <<[Employee]>> Production Zone: <<[Production Zone]>> Production Task: <<[Production Task]>> Start Date: <<[Start Date]>> Employee + Task: <<[Employee + Task]>>

<>

Ideally I would like the output of my report to look like this

Mon

Tues Wed Thurs Fri Sat Sun Dan

Job 1

Job 1 Job 2

Stan

Job 2

Jan

Job 3

Job 3

Job 1

Is this even possible? I am having a hard time trying to figure out how to make the data flow horizontally. In reality the only columns I need would be <<[Start Date]>> and <<[Employee + Task]>>

How would I associate a day of the week with the specific <<[Start Date]>> and

<<[Employee + Task]>>

(Reza Raoofi) #2

You could have a table in your template Doc with 8 fixed columns, for Employee and the 7 weekdays, then using <If:> expression check WEEKDAY([Start Date]) and if it matches the week number of the corresponding column it would display [Task] in that column.

Check out this article on <If:> expressions:

https://help.appsheet.com/behavior/workflow-sending-email/template-if-expressions

Also check this as a sample email template with table: https://docs.google.com/document/d/1_eVU9RMkuNtG-SrZVd9SI5I5QNlOzj2PFWzUhXSHz68/edit