# App Building with AppSheet: Challenge Lab - ARC105

## **Overview**

In a challenge lab you’re given a scenario and a set of tasks. Instead of following step-by-step instructions, you will use the skills learned from the labs in the course to figure out how to complete the tasks on your own! An automated scoring system (shown on this page) will provide feedback on whether you have completed your tasks correctly.

When you take a challenge lab, you will not be taught new Google Cloud concepts. You are expected to extend your learned skills, like changing default values and reading and researching error messages to fix your own mistakes.

To score 100% you must successfully complete all tasks within the time period!

### **Task 1. Create a new AppSheet app**

* Create a new AppSheet app named **Company Details** using the [companies](https://docs.google.com/spreadsheets/d/1fsusJTqRwsURG9GpduXVZE8XXfv9vzq5XXI9jBlcq9M/copy) sheet.
    

Click *Check my progress* to verify the objective.

Create a new AppSheet app

### **Task 2. Add a new company**

* Use the preview of the **Company Details** app to add a new company with the following details:
    

| **Attribute** | **Value** |
| --- | --- |
| ID | 11 |
| Company Name | Cymbal Austin |
| Business Address | 500 W 2nd St, Austin, TX 78701 |

Leave the other attributes blank.

Click *Check my progress* to verify the objective.

Add a new company

### **Task 3. Update and regenerate your app's data structure**

* Add a new column named **Website** (to column G of the **companies** sheets), set the column type as `Url`, and regenerate the app's data structure.
    

Click *Check my progress* to verify the objective.

Update and regenerate your app's data structure

**Check my progress**

### **Task 4. Deploy and test your app**

* Deploy your app and test it by adding a new company in the browser running your deployed app:
    

| **Attribute** | **Value** |
| --- | --- |
| ID | 12 |
| Company Name | Cymbal Houston |
| Business Address | 3663 Washington Ave, Houston, TX 77007 |
| Website | cymbal-houston.com |

Leave the other attributes blank.

---

### Solution of Lab

%[https://youtu.be/dDk2luM4EzI] 

**Step 1:** Copy this file to **Google Drive** with the name [companies](https://docs.google.com/spreadsheets/d/1fsusJTqRwsURG9GpduXVZE8XXfv9vzq5XXI9jBlcq9M/copy) sheet.

**Step 2:**<mark>Download file</mark>**:** [companies.xlsx](https://github.com/ePlus-DEV/storage/blob/main/labs/ARC105/companies.xlsx) (*Then import and replace the copied file in step 1*).

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1723084310707/a9d94931-3dea-4c78-9e38-b8d5dee6dbf2.png align="center")