Hi, I have a problem with the multiple selection column I created. So I have a column called Currency with many currencies, I have given the option to select more than one option for the users. What I want is for each option they choose another column to appear to record the information of each currency. for example, let's say the user selects USD and GBP under currency then I want two text columns to appear, If more currencies are selected more columns to appear Can any kind soul help me ( I'm using SharePoint integrated with Nintex 2013)
+13Are you trying to do this on a form? If so, which form designer are you using -- Responsive or Classic?
You can create rules on the form to hide the amounts fields for each Currency if that Currency is not selected as a choice. I'm assuming the Currency control is a Choice control with the options listed and you have an Amount (Single Line Textbox of type Currency) field for each type of Currency choice. Follow these steps in the Responsive designer to hide an Amount field if that corresponding Currency choice is not selected:
- Add a new rule to the specific amount textbox control (USD for example).
- Configure the rule with these options:
- Rule Name = Hide USD Amount
- When = not(contains(Currency, "USD"))
- Use formula builder to configure the When.
- Configure with the "not" and "contains" Inline Functions.
- Then = Hide
- Make a copy of this rule for each of the other Currency choices, change the Rule Name and When configuration to the appropriate Currency choice, and make sure to apply it to the correct Amount textbox control.
- This will hide the Amount control when the selected Currency choice is not checked.
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.