

Now Forms will even work to add rows to a table. We were able to enter in using theįorm here. We don't have to enter it in the spreadsheet format. If we go to the sheet we can see how they're linked because there's our data entered in. And we can use the arrows to go back and forth between all the data.

Tap in the fields here, and we can enter in more data and there we go. And when we're done entering this in, we can use these button at the bottom to add more.just plus will go to the next one. Going to enter in just some fake data here. And the 3rd column, we will change to a 'Number'.

We can select the 2nd column, change that to 'Currency'. And here we can change the type by tapping the 'i' here and change it to 'Text'. Let's go back to the spreadsheet and let's select the entire column there by clicking on the bar above the 1st row. Now we only have 1 table, it's called Table 1 so we'll select that and instantly we can see that it picked up Item, Price and Amount from the top row and made it a different fields for the form. So press plus and Create New Form and it'll ask us to choose one of the tables. And then we can go from there and enter bits of information just down here without having to create a form. We're going to create a simple inventory demo so we'll do Item, Price, and Amount. Now Numbers knows that the top row is suppose to be column headings. So create a new spreadsheet and choose the blank template.

So you can create a spreadsheet and then fill in the data in rows using forms, kind of like a database, rather than actually entering them in the grid of the spreadsheet. So Numbers has this cool feature that isn't even available on the Mac, and that's the ability to create forms. On today's episode, let's look at Numbers on the iPad and how you can use Forms on Table to enter data. Video Transcript: Hi, this is Gary with MacMost Now. Check out MacMost Now 398: Creating Forms In iPad Numbers at YouTube for closed captioning and more options.
