I have two field numerical in my report.
When the user change the state and change the numerical with field1>field2 so i want send email.
But in rule i can choose a other field in "value " field, only numerical value.
You can see the picture
Accepted AnswerDavid SheaffeOffline0There isn't anyway in the notification rules that you can compare one field against another - you could add it as an idea and it might be something that the development team could consider as a future enhancement.
As a possible workaround, could you do something like add a binary field that gets ticked anytime either of the numeric fields change and field1>field 2. Then set the notification to run if the binary field is checked when the state changes to Analysis Completed. (Alternatively, you could have a calculated field that is field1-field2 - then base the notification on the value of that calculated field)
I develop a Appscript to modify the new field. But i have a other problem.
This AppScript works in my development system but not in my production system. It's so weird.
In development system, The new field is modify by my AppScript after clicking the button "next".
But in my production system, the field is not modify.
In add a message to check the modification "Shell.redoMessage = "Compare." & Field1 & Field2 & Compare" and it display the good information!!! "Compare 1 2 -1", But in the field screen, it's empty. So my notification is not activated!!!
Please help me because i don't understand.
My Appscript :
Set objField1= objFields.FindField("Field 1")
Set objField2= objFields.FindField("Field 2")
Compare = Field1 - Field2
'Shell.redoMessage = "Compare." & Field1 & Field2 & Compare
Set objCompare= objFields.FindField("Compare value")
Accepted AnswerDavid SheaffeOffline0My only suggestions would be to check to see if there are any over-rides that are set in Production that aren't in test - I have occasionally had that as a problem - particularly when over-rides can be set at so many different levels.
The other suggestion would be to use Developer tools in your browser to see if there is an error that is happening, they are normally quite helpful in investigating issues like this.
Sorry that I don't have a specific solution for you.