BG BGDatabase Home Setup How To Use Videos Example Breakdown Fields Export Import Data Binding Events Code Generation Addons

Live Update

← Back Basic setup guide
  1. Create new empty project
  2. Import BGDatabase package
  3. Create a new database (more information about creating a new database here )
  4. Create a new table, which will be used for storing information from Google sheet
  5. Add fields with proper types to newly created table
  6. To set up Google Sheet spreadsheet properly, you have 2 options:
    1. You can add required rows to database table (under "Database" tab) and export this data to GoogleSheet using our GoogleSheet plug-in. Exporting data will create a required sheet with all data and proper layout.
    2. If you already have your data in GoogleSheet spreadsheet, you need to give your sheet and columns the same names as database table and fields (case-sensitive!).
  7. Share your Google sheets spreadsheet by clicking on Share button then "Change" link and then "Done" button
  8. Enable "LiveUpdate" addon and switch to "VisualizationAPI" (you can also use another options, like "GoogleSheets API" or "Excel export" but these options require additional parameter/setup)
  9. Paste your spreadsheet ID to "Spreadsheet ID" parameter.
    You can find your spreadsheet ID in your browser URL
  10. Switch to LiveUpdate addon "Merge settings" tab and include "Test" table by pressing on "Create custom settings" and then toggling on the following parameters : "Add missing", "Delete orphaned" and "Update matching"
  11. Press on "Save all" button
  12. Setup is complete! Now you can enter play mode and data from GoogleSheet should be loaded properly
← Back to Live Update