![]() ![]() Tap the Date field on the form, and a data entry window appears: Tap “now” to automatically enter the current date and time. Ready to take a road trip? Let’s enter some data into the form by opening the spreadsheet and tapping our form (I’ve renamed it from the default “Table 1 Form” to “Entry Form”): The blank entry form on an iPhone Numbers automatically adds the calculated mileage to the bottom of the form, showing the number in gray (instead of black) to indicate that it was calculated and not entered. To automatically calculate the total mileage driven, I created a calculation subtracting the starting mileage from the ending mileage, then copied and pasted that calculation into the cells below the first calculation. After defining field formats, I tapped the “Sheet 1” tab to open my spreadsheet and table. There are two choices: Business and Personal. ![]() To make data entry simple for the “Business or Personal” field, we selected Pop-Up Menu as the format. ![]() Selecting format (Date & Time) and a specific date and time formatįor the Starting Mileage and Ending Mileage fields, we selected Number as the format, then chose to have one digit after the decimal point (allowing tenth of mile increments). Want a specific format for date and time? Tap the info circle next to Date/Time and a list of possible date and time formats appears (at right below). To do so, tap the green “info” circle at the right side of each field and a list of possible field formats appears (at left below). For date, we want to set “Date & Time” as the format so it’s impossible to accidentally enter text or a single number. This is also a good time to set the format for each field. A form automatically created from an existing sheet/table Defining field format Don’t like the existing labels on the form? It’s possible to change them by selecting the labels and typing in the preferred label text. In our case, we take the second option, which is to create a form from an existing sheet and table: Selecting sheet 1, table 1 to create a new formĬlick “Table 1” under Sheet 1, and a Form Setup window is displayed (see image below). You’re now asked to create a new sheet and a new form that is linked, which is what you’d do if you hadn’t already created a spreadsheet. Select New Form from the popup to create a form. A popup appears with two choices - New Sheet or New Form. To create a new form, click the plus sign button ( + ) just under the Spreadsheets button (see image below). Adding a simple calculation to determine miles driven can be done later: Spreadsheet to capture date/time, mileage, and business/personal category For example, here’s a spreadsheet to capture date and time, starting and ending mileage, and business/personal use. If you already have a spreadsheet table in Numbers, it’s simple to create a form from the row headers. Each record (row) includes date/time stamp, starting mileage, ending mileage, total miles driven, and if the drive was for business or personal use. This is useful for small business tax records. Creating a formįor this article, we’ll create a logbook for tracking mileage. Want to know what’s new in Numbers for iOS and iPadOS? Check out this Apple article. Have a group of people collecting survey information with iPads or iPhones? Forms work with shared spreadsheets so the entered data is accumulated in a shared table. Numbers convert the handwriting to text, then add the data to the linked table. Examples of these tables include inventories, class rosters and attendance tables, surveys, and address lists.įorms using Apple’s Scribble capability allow data entry into forms directly from an Apple Pencil. ![]() This is useful for adding data to simple tables that use similar information. Once you’ve created a Numbers form, entering data into it automatically adds the data to a spreadsheet table linked to the form. In this post, I’ll show you how to use a feature in Numbers for iOS and iPadOS to make and use forms for data entry. Rather than tapping that information into a tiny cell in a spreadsheet, create a form in the Numbers app for smoother data entry. The iPhone, iPad, and iPod touch are all perfect devices for gathering information anywhere. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |