This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a master spreadsheet where all the products and related barcodes are stored. This is my distributorโs app. Next, I have customer apps where each customer has its own data, but the products, barcodes, and prices are the same as the distribution app. If I use importrange to sync the data, I can not set the barcode column as key and if the barcode column is not set as key then the scanner function doesnโt work. I have to have separate data sheet for customers because there are additional columns there such as their own selling price which each customer would have a different price.
What would be a work around for this. As I have to copy and paste to each customerโs data every time we add new product or change prices or images on the distributorโs spreadsheet
Data > Columns > Products > Edit Barcode > Spreadsheet Formula. Here you delete everything and leave it blank. Save and all is working, even the importrange formula in the spreadsheet
I get the following error:
The key column โBarcodeโ of table โProductsโ is not a legal key because it contains a Formula. We chose a new key for โProductsโ.MORE INFO
Table Products must have a key column. We assigned โ_RowNumberโ as the default key, but you should choose a better one.MORE INFO
Error:
Column Name โBarcodeโ in Schema โProducts_Schemaโ cannot be scanned (not Barcode scannable) because it contains a formula or AppFormula.
The formula is importrange(โurl_of_spreadsheetโ,โProducts!A2:Gโ)
This imports all Product data from main Product spreadsheet to Customer Product spreadsheet. In the customer Product spreadsheet (table) there is an additional column (Unit Price) which the customers can add his/her own selling price. For different customers to be able to set their own prices I have set it up this way.
The Data documentation helped to understand better, but not enough to restructure the data. I need each customer to be able to set their own price but have all other Products details the same as set by me.
Data > Columns > Products > Edit Barcode > Spreadsheet Formula. Here you delete everything and leave it blank. Save and all is working, even the importrange formula in the spreadsheet