0
Hi,

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
Responses (7)
  • Accepted Answer

    Wednesday, May 24 2017, 05:50 PM - #Permalink
    0
    There 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)
    Like
    The reply is currently minimized Show
  • Accepted Answer

    Monday, May 29 2017, 02:58 AM - #Permalink
    0
    Yes, good idea. I created a new field that contains Fiedl1 - Field2. In my rule notification , if this field < 0, send the notification.

    Thank you.
    Like
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, May 31 2017, 02:18 AM - #Permalink
    0
    Hi,

    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")
    objField1.GetValue Field1

    Set objField2= objFields.FindField("Field 2")
    objField2.GetValue Field2

    Compare = Field1 - Field2
    'Shell.redoMessage = "Compare." & Field1 & Field2 & Compare
    Set objCompare= objFields.FindField("Compare value")
    objCompare.SetValue Compare
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, June 06 2017, 04:27 AM - #Permalink
    0
    A help please ?
    i am blocked.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, June 08 2017, 02:57 AM - #Permalink
    0
    Somebody could help me??
    I have two system, development and production. In development, the script " objCompare.SetValue Compare" works.
    But in production, the script "objCompare.SetValue Compare" don't works, because the field is always EMPTY

    I do a video to show you.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, June 08 2017, 05:30 PM - #Permalink
    0
    My 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.
    Like
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, June 13 2017, 02:55 AM - #Permalink
    0
    Hi,

    Now it's worked but i don't know why!! lol

    I think it's worked for the new ID, the new object. But in development, it's for all object. So i don't understand.

    But the main, it's worked now!! Thank you very much!!!
    The reply is currently minimized Show
Your Reply