GSP1030

Overview

In this lab, you use AppSheet to deploy and publish your app so end users can access and use your app.

What you'll do

In this lab, you learn how to perform the following tasks:

• Run a deployment check on your app to check for any errors or warnings.
• Fix any errors and resolve any warnings that may be reported.
• Deploy and publish your app using instant deployment.
• Test the app as an app user.

Setup and requirements

Before you click the Start Lab button

Read these instructions. Labs are timed and you cannot pause them. The timer, which starts when you click Start Lab, shows how long lab resources will be made available to you.

This hands-on lab lets you do the lab activities yourself in a real cloud environment, not in a simulation or demo environment. It does so by giving you new, temporary credentials that you use to sign in and access AppSheet for the duration of the lab.

What you need

To complete this lab, you need:

• Access to a standard internet browser (Chrome browser recommended).
• Time to complete the lab.

1. Make sure you are signed into Google Cloud Skills Boost using an incognito window.

2. When ready, click .

   A new panel will appear with the temporary credentials that you must use for this lab.

   If you need to pay for the lab, a pop-up will open for you to select your payment method.

3. Note your lab credentials. You will use them to sign in to AppSheet for this lab.

   Note: If you use other credentials, you will get errors or incur charges.

4. Click Open AppSheet.

5. Click to sign in with Google.

   

6. In the Sign in with Google dialog, enter the Username provided for the lab and click Next.

   Note: If you see other accounts listed, click Use another account, enter the credentials provided for this lab, then click Next.

7. Enter the password provided for this lab and click Next.

8. Click I Understand to accept the terms.

9. On the AppSheet consent page, click Allow. This allows AppSheet to access the Google Drive folders associated with your Google Cloud Skills Boost account.

   

10. You are now signed in to AppSheet.

    

    Click on the X in the top right corner of the Tell us about you so we can make better recommendations dialog to view the AppSheet MyApps page.

    The MyApps page is empty since you do not yet have any apps.

Task 1. Create the app

When working on your own or your company's app, you normally would incrementally build the app over a continuous project timeline.

Apps that you build are saved and accessible in the Prototype Apps section on the My Apps page until they are deployed and published.

In this task, you create the app that was built in a previous lab, using a template.

Delete prototype app (if listed)

In the lab environment on some occasions it's possible that the app built in a previous lab is still listed in the Prototype Apps section. You cannot use this app to continue working on this lab since the underlying data is not available for use by the app.

The app must first be deleted before continuing with this lab.

1. If the Customer Contacts app is listed, click the 3-dots menu () and select Delete to delete the app.

2. Click Ok to confirm the deletion.

Copy the app to your AppSheet account

1. Click the link to copy the Customer contacts app to your AppSheet account.

2. In the left menu, click the Copy app icon.

3. On the Copy App form, specify the following, and leave the remaining settings as their defaults:

   Property	Value (type or select)
   App name	Customer Contacts

4. Click Copy app.

Your app is set up with the original contacts and companies data sources, and you can now continue to build out the app's functionality.

Click Check my progress to verify the objective. Create the app

Task 2. Check your app for errors or warnings

In this task, you check your app for any errors or warnings by running a deployment check.

Run a deployment check

1. To run a deployment check on your app, navigate to the Manage > Deploy tab in the AppSheet UI.

2. Click Deployment Check.

   

3. Click Run Deployment Check.

   

   The output of the deployment check lists any errors or warnings that you should fix, before deploying the app.

Inspect the deployment check report

• View the report to look for any errors or warnings from the deployment check. Scroll to see the full list of issues.

  

  The report contains a few errors or warnings. You fix these issues in the next task.

Task 3. Fix any errors and warnings from the deployment check

In this task, you review the details of each error or warning as reported in the output of the deployment check and fix them.

Note: Warnings do not prevent you from deploying your app, but you must fix any errors that are reported. It is a good practice to review all warnings and resolve them if possible.

Fix the Data structure error

1. Click the Data matches expected structure error.

   The section expands to provide more details on the error.

   

2. Click More info to view more details about this error.

   From the description of the error, you can see that there is a mismatch between the name of the Company ID column in the app definition and the name of the column Company in the contacts Google sheet.

3. To fix this error, navigate to the Data section in the AppSheet editor, and click contacts to open the table definition.

4. Edit the name of the Company ID column and update it to Company.

5. The Company column is also used in the app formula expression for the Related contacts reverse reference column in the Companies table, which must be updated.

   In Data, click companies to open the table definition.

6. Click into the Formula field of the Related contacts column definition to bring up the Expression Assistant.

   

7. Edit the App Formula expression to update the column name to Company.

   

8. Click Save in the Expression Assistant.

9. Click Save to save your app changes.

Fix the App description warning

It is a good practice to include a short description of your app.

1. Click the App description warning.

   The section expands to provide more details on the warning.

   

   Click More info to get more details on the issues reported that include the likely cause and resolution steps.

2. To fix the App description warning, navigate to the Settings, and then click on Information under settings in the AppSheet UI.

3. Click App Properties.

