WEBVTT

00:01.000 --> 00:04.500
We'll create an app from a Google Sheets spreadsheet.

00:04.500 --> 00:08.500
These three columns will be turned into three form fields.

00:11.000 --> 00:15.000
We'll start by creating a new calculation panel.

00:20.000 --> 00:24.000
One field for every column is created.

00:30.000 --> 00:34.000
The color field should contain a text string.

00:34.000 --> 00:38.000
The price field is a currency field.

00:41.000 --> 00:48.000
The product field should be a drop-down field.

00:51.000 --> 00:55.000
Let's select all product names and copy them to the clipboard.

00:56.000 --> 00:59.000
Press Control+C (PC) or Command+C (Mac).

00:59.000 --> 01:03.000
Edit the values as text so you can easily paste the names.

01:03.000 --> 01:06.000
Press Control+V (PC) or Command+V (Mac).

01:06.000 --> 01:09.000
Make the first product selected when the app starts.

01:11.000 --> 01:15.000
Now, let's copy all prices to the clipboard.

01:15.000 --> 01:18.000
Press Control+C (PC) or Command+C (Mac).

01:20.000 --> 01:24.000
Let's switch to the app which converts data to CHOOSE formulas.

01:24.000 --> 01:31.000
Ensure that the field name matches the name for the drop-down field.

01:31.000 --> 01:34.000
Paste the column data into the top-most field.

01:34.000 --> 01:37.000
Press Control+V (PC) or Command+V (Mac).

01:37.000 --> 01:41.000
Prices are numbers, so let's double-click the formula for number fields and...

01:41.000 --> 01:45.000
Press Control+C (PC) or Command+C (Mac) to copy it.

01:45.000 --> 01:49.000
Now, let's paste the formula. Select the price field and click the formula bar.

01:49.000 --> 01:52.000
Press Control+V (PC) or Command+V (Mac).

01:59.000 --> 02:03.000
Now, let's copy the colors.

02:10.000 --> 02:13.000
Paste the color values.

02:13.000 --> 02:18.000
Colors are text strings, so we need to copy the formula for text fields.

02:22.000 --> 02:25.000
That's it! Let's take a look at a preview of the app!

02:43.000 --> 02:46.000
Thanks for watching!