To actually implement your data into your app-to-be, select Data > Tables in the app editor, select New Table, and find and select the data table you’d like to use: Following the example, the below shows how the Customer sheet has columns that correspond with the different properties of the entity:įor more information about how to build your spreadsheet, see Data: The Essentials. In this single worksheet, the different properties of the entity should be the column headers.

To plug your data into AppSheet, you should use one of these platforms.Įvery entity that you define ( Job, Employee, Building) should have its own worksheet within the spreadsheet you are connecting to AppSheet. The Job entity references the Customer entity, the Building entity, and the Employee entity.ĪppSheet supports Google Sheets, Microsoft Excel, and Smartsheet. In this case, each Job is for one Customer, in one Building, assigned to one Employee. These different property values help uniquely identify an instance of the entity for example, an Employee may have an ID number property.įinally, entities can be related to each other. All instances of an entity will have the same types of properties, but with different values. An entity is a set of things in the real world - in the above example, the four entities involved would be employee, job, location, and customer.Įvery entity has a set of standard properties for example, every customer would have a name, address, phone number, and email address. We think about data in terms of entities and their properties.Įvery piece of data should be categorized into an entity. There are 6 steps that every app creator should follow:ĪppSheet apps are all about the data. How would I build this in AppSheet?” Summary of steps I hope to then be able to track the total the amount of coating applied each day by each employee, in addition to the amount that is applied across all job sites. I’ve populated this table with existing data, and my goal is to create an app that allows the supervisor to check a box once they’ve verified that the task is complete. For example, Column A refers to Tower A, Column B refers to Apartment 301, and Column C refers to Tower B. My data columns specify different areas that need to be coated. I built a spreadsheet (Google Sheets is my data source) where I have entered all data related to a specific task, in this case, water coating. I’m building a set of apps to be able to track what is going on at our job sites.

Most complex no code app builder