Hi All,
Cannot get to the bottom of this one.
I have an issue on an email automation.
In the report the PREVIOUS WEIGHT does not come up on some reports, but comes up on others. Then the same date expression working for 1 instance and not for another also on the date expression
Can this be some sort of sync issue…but all the data is showing and correct in the app form, even updates do not change what is there, such unexpected behaviour
The following is not tested but you may want to try
For the [Starting Weight] date, you could have an expression something like
<<IFS([Starting Weight (Kg)] >0, TEXT([Lookup Starting Date], “DD/MM/YYYY”))>>
Similarly for other expressions.
Thank you @Suvrutt_Gurjar that works!! But why do you think
“<>0”
or
“NOT([Starting Weight (Kg)]=0)”
Does not work…
The second part of my question is the [PREVIOUS WEIGHT], I am looking at the data GOOGLE sheet during an update it is not recording a value,
Hi All,
The comedy of errors was on me.
It was all related to how my formulas were structured, at times I thought I was going mad, and that the sync was the issue, but I realised it was just my expressions and settings werent set right.
@Suvrutt_Gurjar I also realised <>0 does work in email template, thank you for helping me.
Below is a bit of explanation of what I checked and found out.
Below screenshots of the final template expressions I settled on, and the expected result.
Great. Congrats. Thank you for the update.
