I have no spreadsheet experience and I want to build on an appsheet. I have watched a tutorial on appsheet, but I still don’t know how to separate each entry point of information. Any help?
It’s probably better that you DON’T have spreadsheet experience!!
You do need to understand how to separate the data into “objects”. Then you create a sheet for each “object” adding columns for each piece of information you want to capture.
As an example, let’s say you want to build an app for Order Entry - the ability to place an order of one or more items for a Customer. The objects you immediately identify would be would be “Orders”, “Customers”, “Items”.
You likely discover more as you go. For instance, right away you might think "how do I record each item with a Quantity, Price and Subtotal Amount> Well, that actually is another “object” as “Order Details”
So, from above you would create 4 sheets - one for each “object” - and list the columns of info you want to capture for each.
Now, with your sheet, you can create an app and use your sheet as the datasource. I think by default, the app creation function brings in the first sheet only as a table in the app and automatically creates a view for this table. You would need to add the other 3 through the “Add Table” function. Then create the views for each of these - I would start by adding Table views for each. When you do this, several OTHER views are added automatically.
You can now use the app. Access the view you want - may be Customers from our example. There will be an Add button in the bottom right-hand corner. Tapping it will open a Form view that was automatically created. Insert some row data info and tap Save. You will then see a new row appear in the Customer table view. Tap that new row. It will be opened into a Detail view that was ALSO created automatically.
These are just the basic actions to get you started. As you play around, you will get ideas of changes to make, data to add, etc.
I hope this helps!
2 Likes