Appsheet

Set up

Create your first application

  1. Open Appsheet and sign in with your Google account
  2. Create an app
    • Start with existing data
    • Name of the app
    • Category
  3. Press choose your Data
    • Google Sheet
    • Select your tracking Spreadsheet
  4. Wait then press "Customize with appsheet"
  5. You will now receive a link to the app in your email
  6. Install the app on your mobile device
    • Install Appsheet from your device app store
    • Access App Gallery
    • Click on the app
    • Click on the menu top left
    • Click on Add shortcut
    • On ios click on the icon in the top right, then add to home screen

Congratulations you now created a data application. These applications can be shared to up to 10 people for free before you have to subscribe to a plan.

Copy an existing app

  1. Access to an application portfolio
  2. Select the app you desire
    • You are now in read only mode of the app architecture
  3. From the left side bar, access to the bottom icon named "Manage"
  4. Press "Copy App"

Tips and tricks

  • Everytime the column structure is modified in Google Sheet, we need to regenerate the schema in Appsheet for that data, else the app won't work anymore.
  • If a tab schema appears with the column names from the second row values, go to the tab in Google Sheets and apply Bold to the first row, then regenerate the schema in appsheet.