add and save barcode by smartphone

[Mark_Pathfinder]

hi, i have a products table I would like that, when I insert a new item in my product table, I can insert the barcode via scanning so that I can then search for it via scanning. How is it possible?

[jballester · Accepted solution]

Hi, 

AppSheet is the solution for that.

Support: https://support.google.com/appsheet/answer/10106618
Template: https://www.appsheet.com/templates/Manage-inventory-levels-stock-value-and-vendor-details

Example field type text teady to read barcodes.

Example 2 Tables
- products
- scans

New product
To insert a new product, create a text field and activate the barcode property. AppSheet will read the barcode and record it.

Search product - scan -
To search for a product, create a table that collects the searches, "Scans." In it, insert a text field configured as a barcode. This field should be of the Ref type with the products table.
For the search results, in this same table, create a virtual column that displays the desired value from the products table through a desreference.
When AppSheet scans the code, it will show you the results (virtual column) in case of a match via desreference. If it doesn't find it, it will indicate it, and you can incorporate a new product.