Google AppSheet FAQ

Answers to your most common questions about Google AppSheet.

Quick, simple, and helpful information at a glance.

What is Google-Appsheet?
Google-Appsheet is a no-code development platform that allows you to build mobile and web applications using data from Google Sheets, Excel, and other data sources.
How do I access Google-Appsheet?
You can access Google-Appsheet through your Google account by going to https://www.appsheet.com/ and signing in with your credentials.
Why am I getting an error message "Appsheet encountered a problem"?
This error message usually indicates a server issue or a problem with your internet connection. Try reloading the page or accessing Appsheet at a different time.
How do I create an app in Google-Appsheet?
To create an app, you can either use a template or start from scratch by connecting your data source and designing the app's interface.
Why am I getting an error "Invalid column name"?
This error usually means that the column name in your data source does not match the column name in your app's table. Make sure the names are spelled and formatted correctly.
How do I add new data columns in an existing app?
To add new data columns, go to the Data tab in Appsheet, select the table you want to modify, and click on "Add Column."
Why is my app not syncing with my data source?
There could be various reasons for this, such as incorrect data source credentials or a slow internet connection. Try checking your connection and re-configuring your data source settings.
How do I create a dropdown menu in my app?
To create a dropdown menu, you will need to use the Enum type in your data column, which allows you to specify a list of options that can be chosen from a dropdown menu in the app.
Why am I getting an error "Invalid expression"?
This error indicates that there is an error in the formula you are using. Check for any typos or incorrect syntax in your expression.
How do I set up security filters in my app?
You can set up security filters in your app by going to the Data tab, selecting the table, and then clicking on the "Security Filters" option. You can then add conditions to filter the data that users have access to.
Why am I unable to install my app on my device?
This may be because your device is not compatible with the app or you do not have sufficient permissions to install apps outside of the Google Play Store. Check your device's settings and try using a different device if necessary.
How do I make changes to my app without affecting the live version?
You can make changes to your app by using the "version control" feature in Appsheet. This allows you to make edits and preview them before deploying the changes to your live app.
Why are my app's formulas not calculating correctly?
This could be due to incorrect data types or missing data in your table. Make sure all the necessary data is present and check your formulas for any errors.
How do I restrict access to certain data in my app?
You can restrict access to data by using the "slice" feature in Appsheet. This allows you to filter certain rows or columns of data based on specific conditions.
Why am I getting an error "app unavailable"?
This error means that the app you are trying to access is currently unavailable. It could be due to server maintenance or a problem with the app's configuration. Try refreshing the page or contacting Appsheet support for assistance.
How do I delete my app?
To delete your app, go to the Appsheet website, click on the app you want to delete, and select the "Delete" option under the "Settings" tab.
Why am I getting an error "Column not found"?
This error means that the column you are trying to use in your app does not exist in your data source. Make sure the column name is spelled correctly and is present in your data.
How do I change my app's logo and branding?
You can change your app's logo and branding by going to the "Deployment" tab and selecting the "Branding" option.
Why am I unable to add a column in the app editor?
This could be due to permission restrictions or the maximum limit for the number of columns in your app. Contact Appsheet support for further assistance.
How do I create a chart in my app?
You can create a chart in your app by using the chart type in your data column and configuring the chart's settings under the "Display" tab in the app editor.
Why is my app's performance slow?
There could be various reasons for this, such as a large amount of data, complex formulas, or insufficient device resources. Try optimizing your app's design and data to improve performance.
How do I customize the appearance of my app?
You can customize your app's appearance by using the "UX" tab in the app editor, where you can change the app's color, font, and layout.
Why am I getting an error "Unmatched IF Function"?
This error means that there is an uneven number of "IF" and "THEN" expressions in your formula. Check your formula for any errors and ensure the number of expressions is equal.
How do I share my app with others?
To share your app, you can use the "deploy" feature in Appsheet, which allows you to generate a link or QR code that you can share with others.
Why am I unable to save my changes in the app editor?
This could be due to a temporary issue with the Appsheet server or a problem with your internet connection. Try refreshing the page and saving again.
How do I add an image to my app?
To add an image, use the "Image" column type in your data column and specify the URL or file location of the image you want to display.
Why am I getting an error "Table too large to display"?
This error means that the table in your app is too large to display and may cause performance issues. Consider splitting the data into multiple tables or removing unnecessary columns.
How do I delete a row of data in my app?
To delete a row of data, go to the Data tab, select the table, and click on the row you want to delete. Then click on the "delete" button at the bottom of the screen.