If it can be done at all in Airtable, it’s usually pretty easy.Ī library database with three linked tables (Authors, Titles and Subjects). And you can undo almost every action, so relax. There’s a lot of help available and live support is terrific. For example, I built a to-do base and made different views that show me only uncompleted tasks, or tasks to be done today, etc. You can’t easily program or script Airtable but you can create different views that filter (find) and display data in different ways. You’ll also need to give some thought to how you want to view your data. Will a column be used for short bits of text like names or addresses or long text like memos? Will a column be used for date values, numbers, currency? If the data you’ll put into an Airtable base calls for two or more related tables, you’ll want to think carefully about how to link them. Unlike spreadsheets, databases require rigid data structures, so you will have to think a little about how to organize your Airtable base. Home run: Data basicsĪirtable may look like a spreadsheet but it isn’t. In this view, the user can see that Table 3 (which seats 8) has too many people assigned. For example, if you were organizing a fundraising banquet, you could create an RSVP form for your Airtable Invitees base, publicize the url of the form, and let invitees enter their own info (name, phone, attending or not attending, number of guests, etc.).Īirtable’s various calculation columns can do a lot. You can even give access to people who don’t have an Airtable account. (“Hey babe take another look at the price.”) If you wanted to share with your teenager without giving the teenager the ability to edit the base, you’d adjust the access privileges for that share. (“Are you kidding me? This place looks like a dump!”) This data gets synced in both directions instantly. This screen is used to customize column data types, add columns, etc.Īnd once you’ve shared your househunting base, your spouse will now be able to take a break from packing boxes, access the base, review what you’ve seen, look at the photos, and write encouraging notes to you in the Notes field. The Airtable app for iPhone isn’t just for entering and viewing data on the go, it’s powerful enough to create and edit base structures. You could actually create the base from scratch on your phone, but that would be showing off. Need another column/field, say, Square Feet? Click Customize again, and add a field. Notice what is going on: You’re not only entering data (including photos) on the iPhone, you’re editing the structure of the database. Clicking on the camera button lets you take a picture and store it directly inside the base. View of a single property record in a house-hunting database. Next time you create a new record, when you click into the Neighborhood field, the value picker will appear and you’ll type in a value only if it’s not already there for the picking. So in the record view, click on Customize Fields, then click on Neighborhood and change its field type to Single Select. Now if you visit many properties in the same area, you’ll probably get tired of typing the same neighborhood description again and again (“Vista del Lago Lindo Estates”). There’s even a barcode column type so you can scan barcodes. If configured properly, addresses can be opened in Maps phone number values can be tapped to make calls. Click on the Attachments column, then on the camera icon, and you can take one or more photos of the property and they will automatically be stored in the base. Now, when you are out visiting properties, you’ll launch the Airtable app on your phone, open the househunting base you created earlier, click on an empty row, and enter each property’s address, price, etc. My simple househunting base viewed in a browser on a computer. An app for Android is in beta now and will be released later this winter.) Before you hit the streets, download theĪirtable app to your iPhone and use the app to sign into your new account.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |