AppSheet Test Upwork

What types of apps can AppSheet build?

Data driven apps from cloud-stored data
Mobile apps from social media profiles
UI driven apps

What does a Ref type let you do?

It creates a reference between the field and the primary key in another table, generating a drop-down when adding data
It lets you add a search term for reference in a field
It lists similar terms in the same dataset
It references the number of tables, rows, and columns of the spreadsheet, showing the file's metadata

If there is no single column with unique data in the spreadsheet, what would AppSheet attempt next?

Create a computed key from a composite set of existing columns. If no unique values are available from the composite, it will assign the row number as the primary key
Block the app from working
Create an additional column with random values. All other columns in the table will shift one place to the right
Repace the data in the first column to have unique values

Where can you use Slices in the app?

Controls (views), Workflow Rules, Formatting
Conditional Branching, Forms, App Security
App Sign-in, Whitelist, Column Structure
Branding, Formatting, Controls, Options

Where can users load AppSheet apps?

iOS, Android, and modern mobile and desktop browsers
iOS only
Android and desktop browser
Desktop and mobile browser only

You app captures images. How can you change the resolution of the images uploaded through the app?

Go to Settings > Content > Image upload resolution
Image resolution is set to the device's default
You can change the resolution in Column Structure > Image Type
Image resolution is standard to the screen resolution

What sub-sections are available under the Data tab in the Advanced Editor?

Tables - Column Structure - Slices
Column Structure - Formatting - Workflow
Data - UX - Settings
Tables - Workflow - Views

Which of the following is NOT a message type (Warnings, Errors, Info) in the AppSheet editor?

ORANGE: There is an error with the data definition which must be refreshed
YELLOW: The app is still functional but there may be unexpected app behavior from usage
RED: The app cannot function due to a critical error that must be repaired before continuing work with the app
BLUE: The app is functional but AppSheet did a change to the app behavior to preserve stability of the app and data

Your app has an ENUM type field with three options, and one of them is HOUSE. You want every row that has HOUSE in that field to have a BLUE font color. How do you achieve that?

Create a slice for all rows where that field equals HOUSE, then create a formatting rule that defines the color of the font as BLUE and select all columns to be formatted
Create a new formatting rule that points to the column with the ENUM and define font color as BLUE
Create a new view called HOUSE. AppSheet will automatically show all items with the word HOUSE and select Action as BLUE
Create a Workflow rule to change the font color to BLUE

You have a list of locations in a column that AppSheet didn't automatically recognize as an address type. How do you get those locations in a map?

Go to Column Structure and change the column type to Address. Then add a map view that points to the column
Add a map view and select the column you want to show in the map
Create a computed key that includes the target column and a column with GPS coordinates
Re-write the locations with GPS coordinates in [ ] brackets

Once your AppSheet App is ready, how do you get it to the intended app users?

Send email invitations to the app users via the Share/Install button
Publish the app in the corresponding app store
The user must request access to the app via When access is granted, the app is installed with the user
Use the app deployment button

Once the app is ready for deployment, how do you inform people the app is available?

By sending an invitation email from the Share/Install button or user whitelist
Through its listing in the App Store
By adding their email to the user list
By sending an email to the users directly and asking them to download AppSheet

Which statement best describes the role of columns in AppSheet apps?

Columns define the type of data which then corresponds to specific mobile app behavior
Columns mark the width of the views in the app
The number of columns define the number of views in the app
Columns define whether the data is ready for tablet or smartphone use

What happens if I refresh/regenerate the column structure of the app due to major spreadsheet/app changes after I have deployed it?

App users need to sync the app to get the latest version before submitting new data
App users need to go to the app editor and regenerate the app
App users need to download a copy of the spreadsheet to compare the columns against the app
Because the app hasn't changed, then the app will continue to work as intended

You want to display information from two different tables in the same app. What do you do?

Go to the Data tab and add another table.
AppSheet only shows information from a single table
Merge spreadsheets, create a helper column, and use a slice to show two views of the same data
Put the two tables side-by-side in the first tab of the spreadsheet. AppSheet will recognize the tables and produce an app accordingly

When the app user is adding data, how are those changes recorded in the back-end spreadsheet by default?

As the app creator. The spreadsheet and cloud storage use the credentials of the app creator to update the file
As the app user. The spreadsheet and cloud storage use the credentials of the app user to update the file
As AppSheet. AppSheet uses its own credentials to update the spreadsheet file
A copy of the spreadsheet is automatically saved in the app user's Google Drive

You want to capture GPS locations in one column but AppSheet didn't recognize the column for that purpose. You then:

Go to Data > Column Structure and change the field type to LatLong
Rebuild the spreadsheet to have more recognizable column headers
Create a Map view to capture GPS data
Create an ENUM with the key locations

How does AppSheet manage mobile deployment?

Light deployment model with a "container" app (AppSheet) that serves the app created by the user
Publishes directly to the App Store
Creates a website that is loaded through a mobile browser
AppSheet apps only open in desktop PCs

You want to create two apps that look at the same data, but have minor differences in UX. What's a quick way to achieve it?

