basenine 6/25/2020 12:04:21 AM
You'll most likely need to create a formula barcode field (set to QR works best) with the formula looking something like:
URLRoot() & "/view.aspx?fid_XXXXXX=" & [CUSTOMER ID] & "&id= VIEW ID"
Where fid_XXXXXX is the column id of [CUSTOMER ID]
VIEW ID needs to be hardcoded and it can be found on the view you've created to show the data you described above (the view id should be 7 characters long i.e. 4536789)
This new barcode will need to go on the product (AS WELL AS any existing barcode you may already use).
It may be possible to streamline these barcodes into one for you, but without knowing anymore about your operation, it's hard to commit to that line of thought 😀