I am attempting to use the Appsheet inventory management template to keep a live stock count.
The issue with this is that whenever I add a column to the google sheet so that I can add the added stock to initial stock, there is an error that pops up saying that the column schema is incorrect. I tried regenerating the schema, but this only messed up the app functions.
If anybody has a solution please let me know. Thanks
Will need a little more info. Those are the correct steps to go about adding columns to a sheet, but how did the app functions get messed up. Where do you see the possible issues coming from? also pictures and videos are very helpful.
In your regeneration did the name of a column change? That would cause formulas to break.
Another thing: there is a really far off in the weeds bug that you might be running into… If you have formulas that control security filters, and the table that you regenerating is that same table, it can cause weird little confusion things.
After you do the regeneration, try making a small change to something and saving the editor, sometimes that will clear the error; if not, maybe refresh the browser.
I have found that sometimes when I am regenerating my user table, the system will come back with all kinds of errors and everything for formulas about my user table. But if I save the editor again the error goes away.
Yes, the name of a column did change, although I do not think that it has anything to to with the formulas as the error only occurs when I try to add more than the 4 pre existing columns.
Hi, thank you for the response. I will try to explain the issue more specifically.
This is what the spreadsheet looks like without the added column:
After adding a column with formula SUM(c:d):
This is the error that pops up in appsheets:
Once I regenerate the column schema. the app does not function properly. As you can see I added 1x 12388, but it added 1x 23275-2. When I add any other part number it will simply keep adding to the next row over and over instead of adding to the row of the part number.
