This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

I can't seem to find the solution to this iss...

Posted on 02-07-2018 04:00 PM
Webmaster_Zavko
New Member
Reply posted on --/--/---- --:-- AM

I can’t seem to find the solution to this issue I am running into. I am looking to perform a LOOKUP with a value that is coming from another column in the same form. My data is set to scan a UPC, and the field I want to populate is the result of a LOOKUP of the scanned UPC. Essentially, I need to figure out how I can use LOOKUP with [_THISROW] to get the form to fill out. I have placed the following formula inside the app formula section of my data. =LOOKUP([_THISROW].[UPC],CA Data,UPC,WPIN). Any ideas why I can’t get the app to populate the field based on a LOOKUP of the previous field?

0 2 307
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Aleksi_Alkio
New Member
Reply posted on --/--/---- --:-- AM

Is the CA Data table the same than the form you are filling?

0 Likes

Posted on --/--/---- --:-- AM
Webmaster_Zavko
New Member
Reply posted on --/--/---- --:-- AM

Thank you for responding. It is. I believe I have found the solution! I what I did was use a dereference to pull the data I needed based on the UPC that I scanned in. I set the UPC to be a ref, and then had the information I am looking for (WPIN) to populate by [UPC].[WPIN].

0 Likes
Top Labels in this Space