cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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

Labels: (2)
0 Kudos
Reply
3 Replies
Workflow Hero

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

Accept as Solution Reply
Workflow Hero

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

Thanks Marian

AccountName is TEXT type (like: company name) ,

0 Kudos
Accept as Solution Reply
Workflow Hero

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
Accept as Solution Reply