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

Repeating section using lookup and calculated fields

Jump to solution

Hi All,

I have created a repeating section which contains a lookup field that looks up a supporting list. The repeating section also contains a few calculated fields that use the Lookup() runtime function in order to pull back the appropriate data.

When I have just one row, the information pulled back is fine. This indicates I have the formulas correct.

When I add a second row, the the calculated columns in all rows go blank.

Anyone seen this before? I have replicated a similar form (example above) in our DEV environment and it does the same thing, so am thinking it is something bigger than poor form development. What am I missing? We require this information to be displayed in the form itself, as we are driving users to work from the completed forms as opposed to outputting the information in an email or a list view.

Using SP2013 and Nintex Forms 2013 2.7.0.0

I have looked at the bug fixes for a few of the more recent versions but nothing is apparent. Suspect it may be this though?

We are also currently standing up an O365 environment, so upgrading the forms software isn't a preferred solution.

0 Kudos
Reply
11 Replies
abdullahfahmi91
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

Hi ‌,

What do you mean standing up an O365 environment?
For your information, this kind of configuration works properly in Nintex Forms O365.

0 Kudos
Reply
abdullahfahmi91
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

I have tested that Nintex Forms 2013 2.10.2.0 also working properly with this configuration.

0 Kudos
Reply
Automation Master
Automation Master

Re: Repeating section using lookup and calculated fields

Jump to solution

make sure your cost and description controls are relay contained in repeating section, not just overlapping it.

Reply
cyclonereverb
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

Thanks for confirming this Abdullah

0 Kudos
Reply
cyclonereverb
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

I have worked out the problem - I had configured the lookup as follows:

lookup("list title", "column to filter on", value to filter on, "output column")

when I should have configured it like this:
lookup("list title", "column to filter on", parseLookup(value to filter on), "output column")
All working as expected now.
Reply
cyclonereverb
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

Thanks, I have fallen in to this trap once or twice in the past, and it is difficult to see. Always the first thing I check now!

Reply
coperkins
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

I have the same problem but I don't know which formulas to use. I have a repeating section that calculates cost and quantity, but when I click to repeat the field the total cost displays a formula value error (#Value!). Please advise? 

Also, how do paste screenshots in my comments?

0 Kudos
Reply
cyclonereverb
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

With my example of the repeating section, I found that using a parseLookup within the formula worked better than the straight Lookup. I also found that when doing calculations that passing the value in to a variable first, then running the calculation on the variables had better success. Not sure if this is the general consensus, or just me. I also found that the Lookup formula was one of the more difficult formulas to get working - check syntax as it has to match exactly.

With regards to the inserting of images, I always take a screenshot first and edit, crop etc, then save to desktop. Then I insert using the Insert Image button.

Hope this helps!

0 Kudos
Reply
keibur
Nintex Newbie

Re: Repeating section using lookup and calculated fields

Jump to solution

I believe this is the solution to my problem, but am very junior with Nintex and can't seem to implement it correctly. In mine, I have a pull down selection (state) and once selected want to pull three fields of data from that list form: Zip code, Assigned Manager, and Notes. I went into List Settings and setup lookups for the State list, State:Zip code, State:Assigned Manager, and State:Notes. 

With your example above I am equating List Title to my States list, Column to Filter On to my State name field, Value to Filter On to my State:Zip code, but I do not know what to do with Output Column.

Any additional guidance for this novice would be appreciated.

0 Kudos
Reply