4. In the App Properties form, specify the following, and leave the remaining settings as their defaults:

   Property	Value (type or select)
   Short Description	An app to manage all of your customers and contacts in one place.
   Industry	Business Services

5. Click Save to save your changes.

Fix the Custom launch icon warning

Your app is already configured to use one of the logo icons provided by AppSheet. This warning is to remind you to change the logo to your own custom icon.

1. Click the Use custom app launch icon warning.

   The section expands to provide more details on the warning.

   Optionally, click More info to get more details on the issues reported that include the likely cause and resolution steps.

2. To provide a custom app launch icon for your app, navigate to the Settings > Theme & Brand pane in the AppSheet UI.

3. For App logo, select Custom from the dropdown list.

4. Copy and paste the url below in the edit box to the right of the logo:

   https://storage.googleapis.com/cloud-training/T-APSDEV-B/app_logo.png

   

5. Click Save to save your changes.

Fix the Content caching on the mobile device warning

This warning indicates that your app could benefit from offline device caching of images and documents.

1. Click the Content caching on the mobile device warning.

   The section expands to provide more details on the warning.

   Optionally, click More info to get more details on the issues reported that include the likely cause and resolution steps.

2. To enable this option, navigate to the Settings > Offline mode pane in the AppSheet UI.

   In the Offline Use section.

3. Enable the Store content for offline use option.

   

   Learn more about offline content caching at the AppSheet documentation site.

4. Click Save to save your changes.

Task 4. Re-run the deployment check

Once you have fixed all errors and fixed or reviewed any warnings, you should run the deployment check again.

Run the deployment check

1. Navigate to the Manage > Deploy tab in the AppSheet UI.

2. If the deployment check report from the previous run is open, click Continue editing, otherwise click on the Deployment Check panel to expand it.

3. Click Run Deployment Check.

   The output of the deployment check should contain no errors or warnings. We can now go ahead and deploy the app in the next task.

Task 5. Deploy and test the app

In this task, you deploy the app and test it outside of the AppSheet UI directly within a browser.

Deploy the app

• In the Deployment Check panel, click Move app to deployed state.

  AppSheet now deploys your app and changes the app's state to Deployed.

  

Test the app

1. In the AppSheet UI, click the Share icon.

2. In the Share app dialog, click Copy sharing links.

3. Copy the Browser Link by clicking on the copy icon.

4. To open the app, paste the link in a separate browser window.

5. Alternatively, click on the Open in tab icon in the upper-right corner of the AppSheet editor above the app preview.

6. The app should load in the new browser window.

   

7. Test out the features of the app from the desktop browser to make sure all the functionality works as expected.

8. From the desktop browser that is running the app, click the ShipTo icon to open the shipping form.

9. In the form specify the following, and leave the remaining settings as their defaults:

   Property	Value (type or select)
   Product Name	Test Product
   Quantity	4
   Status	New
   Company	Any company from the list

   Verify that the app automatically displays the Shipping Info based on the selected company.

10. Click Save to submit the form and save the new shipping entry to the shipTo table.

Click Check my progress to verify the objective. Deploy and test the app

Task 6. Share your app

Once you have fully tested your app, you can share the app with yourself or any user so that they can download and start using the app.

Add users

The first step in sharing your app with users is to add them as users of your app.

1. To add a user to your app, click in the AppSheet UI.

2. In the Share app dialog, type a valid email address.

   Note: Type your own valid email address so you can run the app as a user on your device in the next task.

3. Optionally, you can add any additional user email addresses.

4. Check the reCaptcha box to verify that you are not a robot.

5. Optionally, update the invite message.

6. Click Send.

   Note: The reCaptcha verification has an expiry time, so you may have to check it again if it times out.

Verify receipt of the email

• Login to the email account you used in the previous task and verify that the email was received.

Congratulations!

You have successfully deployed and published your app using AppSheet.

In this lab, you learned how to:

• Run a deployment check on your app to check for any errors or warnings.
• Fix any errors and resolve any warnings that may be reported.
• Deploy and publish your app using instant deployment.
• Test the app as an app user.

Finish your quest

This self-paced lab is part of the Building No-Code AppSheet Apps quest. A quest is a series of related labs that form a learning path. Completing this quest earns you a badge to recognize your achievement.

You can make your badge or badges public and link to them in your online resume or social media account. Enroll in this quest and get immediate completion credit.

Refer to the Google Cloud Skills Boost catalog for all available quests.

Take your next lab

Continue the Building No-Code AppSheet Apps Quest with Build a Project Tracking App with AppSheet.

Next steps / Learn more

• Google Workspace Learning Center

Google Cloud training and certification

...helps you make the most of Google Cloud technologies. Our classes include technical skills and best practices to help you get up to speed quickly and continue your learning journey. We offer fundamental to advanced level training, with on-demand, live, and virtual options to suit your busy schedule. Certifications help you validate and prove your skill and expertise in Google Cloud technologies.

Manual Last Updated October 16, 2023

Lab Last Tested October 16, 2023

Copyright 2024 Google LLC All rights reserved. Google and the Google logo are trademarks of Google LLC. All other company and product names may be trademarks of the respective companies with which they are associated.