aakg2a
Novice

issue : Calculated field for Lookup Function is blank result

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

0 Kudos
Reply
3 Replies
emha
Collaborator

Re: issue : Calculated field for Lookup Function is blank result

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

Reply
aakg2a
Novice

Re: issue : Calculated field for Lookup Function is blank result

Thanks Marian

AccountName is TEXT type (like: company name) ,

0 Kudos
Reply
emha
Collaborator

Re: issue : Calculated field for Lookup Function is blank result

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?

0 Kudos
Reply