Tascin
Nintex Newbie

ifelse condition + variables in Nintex Forms for SharePoint Online

Jump to solution

Hello everyone,

I am currently working in forms on a repeating section that calculates some variables based on user input. I am using the responsive web designer and SharePoint Online.

Basically what I want to achieve is the following: ifelse(toggle=="true", take variable 1, variable 2)

The problem is though variable 1 works, variable 2 is not taken for some reason.

 

Since it is a repeating section, I have been transforming all toggle arrays into strings. Variabe 1 and 2 are decimals. Further, I would like to know how to safe the sum of all repeating sections in a sharepoint column. Since it will be a variable, I am not sure how to achieve that.

 

Thank you for any insight on this!

0 Kudos
Reply
2 Replies
Bobbie-Lee
Nintex Newbie

Re: ifelse condition + variables in Nintex Forms for SharePoint Online

Jump to solution

Unfortunately, I don't have much help for you other than you will not be able to store a variable into a SharePoint Column in the New Responsive Designer... yet. I am keeping tabs on a forum  that lists all of the current limitations. 

 

My workaround until they update, is displaying the variable directly above the column choice, and then manually adding the variable. Not ideal, but hopefully only temporary.

0 Kudos
Reply
butlerj
Community Manager Community Manager
Community Manager

Re: ifelse condition + variables in Nintex Forms for SharePoint Online

Jump to solution

@Tascin While I'm not 100% sure of your form or use case, I think I was able to come up with a solution for both your problems:

 

Toggle:

This can be done using a Formula control and the 'If' runtime function combined with your variables. I had two variables:

Screen Shot 2020-05-08 at 6.39.59 AM.png

Screen Shot 2020-05-08 at 6.40.05 AM.png

 

I then configured my formula field with the IF function:

Screen Shot 2020-05-08 at 6.39.31 AM.png

 

When previewing the form you can see that the value changes to the be variables quantity based on what the state of the toggle:

Screen Shot 2020-05-08 at 6.40.21 AM.png

Screen Shot 2020-05-08 at 6.40.26 AM.png

Screen Shot 2020-05-08 at 6.40.33 AM.png

 

Then for summing values from a repeating section I also used a formula field that could then just be connected to a SharePoint column:

Screen Shot 2020-05-08 at 6.40.44 AM.png

 

Screen Shot 2020-05-08 at 6.41.15 AM.png

Screen Shot 2020-05-08 at 6.41.24 AM.png

 

 

Hope that helps!

View solution in original post

0 Kudos
Reply