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
could you answer my other question as well?
could you post how does data in ListA looks like?
and an example of value you try to filter by?