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.
0 kommentar(er)
