Hello There
I am trying to add a row to a table "View:Inventory" using appsheet and my table is as follows:
When I try to do so, I receive an error
"Unable to add row to table 'View:Inventory'. โ The service sheets has thrown an exception. HttpStatusCode is BadRequest. Invalid data[0]: Requested writing within range ['View:Inventory'!A2], but tried writing to column [B]: Message[Invalid data[0]: Requested writing within range ['View:Inventory'!A2], but tried writing to column [B]] Location[ - ] Reason[badRequest] Domain[global]
Can someone help please
Solved! Go to Solution.
Hello,
I think I figure it out, the issue is on how I names the table "View:Inventory", I changed to "View_Inventory" and it worked
Hello,
I think I figure it out, the issue is on how I names the table "View:Inventory", I changed to "View_Inventory" and it worked
Thank you. I ran into the same issue and renamed the worksheet, replacing : with a _ (underscore). I originally had a - (hyphen) in the table name. That was giving me issues with a data validation formula. Replacing the - with : seemed to work for the data validation formula but then led to this error. Replacing : with an _ resolved this issue.
User | Count |
---|---|
15 | |
10 | |
7 | |
3 | |
2 |