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
How does the stock market relate to the economy? - Public.com
Combien de temps dure une transaction ethereum?
Lexi Vonn
craigslist: south coast jobs, apartments, for sale, services, community, and events
The Best English Movie Theaters In Germany [Ultimate Guide]
Victoria Secret Comenity Easy Pay
Craigslist Dog Sitter
Cinepacks.store
Overzicht reviews voor 2Cheap.nl
41 annonces BMW Z3 occasion - ParuVendu.fr
Erskine Plus Portal
Nissan Rogue Tire Size
Craighead County Sheriff's Department
Lowe's Garden Fence Roll
Craigslist West Valley
The BEST Soft and Chewy Sugar Cookie Recipe
LCS Saturday: Both Phillies and Astros one game from World Series
Yonkers Results For Tonight
[PDF] PDF - Education Update - Free Download PDF
Globle Answer March 1 2023
Aspenx2 Newburyport
Powerschool Mcvsd
Netwerk van %naam%, analyse van %nb_relaties% relaties
Meridian Owners Forum
Telegram Voyeur
Local Collector Buying Old Motorcycles Z1 KZ900 KZ 900 KZ1000 Kawasaki - wanted - by dealer - sale - craigslist
Pain Out Maxx Kratom
Wolfwalkers 123Movies
In hunt for cartel hitmen, Texas Ranger's biggest obstacle may be the border itself (2024)
Nail Salon Open On Monday Near Me
Pnc Bank Routing Number Cincinnati
404-459-1280
The 50 Best Albums of 2023
Telegram update adds quote formatting and new linking options
Cl Bellingham
Craiglist Hollywood
Blackstone Launchpad Ucf
WorldAccount | Data Protection
Top 25 E-Commerce Companies Using FedEx
Mugshots Journal Star
Hkx File Compatibility Check Skyrim/Sse
Blackwolf Run Pro Shop
Iman Fashion Clearance
Cult Collectibles - True Crime, Cults, and Murderabilia
Terrell Buckley Net Worth
Bonecrusher Upgrade Rs3
Dineren en overnachten in Boutique Hotel The Church in Arnhem - Priya Loves Food & Travel
Cars & Trucks near Old Forge, PA - craigslist
Craigslist Psl
O'reilly's Eastman Georgia
Electronics coupons, offers & promotions | The Los Angeles Times
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.