Do Format rules apply to email templates?

Tiger1
Participant V

Does a format rule affect email templates?

0 12 349
12 REPLIES 12

Steve
Participant V

I donโ€™t think so. It would be easy enough for you to test, Iโ€™d think.

Ok. Well now i need help with the expression - I cant figure it out.

So what i am trying to accomplish is to change the color on a value if that value is bigger or smaller from the previous day.

3X_4_8_48d0dc2002251c80e443b89fc83d3bb246a992d1.png

So, in this example - since the next day - the value is lower, I want to change the color to green. If it is higher, change it to red.

The value โ€œ49โ€ is just the branch/location number. That will never changeโ€ฆ The values in the last (4th) column are the values i will be looking at to change the color by day.

So, taking my example, I want the value โ€œ46.14โ€ to be colored green.

What kinda format rule you want to apply to the template? Can you give an example? May be a screenshot?

In generally you can do it like thisโ€ฆ

Do i put that on the template - or in Format rules - or both?

I have this expression in format rules - but it doesnt work how I want it to.

I need the expression to look at three values/columns:

Date
Branch
DSO

If it is today - (TODAY())
If the Branch is the same as yesterday branch
If the DSO is bigger or smaller from yesterday

Then change a colorโ€ฆ
IFS(
AND(
([_THISROW].[date] > (TODAY() - 1)),
([Branch] = [_THISROW].[Branch]),
([DSO] < [_THISROW].[DSO])
),
TRUE
)

Template only.

From my personal experience, format rules in the app definition are not applied to workflow templates. You would need the format rule in the application for it to show correctly in the application and you would also need to incorporate @Aleksi solution in the email template to get it to incorporate correctly in your workflow.

So you would need both in your case.

Donโ€™t need the IFS():

AND(
([_THISROW].[date] > (TODAY() - 1)),
([Branch] = [_THISROW].[Branch]),
([DSO] < [_THISROW].[DSO])
)

is equivalent.

I must be missing something. It still doesnt change colors. See the picture (attached). Beaumont DSO goes down - so the last entry should be green?

I am still not seeing any Format rule working using the above expressionโ€ฆ

I am not seeing why it does not work.

Format rules donโ€™t affect documents generated from templates.

Ok. But i was doing this to have in a template and in the app. It doesnt seem to work.

Top Labels in this Space