AnsweredAssumed Answered

Repeating section using lookup and calculated fields

Question asked by cyclonereverb on Sep 24, 2017
Latest reply on Jul 2, 2018 by keibur

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.

Outcomes