Skip to main content
Nintex Community Menu Bar

Set Status field based on 3 calculated values the status is 1, -1, 0 using JS any help

  • July 16, 2019
  • 4 replies
  • 13 views

Forum|alt.badge.img+4

Set Status field based on 3 calculated values the status is 1, -1, 0 using JS any help

I have a request to set a status based on 3 calculated values

greaterthan = 1

lessthan = -1

equal = 0

I need to use JS but, I'm still new in javascribts I tried with several methods to set the output but failed only JS way

 

4 replies

Forum|alt.badge.img+14
  • Scholar
  • July 17, 2019

I'm not sure I fully understood your requirement, but I think you do not need a javascript.

you can add one another calculated value control on the form and set up its formula so that it takes those 3 already existing calculations and based on their values returns respective "status" result. then just connect this control to a status list field.


Forum|alt.badge.img+4
  • Author
  • Nintex Partner
  • July 18, 2019

I'm sorry if it was not clear I was writing very fast right now I had implemented using only nintex inline functions and form variabls and lastely

I have sated like

If(PIC_avrg_call == WW_avrg_call, 0, If(PIC_avrg_call < WW_avrg_call, -1, 1))


Forum|alt.badge.img+14
  • Scholar
  • July 18, 2019

yes, that's something like what I was thinking of.

so is that your solution or you still have any problems with that?


Forum|alt.badge.img+4
  • Author
  • Nintex Partner
  • September 23, 2019

thank you for replaying yeah this was my solution