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

Games

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 www.appsheet.com/appname. 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 www.appsheet.com

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?

ENUM, Ref, and ENUMLIST

Selection, List, Ref, and Text

Drop-Down, Enumeration, and List

Number, Boolean, and List

AppSheet Test Upwork 2019

