Skip to main content
Nintex Community Menu Bar

Nintex Formula Rule Set Value Based on Another Field Drop Down Selection

  • July 30, 2019
  • 1 reply
  • 38 views
Forum|alt.badge.img

Hello,

 

I have what I think is a simple requirement to set the value of a field in a Nintex Custom form on-prem based on user selection of another field (drop down)

"Role" field with choices:

Coder 1

Approver 1

Approver 2

...

"Amount" field (Single Line of Text)

 

I need the Amount field to populate based on user selection from Role field and attempted formatting rule on Amount field several ways - none have worked:

3711i3E69853FFE11E868.png
Once I get a simple rule to work, I can expand to cover the rest - something I think will look like:
if(Role=="Coder 1", "0.02", if(Role=="Approver 1", "2,000.00", if(Role=="Approver 2", "25,000.00", if(Role=="Approver 3" ,"50,000.00", if(Role=="Approver 4", "100,000.00", if(Role=="Approver 5", "150,000.00", if(Role=="Approver 6", "250,000.00", if(Role=="Approver 7", "2,500,000.00",""))))))))
 
Thus far I cannot get any value to populate in the Amount field with a rule.  Would really appreciate some help!
 
Don

    1 reply

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

    on-prem forms doesn't support Set-value rules.

    Set-value rules are only available in responsice forms.

    in on-prem forms this is only achieveable by a javascript code.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement