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

(Webmaster Zavko) #1

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?

(Aleksi Alkio) #2

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

(Webmaster Zavko) #3

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].