Create an app and then copy it while using the same data as the original, then tweak the second app
Start the second app from scratch by loading the same spreadsheet to a new app
AppSheet can only serve one app per spreadsheet
Select the "Sample App" option under Settings

What are the two recommended options to "un-deploy" an app?

Delete the app or remove a user email from the whitelist to lock the user out from the app
Delete the spreadsheet or replace it with dummy data
Remove all the views in the app or send "cease use" email to the users
Contact AppSheet Support to request an "un-deployment" service

What happens when you make an app a Sample App?

The app becomes publicly available in your App Portfolio at
The app changes its status to Sample and becomes part of AppSheet's sample gallery
The app begins to accept new data entries from anyone with access to the app
You can sell the app in the App Store

You want to receive an email notification every time a new entry has been made through the app. What do you do?

Add a Workflow rule in the Settings > Workflow tab to send you an email for data ADDS
Request that each app user send you an email when they enter information
Create a script/macro that automatically sends an email when a new row is added
Create an automated email to remind you to check the spreadsheet every 15 minutes to find new data

What AppSheet concept is defined with this description?

Primary Key
Selection Record
Employee ID
Primary Record

Once the app is deployed, how do you know if it's being used?

Use the Stats charts available in Account > Activity
Send a small survey to your app users and ask them if they are using the app
Create a chart in the app that tracks the number of times the app is loaded every day
Use an API to track app usage

In AppSheet, what are Slices?

A subset of the rows and columns of a table
A ranked view of data that matches certain criteria
A method to delete unnecessary data in an app
Slices are ways to divide the top and bottom of an app view

What happens when you have a duplicate primary key?

AppSheet will warn of the duplicate value while creating the app
When you update one of the items with the duplicate primary key, all information will be duplicated
The app will crash and not function outside of the app emulator
Appsheet automatically deletes the record

What's the optimal way for AppSheet apps to run on a mobile device?

First install AppSheet from the App Store, then install your AppSheet app
Run the app in a mobile web browser
Deploy the app via admin console
Run the app via virtualized desktop

You want to change the type of data for a column after AppSheet has created the app. You then...

Go to the column structure menu in the Advanced Editor and change the column type
Change the column name, change the spreadsheet file name, and load it in AppSheet again
Regenerate the app multiple times until AppSheet recognizes the field type
Modify the views in UX > Controls

When you add a view (control), what information is displayed in the app?

You can select the target information. It can be a table or a slice
AppSheet always selects the target information based on the view's name
You pick the slice but AppSheet picks the default table
You can only pick slices for new views

You want your app to only capture data through a form without showing results of the forms. Which of the following is correct?

Make the table you plan to use ADDS ONLY, then create a single view in the app that is of Form Type
AppSheet cannot deliver forms-only apps
Define a list view as ALL CHANGES, then remove any unnecessary views
Define a list view as ADDS AND UPDATES and include a Submit view to the app

Where are signatures and images stored when captured with AppSheet?

In the App Creator's cloud storage for the app
In the cloud drive of the App User
In AppSheet's cloud storage
Both in the App Creator's and App User's respective cloud drives

You only want a specific group of people to see the data in the app and not be able to share it. What do you do?

Require sign-in to the app and manage the user whitelist
Share the spreadsheet with only a small group of people and then distribute the link to the app broadly
Make the tables read-only and create a slice with a field: Matches the user email
Send the link to the group of people and ask them not to share

What happens if you change the order of the columns in the back-end spreadsheet of an AppSheet app?

You must refresh the column structure and review any changes to the app derived from that action
AppSheet will generate a copy of the app from the new column structure
You must request that every app user sync the app and tell you if they are seeing any errors
You must un-publish the app and then re-publish the new version

What is the difference between ENUM and ENUMLIST?

ENUMLIST allows multiple selection while ENUM allows single choice
ENUMLIST allows for "Other" values while ENUM is a fixed list
ENUM allows only up to 5 items while ENUMLIST shows more than 5 items
ENUM and ENUMLIST have the same behavior

How many views can you add in an app?

Up to 3 views in the bottom bar, unlimited in the "hamburger" menu
3 views in the bottom bar and up to five in the "hamburger" menu
Up to 3 views combined in the bottom bar and "hamburger" menu
Up to 10 combined views between the "hamburger" menu and bottom bar

What are the different update modes for a given table?

Read Only, Add, Delete, Update, All Changes
Read Only and Write Only
Add, Delete, Update
Read, Delete, and Write Only

Can the app have icons on the device's home screen?

Yes - the icon is a shortcut to AppSheet which then loads the app
No - the app can have a logo but cannot be added to the home screen
Yes - but only in tablets, not smartphones
No - you can only load apps from AppSheet's App Gallery

What are App Formulas?

A mechanism to define values that are computed dynamically in the mobile app
Combinations of apps that use references to display rich information
Spreadsheet formulas that also work in the app
A method to create formatting rules for AppSheet apps

Which field types let you produce a drop-down list?

Selection, List, Ref, and Text
Drop-Down, Enumeration, and List
Number, Boolean, and List

AppSheet Test Upwork 2019