{"CACHEDAT":"2026-04-14 02:00:38","SLUG":"appsheet-eIWWG091br","MARKDOWN":"# Step 1: Create AppSheet\n\nA good starting point is a Google Sheet. The columns will later be the fields that can be filled in in the App.\n\n \n\nYou then start by clicking on \"+ Create\", go to \"App\" and \"Start with existing data\".\n\n \n\nYou then give the App a Name and choose a Category. \n\n## Link Google Sheet\n\nChoose the corresponding Google Sheets. You can create a Google Sheet in your drive or you might click on \"Shared drives\" and select \"E+ SciLMi\":\n\n \n\n \n\n\n\\\n\n\\\n\nAfter a short processing phase, you should see this:\n\n \n\n# Step 2: Understanding the User Interface\n\n## Data\n\nData is where you can see all the columns that are now data sets. For each column, you can define which field it will be, decide for a key and for labels, predefine content or write descriptions for the field, etc.\n\n \n\n## Views\n\nViews is where you define how the data will be shown to the user. Here, you can decide which data is shown, how it is displayed and how it can be edited.\n\n \n\n\n### Deck\n\n\n### Table\n\n\n### Form\n\n\n# Step 3: Define type for every column\n\nAppSheet automatically defines data types for your columns. However, if you want more than texts, names or numbers, you will have to define them themselves.\n\nTypes that I often used are:\n\n### Text\n\n\n### Name\n\n\n### Number \n\n\n### Enum (for options that can be chosen) \n\n* can be Buttons, Stack or Dropdown\n* options can be predefined\n* users can also be allowed to create new options\\n\n\n### LongText (for comments)\n\n# Step 4: Create pages to divide your data into meaningful chunks\n\nIn our table, a few columns are only headers. They were still purposely added to create pages. You could also do this by creating virtual columns, but to show you the basics, it will be demonstrated with real ones.\n\nTo create a new page, select \"Show\" as data type in the column that should be your header for your new page.\n\n \n\nThen click on the pencil next to the name. In the pop-up window, you can see that you can define \"Type Details\". \n\n \n\nSelect \"Page_Header\" and type in the text you want to display as the page header.\n\n \n\n\n\\\n\n\\","HTML":"
A good starting point is a Google Sheet. The columns will later be the fields that can be filled in in the App.
\nYou then start by clicking on "+ Create", go to "App" and "Start with existing data".
\nYou then give the App a Name and choose a Category.
\nChoose the corresponding Google Sheets. You can create a Google Sheet in your drive or you might click on "Shared drives" and select "E+ SciLMi":
\nAfter a short processing phase, you should see this:
\nData is where you can see all the columns that are now data sets. For each column, you can define which field it will be, decide for a key and for labels, predefine content or write descriptions for the field, etc.
\nViews is where you define how the data will be shown to the user. Here, you can decide which data is shown, how it is displayed and how it can be edited.
\nAppSheet automatically defines data types for your columns. However, if you want more than texts, names or numbers, you will have to define them themselves.
\nTypes that I often used are:
\nIn our table, a few columns are only headers. They were still purposely added to create pages. You could also do this by creating virtual columns, but to show you the basics, it will be demonstrated with real ones.
\nTo create a new page, select "Show" as data type in the column that should be your header for your new page.
\nThen click on the pencil next to the name. In the pop-up window, you can see that you can define "Type Details".
\nSelect "Page_Header" and type in the text you want to display as the page header.
\n