I have a list with a form that I have modified with Nintex Forms 2013. In my form I have Calculated field for Lookup Function:
Formula = lookup("List A", "Account Name", AccountName, "Account No.")
If i change "Account Name" TO "ID" , Formula working but I don't want lookup in "ID"
I need to lookup in other column from List like "Account Name",
Please I need your help,
what is AccountName (the object you filter by) - item property or named control?
what is its datatype?
however, if AccountName matches any value of "Account Name", that sounds to me as a kind of misconfiguration (eg a control labeled 'name' represents an ID) or just a coincidence that name value is a number and the number matches some ID