Scanner, same barcode quantity update and other m

[Jorge78]

Hello, 

I work as a seller for a cosmetic brand, every week I am in a different multibrand Cosmetic store and everytime I make a sale I have to write it down on a notebook, because I do not do the check out and cannot have access to the computers to check everything, at the end of the week I have to report those sales.

Basically I  am creating an app to keep track of my sales and export it to a google sheets. I have it almost ready but I can't for the life of me, find the way for the scanner to let me scan the same item more than once. Is there a way to get it to add up or even just add a line?

Is there a way to add a new page t the spread sheet for every new week?

Lastly whenever I scan, on the column where the name of the product is supposed to show I i get the code again.

Any help and guide would be greatly appreciated.

Thank you in advance for your time. 

[WillowMobileSys · Accepted solution]

The [CODIGO] column is the barcode column? 

This column is set as the key value.  Key values must be unique.  With this barcode column set as the Key in the Productos and Ventas tables, you will only be able to ever have a single row with the barcode value in each of these tables.  this might work in the PRODUCTOS table but, as you said you want to record several sales on the same barcode in the VENTAS table.  You currently cannot do that with the barcode as the Key.

To fix this issue in the VENTAS table you need to:

1. add another column, maybe named Sales ID, and set it as the Key column.  You can use the UNIQUEID() function to populate the value.
2. Change the [CODIGO] column (in the VENATAS table) to the type of Ref with the table source as PRODUCTOS.

These two changes should make everything else work as expected.