cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mdoak
Nintex Newbie

New Responsive Form Designer - Variables and Rules Issues

Jump to solution

I decided to try and use the new responsive form designer to create a form in SharePoint Online.  I really like the new designer, but have come across the following issues and am wondering if I am doing something wrong or are these bugs.

 

1. I added a list lookup control name SystemLL to the form that returns 2 values from another list in the same site.  Let's just say for this example the values are "System1" and "System2".  I created a string variable and used the parselookup(SystemLL) to extract the string value from the lookup. I then created an On Form Input Rule that populates the variable value into a text box that is bound to a SharePoint Column when the SystemLL Control is filled.  I test the form and everything works.  However when I save the form the value is not being saved, System.Object[] is being saved instead.  If I click into the text field after the rule fires and then save, the value will be saved correctly to sharepoint.

 

2.  Along the same lines, I have another list lookup that returns either "Green", "Red", "Black".   I was trying to create a variable to map the color to a value ranking using the ifElse.  I used the following syntax ifElse(parselookup(Ranking) == "Green", 4, 2).  No matter which color I choose, the value is always 2.  If I create a variable with just the parselookup function, it returns the correct color.  I was able to work around this issue by removing the parselookup function and using a contains instead of equal on the loookup field itself.

 

Any suggestions would be appreciated.  

 

@EuanGamble  @blalocb @eharris04 

Labels: (1)
Tags (1)
0 Kudos
Reply
12 Replies
v-tmasenko
Nintex Newbie

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution
For your second question, I suggest watching Euan's video titled, "How to build a risk management matrix in Nintex New Responsive Forms for Office365". Here's the link: https://youtu.be/NRwj-prW_Ms
Reply
Nintex Employee
Nintex Employee

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

Hi @mdoak,

 

Thanks for trying out the New Responsive designer. Would you mind attaching your form to this post so I can have a look?

 

Cheers,

Euan

Reply
mdoak
Nintex Newbie

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

Thanks for the response @EuanGamble .  I am attaching a simplied form that shows both issues.  I'd expect the Ranking to be 4 when "Green" is selected.  I've watched the video posted above and I think I'm doing everything correctly.  Thanks again for taking a look.

Responsive Form1.JPG

 

Responsive Form2.JPG

 

0 Kudos
Reply
Nintex Employee
Nintex Employee

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

Hi @mdoak,

 

So I have had a look and think I know what is happening. The parseLookup is displaying the correct text you would expect, but in memory it is still stored as the multi-property value that a List Lookup understands. 

 

So for your first  "Green" option, try:

ifElse(contains([Form].[RankingLL],"Green"),4,2)

The problem, however, is that the parseLookup is now passing what it knows in memory (List Lookup data) to the Single Line of Text and the column does not understand that data type. Hence it says "System.Object[]".

 

This is a bug and needs to be addressed. I have raised it with the development team, but it would be really helpful if you could also log a call with support? Please just email them the details and include this community post to support@nintex.com. That way it will be tracked and managed.

 

Thanks,

Euan

Reply
mdoak
Nintex Newbie

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

Thanks @EuanGamble.  I actually had a support case open about it, so I have linked this discussion to it.  The case number is 00289683.

0 Kudos
Reply
Nintex Employee
Nintex Employee

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

Thanks for that @mdoak.


I have recorded a video for support and dev team replicating the issue. Support will be able to update you with the progress from here.

 

Cheers,

Euan

0 Kudos
Reply
v-tmasenko
Nintex Newbie

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution
Until the parseLookup issue is resolved you can implement your own.

This example handles ID's with 1, 2 or 3 digits:

ifElse(contains(substring([Form].[RankingLL],2,1),"#")
,substring([Form].[RankingLL],3,255),
ifElse(contains(substring([Form].[RankingLL],3,1),"#")
,substring([Form].[RankingLL],4,255)
,substring([Form].[RankingLL],5,255)
)
)

To support ID's with more digits just add more nested ifElse clauses with a higher valued offset.
Reply
Nintex Employee
Nintex Employee

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

If anyone is experiencing the parseLookup function issue, please raise it with support@nintex.com as it helps us prioritize the defect based on the number of affected customers.

 

Thanks,

Euan

0 Kudos
Reply
JulieJ
Nintex Newbie

Re: New Responsive Form Designer - Variables and Rules Issues

Jump to solution

glad to have seen this - i've been wrestling with the same issue for days now. I will raise the issue immediately. Disappointing though as my form and process deadline is looming!

0 Kudos
Reply