Create and copy databases - AppSheet Help (2024)

Create and copy AppSheet databases as described in the following sections:

  • Create a new database
  • Create a database by importing a Google Sheet
  • Copy an existing database
  • Create an AppSheet database when copying an existing app

Create a new database

To create a new database:

  1. Access the My Apps page.
  2. Select Create > Database > New database.
    A new database is created and opened in the database editor. It is named Untitled database, by default, and contains some basic example data.
  3. Rename the database by clicking the name and editing the contents.
  4. Manage the database using the database editor.

Create a database by importing a Google Sheet

You can only import a Google Sheet spreadsheet to create a database. Microsoft Excel (.xls or .xlsx) files can't be imported.

To create a database by importing a Google Sheet:

  1. Access the My Apps page.
  2. Select Create > Database > Import from Sheets.
  3. Navigate to and select the Google Sheet that you want to import.
  4. Click Select.
    The new AppSheet database is created from the Google Sheet and opened in the database editor. Its name defaultsto the name of the Google Sheet from which it was copied.

    Up to five worksheets from the Google Sheet will be imported into the AppSheet database.

    The pop-up blocker in your browser may preventAppSheet from automatically opening the database in the database editor. If it doesn't open automatically, navigate to the Databases tab and click the database in the list to open it in the database editor.

  5. Manage the database using the database editor.

Copy an existing database

To copy an existing database:

  1. Access the My Apps page.
  2. Click Databasesto view the list of existing databases.
  3. Click the database that you want to copy to open it in the database editor.
  4. Select SettingsCreate and copy databases - AppSheet Help (1)>Copydatabase.
  5. Manage the database using the database editor.

Create an AppSheet database when copying an existing app

Copy an existing app and select AppSheet database in the Save app tofield to create a copy of the app using an AppSheet database as the data source.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Create and copy databases - AppSheet Help (2024)

FAQs

How to create a database in AppSheet? ›

Select AppSheet database. Do one of the following: Click + Create new database, enter a name for the database and table, and click Create database and table. Select the database, click + Create new table, enter a name for the table, and click Create table.

How to duplicate an AppSheet? ›

Copy apps
  1. Sign in to AppSheet.
  2. Perform one of the following steps for the app you want to copy: On the My Apps page, locate the app and select More. > Copy. ...
  3. Enter the following information in the Copy app dialog: Field. ...
  4. Enable the options to copy the app data or file data (such as images), as required.
  5. Click Copy app.

How do I copy an AppSheet from one account to another? ›

Data sources are available in the recipient account
  1. Open the app in the editor.
  2. Go to Manage > Collaborate & Publish. We've made some improvements to the app editor. ...
  3. Expand the Transfer section.
  4. Click Request Transfer. Transfer requests remain active for 48 hours.

How to import data to AppSheet database? ›

Access the My Apps page. Select Create > Database > Import from Sheets. Navigate to and select the Google Sheet that you want to import. Click Select.

How can I create my own database? ›

Create your own database with these 9 tips
  1. Tip 1: Define Your Requirements and Capabilities.
  2. Tip 2: Choose the right platform.
  3. Tip 3: Design your database schema carefully.
  4. Tip 4: Don't forget safety measures.
  5. Tip 5: Thoroughly test your database.
  6. Tip 6: Document your database.
  7. Tip 7: Make regular backups.

How do I manually create a database? ›

Manual Database Creation
  1. Copy pfile from any other database server and rename it to new database SID other database pfile initproddb.ora change the file name to reflect new SID initdevdb.ora.
  2. Open the initdevdb.ora file, find and replace all old SID (proddb) with new SID (devdb).

Can you export data from AppSheet? ›

The app user can then sign-in to AppSheet using their account, invoke the application, and invoke the App: export this view to a a CSV file action, as described above. AppSheet will locate the Private table belonging to the signed-in user and export the contents of the Private table to the CSV file.

How do I mass duplicate in Google Sheets? ›

To copy multiple sheets simultaneously, click the first tab and left-click the second one while holding down the Ctrl key, and select “Duplicate” in a pop-up menu.

Can you sell apps made with AppSheet? ›

A branded app in AppSheet is a native mobile app with your own branding that you can publish directly in an app store or distribute on your own.

How do I share my AppSheet to another user? ›

Send users a link to your app
  1. Open your app in the app editor.
  2. Click the Share icon in the title bar. The Share app dialog displays.
  3. Click Copy sharing links.
  4. Copy the links to access your app in the editor, browser, or mobile device.
  5. Send the link to users using your preferred method.

How many users can use AppSheet for free? ›

Explore the AppSheet platform and test your apps with up to 10 users at no cost. When you're ready, sign up for a plan and deploy your apps to the rest of your team.

How to create an AppSheet database? ›

