Form Formatting Rule Assistance

  • 23 April 2020
  • 4 replies
  • 0 views

Badge +3

Hi everyone,

I'm in a timeframe bind before some forced leave balance reduction time off.

 

I am trying to modify the rule shown below so that the output is also "Safety Assessment Report" if OOSM equals "Major"

 

If(5.1=="Yes","Safety Case",If(7SARYN=="Yes","Safety Assessment Report",If(OOSM=="Minor","Safety Statement","Not yet calculated")))

 

Can anyone assist please?

Thanks


4 replies

Userlevel 6
Badge +22
Hi,

Cant you just embed one more If statement like :
If(5.1=="Yes","Safety Case",If(7SARYN=="Yes","Safety Assessment Report",If(OOSM=="Minor","Safety Statement",If(OOSM=="Major","Safety Assessment Report","Not yet calculated"))))
Badge +3

Hi @SimonMuntz,

I tried that but the form fails to load, just a blank screen.

Badge +3

Any other suggestions out there?

I have no idea why when I implemented this option the form does not load all.  

Is there a way of debugging it?

Badge +3

Where is the face palm emoji....

I had another look at this this morning and realized I had added/was adding the additional If statement with a lowecase i.

All working now.

Thanks @SimonMuntz 

Reply