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:
\n1, 42, -10). If you need decimals (e.g., 10.5), you must use the Decimal or Price column types instead.\n1000000as 1,000,000). You can turn this off in the column settings by toggling Show thousands separator to OFF.\nKey Settings to Know
\nThe most commonly used views and the ones that seemed useful for our context are:
\nis highly visual and displays rows as individual "cards" stacked on top of each other. It is the most popular view for mobile app layouts and was also the one particularly easy to work with for the Lesson Plan Artefact Analysis.
\nBest Used For:
\nIn the browser app, a deck looks like this:
\npresents your data in a traditional grid format of rows and columns, closely resembling a spreadsheet.
\nBest Used For:
\nIn the browser app, a table looks like this:
\nis used exclusively for entering new data or editing existing data. Unlike Table or Deck views, which are for viewing data, Forms are for submitting data.
\nBest Used For:
\nIn the browser app, a form looks like this:
\nFor your view, you can decide whether you want it to show your whole dataset or a slice of it. You can create a new slice by clicking on the plus in the dropdown under 'for this data':
\nHere, you can decide which columns will be included in your slice.
\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.
\nWhen you click on 'edit' in one line in the Browser App, a 'Next' button will appear in the upper-right corner. Clicking this will take you to the next page, which begins with your page header; in this case, 'SSI Sequence'.
\nTo create a conditional visibility, you have to again click on the edit symbol of the column you want to be conditionally visible and then the Show? field.
\nWhen you click into the field, a pop-up will appear. Here you can, for example, make the visibility depend on an answer in another field …
\n… or on the person who edits the field:
\nExcel requires unique column headers to properly identify and reference data. To prevent duplicate titles, you can append identifiers (like numbers) to the column names and use the Display Name to keep the headers clean for users.
\n