I have to say that I am very impressed with the AirTable iOS App. I don't have front end software for a database (as in AirTable), and my current software doesn't translate to well to my iPad You're welcome to steal (err, ah, I mean use) my Medical Records database design. I'm about done with my AirTable Medical Records, with only a few hours of work (and most of that was spent building a comprehensive disease list from CDC. But for something like the Medical Records database, Excel just can't compare. Excel can't really provide that type of UI easily, and then not very well (I've tried many times in the past).įor a single table, or a quick and dirty, small data set, you can make do with Excel. The AirTable UI is fantastic, making it very powerful and easy to create and enter related data, even on the fly. But Excel is NOT a relational database, like AirTable. I'm a huge Excel fan and user, having used it for decades and written some very complex, sophisticated Excel solutions with multiple sheets and workbooks. In fact, I have often used an Excel file attached to an EN Note to better track data. Instead of the Airtable app, I'm proposing to have a Spreadsheet Gaz, may I suggest that you add "Airtable" to the topic title, so that this topic is easier to find by search. I'm building a base/app for Medical Records (which they did NOT have a template for). But then you'd be able to afford the Airtable Plus rate of $12/month/user. However, If you are running a business, then you might need more, much more. For personal use, I think 1200 records/base will be more than sufficient. It's similar to a spreadsheet workbook, and can contain multiple tables". You are limited to 1,200 records / base, but you can have unlimited bases, where a base is "like an app of your own creation. At first I was put off by the limitations of the free version, but as I now understand it, it is really not that limiting. I really like being able to create my own tables, with powerful field types. A brief look/testing of Airtable indicates to me that it is fantastic! If only Evernote did that sort of thing I wouldn't need to use third-party software. PS Evernote - the relational database thing is what they call 'transcopy' in Wikis, where you show some or all the content of one note as part of another. (Just to confirm - I have no connection with them!) It's an app worth Evernoting, even if you don't need it now. Obviously do your own due diligence before you invest hours setting up your own system, and (just for information) I get all my data together in Evernote before I set it up in Airtable and they support Zapier, so I should be able to arrange to copy details across rather than enter it twice. I can use the KanBan view to keep me on track with support material for each event. I can share the Calendar view with my customers so they know what's coming up in their area, and if they sign up with one or other venue I can use their sign-up form (created in Airtable) to look-up or populate their customer record for my information later. Too much information for detail, but Transpose Airtable* would mean (forinstance) that if I was arranging meetings throughout the year on different subjects at different venues, I could have one database of venues, one database of subjects, and one database of details and dates, linking to the relevant subjects and venues so I don't have to keep entering the same information over and over for each event. In fact it's quite a little powerhouse of collaboration and connectability which I'm initially using for one project as a trial. It's also a relational database - you can link new facts to stuff you already know - and a calendar (if you have dates in there somewhere) and a KanBan chart of items sorted by various options. Which is a spreadsheet to which you can add data. It's now closed down, but I found a new contender. I liked Transpose, because it was, until very recently, a database to which you could add structured information, and process and display it online in various ways. In fact let's just start off with me being really, really, really sorry and move on. If someone else suggested it here, I'm sorry that I'm now taking credit for finding it. If I didn't post it before I also apologise. Pretty excited about this one! Happy to help further if you want.If I posted about this already, I apologise. It’s not super pretty yet but the table is there! And it will adjust automatically depending on how many units were sold. Next, I set up the email template in Zapier: On, I added a field called and creates an array, separated by table row tags with this formula: "" & ARRAYJOIN(values, "") & "" Each record represents one week of units sold and is linked to those units on the table. Thanks Mack! I think I have figured this out after much trial and error - and it’s actually somewhat simple!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |