Hi ,
What do you mean standing up an O365 environment?
For your information, this kind of configuration works properly in Nintex Forms O365.
I have tested that Nintex Forms 2013 2.10.2.0 also working properly with this configuration.
make sure your cost and description controls are relay contained in repeating section, not just overlapping it.
Thanks for confirming this Abdullah
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.
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!
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.
Hi Keith, apologies for the delay in replying.
From memory, I didn't bother with all the other setting of lookups, as my users only referred to the form content iteself. This might be the red herring. The information I pulled back was displayed in a calculated field too. This field had no requirement to write back to the list itself which made things immesasureably easier to manage.
To answer your question, the output column should be the data you want displayed on the form.
Anything in " " is referencing the list you are looking up (list title, column to filter on, output). Note this is all manually typed too, apart from the value to filter on field which is retrieved by the picker.
Hope this gets you across the line!
Thank You, I'll see if this gets me over the hurdle.