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 188.8.131.52
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.
Solved! Go 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")
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?
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!
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.