I scan in the column named M_Item (which this column reference to find MSP table)
Part Name column (pull data in MD column from MSP table)
MSP table
ITEM column is lot number
MD column is model name
What I want is I use M_Item column to scan barcode and then Part Name column (eg M_Item lot 12345 MD in MSP column must pull data matching this lot) pull value from MD column in MSP table
But I tried using formula LOOKUP([M_Item], “MSP”, “ITEM”, “MD”) // LOOKUP([_THISROW].[M_Item], “MSP”, “ITEM”, “MD”) but it doesn’t pull data
LOOKUP([_THISROW].[M_Item], “MSP”, “ITEM”, “MD”) is correct.
Make sure the scanned value that ends up in M_Item matches a value in the Item column of the MSP table. Upper- and lowercase don’t matter but spaces do. For instance, if the scanned value has a trailing space but the value in MSP does not, it won’t match.
If you’ve typed anything into the Part Name column before scanning (even if you remove what you typed), the Part Name column will not update after scanning. You’d have to leave the form and re-enter it to reset the behavior.
By default, Initial value is only computed before the row is saved the first time. If you save the row and later re-edit it, Initial value will not be recomputed. This can be changed by enabling Reset on edit?.
