What would be best appsheets template to approach this?

AppSheet AppSheet Q&A
1

I am trying to create a basic table creation and management app that is able to:

  • Create a list of items
  • Automatically create and assign a templated spreadsheet table to each item.
  • I would be able to edits some rows and sync the said tables from within the app.

This a simple mockup I made in figma outlining my concept.

Frame 1.png
Frame 1.png932Ă—1030 84 KB

What app template would be the most appropriate to approach this concept?

2

Hi @Aniket_Chanda

The first sample app that comes will be nice: “simple inventory app”

2 Likes
3

Thanks for the response, I have looked into the template.

Is it even possible to generate new sheets/tables with AppSheet? So far I have found that tables need to be premade and the only bit of editing you can do is add rows to existing tables.

4

You can’t create table. Why would you need that ?

2 Likes
5

Oh well. I’m basically trying to generate individual costing sheets for different items that can be synced and manually edited outside of the app. The costing sheets for the items will have a few formula cells that will calculate the totals/profits, but in layman’s terms the sheets need to be individual for each item inside a single g sheets file.

6

OK, thanks for futher context.

You may benefit from using sheets protection and filtered views within the Sheets, for your users.

https://support.google.com/a/users/answer/9308952?hl=en

1 Like