Sign in to AppSheet. Select Create > Database > Import from Sheets. Navigate to and select the Sheet that you copied in step 1. After selecting the Sheet, a new AppSheet database is created by importing data from the Sheet and opened in the database editor.

Where is AppSheet database stored? ›

If you use AppSheet databases, AppSheet will store your data in Google Cloud. Otherwise, data stored in AppSheet applications is primarily stored in a location of your choosing which can either be in a cloud storage service such as Google Sheets, or in a cloud database such as Cloud SQL.

What database does AppSheet use? ›

Summary of data source types
NativeSpreadsheetsOther data or provider services
AppSheet databasesGoogle Sheets Microsoft Excel (Office 365 and SharePoint)Airtable Apigee Box Dropbox Google Calendar Google Drive Google Forms Looker Studio OData Salesforce Smartsheet

How do I create a database in notion? ›

To create a database, click on the New page button, and select the database you'd like. Every item in a Notion database is its own page, where more information can be edited and organized. Add database properties such as text, numbers, dates, and people. Think of these as tags describing each database item.

How do you create a database for an app? ›

Ways to Setup Web Application Database
  1. Choose a web application platform. ...
  2. Find a web application hosting provider. ...
  3. Select a database management system (DBMS). ...
  4. Design the database schema. ...
  5. Configure the web application to connect to the database. ...
  6. Populate the database with data.

How do I create a database for flutter app? ›

Let us see step by step how we can store and fetch data in the Flutter.
  1. Step 1: First, create a new project in Android Studio and add the dependencies in pubspec. ...
  2. Step 2: Create a model class. ...
  3. Step 3: Open the database. ...
  4. Step 4: Create the table. ...
  5. Step 5: Insert a Book into the database.

Top Articles
10 Reasons why having a second mobile number is a must have! - Blog
What Are Gold Coins Worth
Lifewitceee
J & D E-Gitarre 905 HSS Bat Mark Goth Black bei uns günstig einkaufen
13 Easy Ways to Get Level 99 in Every Skill on RuneScape (F2P)
Health Benefits of Guava
Jesus Calling December 1 2022
Flixtor The Meg
Beautiful Scrap Wood Paper Towel Holder
Unraveling The Mystery: Does Breckie Hill Have A Boyfriend?
Soap2Day Autoplay
Embassy Suites Wisconsin Dells
Tv Schedule Today No Cable
Voyeuragency
Bernie Platt, former Cherry Hill mayor and funeral home magnate, has died at 90
Gwdonate Org
6001 Canadian Ct Orlando Fl
Learn2Serve Tabc Answers
How to find cash from balance sheet?
State HOF Adds 25 More Players
Spoilers: Impact 1000 Taping Results For 9/14/2023 - PWMania - Wrestling News
Heart and Vascular Clinic in Monticello - North Memorial Health
Cincinnati Adult Search
Rimworld Prison Break
Craigslist Houses For Rent In Milan Tennessee
What Are The Symptoms Of A Bad Solenoid Pack E4od?
25 Best Things to Do in Palermo, Sicily (Italy)
Baldur's Gate 3: Should You Obey Vlaakith?
Rgb Bird Flop
By.association.only - Watsonville - Book Online - Prices, Reviews, Photos
Jamielizzz Leaked
Evil Dead Rise Showtimes Near Regal Sawgrass & Imax
Angel del Villar Net Worth | Wife
Missing 2023 Showtimes Near Mjr Southgate
Junior / medior handhaver openbare ruimte (BOA) - Gemeente Leiden
What Time Is First Light Tomorrow Morning
Los Garroberros Menu
Stafford Rotoworld
Telugu Moviez Wap Org
Craigslist Pa Altoona
303-615-0055
Lovely Nails Prices (2024) – Salon Rates
Emily Tosta Butt
COVID-19/Coronavirus Assistance Programs | FindHelp.org
Charli D'amelio Bj
Petfinder Quiz
8 4 Study Guide And Intervention Trigonometry
Gander Mountain Mastercard Login
The Quiet Girl Showtimes Near Landmark Plaza Frontenac
How To Find Reliable Health Information Online
Syrie Funeral Home Obituary
Varsity Competition Results 2022
Latest Posts
Article information

Author: Carmelo Roob

Last Updated:

Views: 6285

Rating: 4.4 / 5 (45 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Carmelo Roob

Birthday: 1995-01-09

Address: Apt. 915 481 Sipes Cliff, New Gonzalobury, CO 80176

Phone: +6773780339780

Job: Sales Executive

Hobby: Gaming, Jogging, Rugby, Video gaming, Handball, Ice skating, Web surfing

Introduction: My name is Carmelo Roob, I am a modern, handsome, delightful, comfortable, attractive, vast, good person who loves writing and wants to share my knowledge and understanding with you.