Alternate selection of the filled value for autocomplete (product search)

[arthurmorenko]

For the purposes of organizing the issuance of goods from the warehouse, it is necessary to organize the selection of goods by two attributes, a barcode and a unique ID.

The choice should be made according to one of the two available attributes, separately, since the product does not always have a barcode.

Additionally, when choosing one of the values, it is necessary to automatically fill in the information on the product and write the information to the register.

[TeeSee1]

You can try the following assuming you always have a Unique ID for every item.

Set the initial value of the Unique ID column to

IF(
 ISNOTBLANK([barcode col]),
 LOOKUP(
  [barcode col],
  "Items table",
  "barcode col",
  "product ID"
 ),
 ""
)

The rest of the columns that you need to pull information from the Items table should use dereferencing on the [unique ID] .

[arthurmorenko]

Thank you very much, you push me to the right way!