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,
Regards
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
Thanks Marian
AccountName is TEXT type (like: company name) ,
could you answer my other question as well?
could you post how does data in ListA looks like?
and an example of AccountName value you try to filter by?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.