Hello!
I am trying to make things work on a complex system of forms. Based on the same feature service I have different forms.
2 of them are involved in the following:
Form 1. according to the priority the status is defined:
Status= if(${Priority} ='Low', 'Pending', if(${Priority}='Medium', 'Pending' , if(${Priority} ='High', 'Pending', if(${Priority}='Critical', 'Pending', if(${Priority}='None','Closed/Rejected', 'Queue')))))
Form 2. once the work is done here the question: "Would you like to close the case?" change the Status into 'Ready for vetting'
Once the status changes the person has to reopen Form 1 and answer the question: "Do you accept the solution?" has to reply yes or no and the status would change into
yes = 'Settled'
no = back to 'Pending'
in order to achieve so I added something to the end of my first if statement to get this:
Status = if(${Priority} ='Low', 'Pending', if(${Priority}='Medium', 'Pending' , if(${Priority} ='High', 'Pending', if(${Priority}='Critical', 'Pending', if(${Priority}='None','Closed/Rejected', if(${Accepted}='Yes','Settled', if(${Accepted}='No','Pending', 'Queue')))))))
no errors in the statements but when I reopen the form and set either yes or no to the Action question, the status goes to 'Pending' no matter what.
It is clear to me that there is a conflict and the {Priority} settings are honored and the {Accepted} is ignored.
any idea on how I could make this work?
I think I should insert AND somehow, I am trying but I keep on getting errors.
Thanks!