The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
I recently moved my work history notes into Airtable, and wanted a way to see at a glance how long I worked at each company, including time spans for those companies I’m still working with (I used to work full-time, but starting in 2012 my work became a mix of part-time and freelance/contract jobs). The end product is a clean listing of years and months1, as this sample illustrates: The full table includes three hidden formula fields: {End Date} defaults to TODAY() if no specific date is entered in the {To} field; otherwise it uses the {To} date. {Years} and {Months} run calculations based on {End Date}. The {Length} field puts it all together. It’s not a particularly complex setup, but it has more potential use than just job tracking, so I thought I’d share in case anyone else could use it. Copy it to your own workspace to seen the formulas. Airtable Time Span Sample - Airtable Brief example of how to measure time spans in years and months, including situations wh
4 Teir Gantt, Single Dependency I really want to mate the Gnatt (beta) block work. I’ve spent some time trying to work around the circular references, and in-ability to look past a the first record link. I got the start date for a task to adjust up to the 4th task in a dependency chain, hooray. The timeline block reflects the correct start date, unfortunately, the Gantt block sets any task that is dependent on a dependent task to the 1st of the year. I’m hope new column field types or other Gnatt friendly updates are made in the near future.
This is a card based calendar, powered by an Airtable. It includes helpful details such as countdowns, Google Calendar links, auto-magical sorting. See the GitHub repo and demo at https://github.com/Arty2/aircalendar This script and its related Airtable base may change breaking compatibility. Designed with multilingual websites (i18n) in mind. Underlying code is quickly hacked together, but fully functional and should work even with missing fields. PS. Dear forum admins: “can’t put images in a post” is not that useful when not knowing what one has to do before using images. :grinning_face_with_smiling_eyes:
I was looking for a meeting collaboration tool for a “pains, gains and goals” brainstorming exercise. I looked at a number of tools and all of them were quite a bit more complex than I wanted. Luckily for me, I have a subscription to Table2Site and @poehah was available to answer my questions on Saturday! Feel free to check out both the site (this is a demo page, so feel free to enter results): https://table2site.com/site/brainstorming Here is the related base: Airtable Brainstorming Tool - Airtable Explore the "Brainstorming Tool" base on Airtable. A couple of tricks that I discovered: To embed an Airtable form using the iframe option in Table2Site, you will need the embed URL, not the URL of the form. Example: https://airtable.com/embed/shrq6brDpXNi2RDKF not https://airtable.com/shrq6brDpXNi2RDKF. While the “Lookup” and “Formula” field types break when using the Table2Site data format, you can change the type of field to “Rollup” a
Hey guys, I’m using Airtable as a kind of database for a ReactJs project. I’m pretty new to React and javascript in general and so this might be trivial for a seasoned developer. But I wanted to share one approach you can take to integrating Airtable into your React App. Here’s the tutorial: http://www.automationfuel.com/airtable-reactjs/ And here’s the github repo: https://github.com/focuswish/airtable-react I hope someone finds it useful :slightly_smiling_face:
Having had quite a few questions about an earlier blog post I wrote about creating checklists in Airtable using Zapier, I decided to write a new version using Integromat instead (which makes it much simpler, requiring no code): Database Resources Creating Checklists with Airtable and Integromat | Learn more about Cloud... Ideas and reviews of Cloud Database platforms I hope people find this useful!!
Wanted to share a great experience I’m having with ReportBin. Use case: we work with athletes and provide them with career coaching to help them figure out what their post-competition life will look like. within a broader curriculum, we have individual homework assignments which are collected either through Airtable forms (when simple) or one-off custom forms built from scratch. after the athlete completes an assignment, it then needs to be reviewed by their career coach and the athlete which is where ReportBin has been a total life saver. after setting up the template for each assignment, we were able to use zapier to build a workflow where as soon as an athlete submits something, we generate a ReportBin report and the link gets written back into our Airtable. the report looks like this. i started working with Sam at ReportBin a few months ago and the pace of their development has been awesome. as a non-developer, this was a great solution for me and was way easier than trying to f
Hey all, excited to tell you about BuiltOnAir, a project that’s been in the making for a little while now, and now going live. I think it’s awesome, but would love to hear your thoughts also :thinking: What is it? BuiltOnAir is a hub for Airtable happenings. We made it to become a place to bring together, highlight, and empower the people building things with Airtable - so if you’re here reading this, this is for you. BuiltOnAir is (currently) comprised of these main elements: A podcast: A weekly production highlighting an expert, professional, or enthusiast using Airtable in their work. We hear their story with Airtable, then we get a peek into their work with a “show and tell” of a base they’ve created (usually with a whole slew of nifty hacks and tips). Super inspirational, both from a technical Airtable usage standpoint and from hearing about the causes people are working on. Weekly community recaps: A hand-curated list of the most relevant and recent updates from multiple Airt
Hey all, I’m really excited to share something that has been a long time in the making and one I think will help a lot of people. I’m curious: how many of you use Zapier for your Airtable integrations? I wanted to get a general poll for a sense of how people are using automation with Airtable: POLL: Do you use Zapier for your Airtable integrations? I have no need for Zapier Nope, I use another platform No, but I might in the near future Yes, and it does absolutely everything I want it to Yes, but I need it to do more (it lacks key functionality) 0 voters Excited to tell you about a project I’ve been working on and finally ready to launch! I’d welcome your feedback and insights on this. It truly is a game changer for what you can do with Airtable and opens the door for endless possibilities. Disclaimer: We are not associated with Airtable or Zapier (although we are an Expert Partner of Zapier). Using this product requires entering your API key into Zapier and our connector w
At BaseGenius we’ve now helped a few clients keep data in sync between Airtable and Salesforce. So we decided to productize our code and are launching it as a separate product from our regular consulting work. Check it out here and send us a note if you’d like to use it for your business. Daniel from BaseGenius
I’ve used Airtable to run a couple RPG games and it’s really great. Being able to have a view for my players to look at where I can post images of NPCs or notes is terrific. Here’s how I created the base (this is a Forbidden lands game). And here’s what players can see. It’s challenging to create hidden views that actually show the information I want to share. Hopefully someday there is another step for linked records that allow for a cleaner format.
Hi, Users are overwhelmed by passwords, and companies like slack have implemented passwordless login which I personally think is great. If you want to do the same for your app, check out my latest article on how the basics of rolling your own: https://chinarajames.com/passwordless-login-magic-links/ This use case came up for me because I wanted persons to update their own airtable record and it’s not practical to have over 300 persons as collaborators on a base, so built an app for them to login and edit their records. This is basics of how I did the login part. Hope someone finds it useful.
Thought it would be a great time to post another update on Destiny Search Project and our use of Airtable. For those that do not know we posted this original post when we first started using Airtable in 2016. Well, we have continued working on updating the system continually. We are now in Alpha Testing of our newest version (4.5 now!) With the addition of some of the beta features, and now including Blocks, we have really made some big changes. The biggest change is that we have now used embedded forms on our website to create a very easy to use interface for volunteers. We went with forms as when we have active searches we have many “staff” that come and go with very few permanent team members. We didn’t want to have to manage adding, removing, and training volunteers daily (sometimes hourly) so used forms to develop an easy to learn the system. In the future, we hope to learn more about using the API to create a fully integrated operations system directly through the website. If an
While answering a question on the forum about Checklists, I decided I would write a blog post about how to use Zapier to automatically create Checklists, assign them to a project and then to a collaborator… Creating Checklists with Airtable and Zapier and here’s a link to the base: I hope you find this useful!!
I’ve created a UK version of my base to calculate holidays as input to WORKDAY() or WORKDAY_DIFF(). (For detailed information, see the post referenced above.) The base takes as input the years for which you wish to calculate holidays and the applicable area (England, Wales, Scotland, Northern Ireland, or the Republic of Ireland). The output is a field called Holiday String containing a ISO-formatted list of governmental holidays for the specified locality, ready to be copy-and-pasted as an attribute to either workday function. (Specifying holidays enables the functions to take both weekend days and holidays into account in their calculations.) This base requires a much more complicated algorithm than the earlier one, given either Good Friday or Easter Monday is an official holiday in the U.K. To calculate either date, one must first arrive at a date for Easter itself — a computation that has remained challenging for hundreds of years. Having absolutely no idea how the calculation works
A silly little base that does one thing: It generates a string of ISO-formatted holiday dates as an input to WORKDAY() and WORKDAY_DIFF(). As published, it supports current U.S. federal holidays, with options to deselect three federal holidays (Martin Luther King’s Birthday, Columbus Day, and Veterans Day) some companies do not take off, as well as two non-holidays (Friday before Labor Day and Friday after Thanksgiving) many companies do. For holidays that fall on a specific day of the month (e.g., New Year’s Day, Veterans Day, Christmas), if that date should fall on a weekend, the base returns either the previous Friday or following Monday as appropriate. It’s been lightly QAed — by which I mean I know it works for 2018 through 2021. The base will return a string of ISO-formatted dates for periods from one to fifty years. (Caveat: There’s a good chance Airtable won’t accept fifty years’ worth of holidays at once, but I’ve not yet been interested enough to find out when it chokes.) Dat
I recently worked on a project that required loan calculations. This was easy in excel or google sheets but Airtable is missing these common financial functions. So, I brushed up on my math skills and with some help from the internet was able to reproduce those functions in Airtable. Thought I’d share with community: Airtable Financial/Loan Formulas: PMT, FV, PPMT, IPMV - Airtable Universe Excel and Google Sheets users will be accustomed to common financial functions used in loan calculations that are currently not available on Airtable. This... Formulas currently implemented: PMT, FV, PPMT, IPMV
Chinara James – 5 Nov 18 How to paginate records in Airtable when using the API | Chinara James Airtable’s API is great and so is their documentation. However, I came across a small stumbling block while using it to build a simple project. The problem, Airtable returns a maximum of 100 records…
Chinara James – 19 Nov 18 Getting Started with the Airtable API | Chinara James Airtable is an easy way to get a database up and running for a side project or to quickly prototype an idea for app. I have used it to manage track projects, expenses, client contacts and more.
Is there any trick to get the menu “Hide fields, Filter, Sort” in other languages like French ? Could we add something to the iframe code to replace these specific words? Unfortunately, there are submenus or criteria fields in English as well. The best solution would be a parameter that would make the app displaying these words in a chosen language… Benoît
Possibly of interest to some, the following is an implementation of Soundex pseudo-homophone encoding. As there are variations of the algorithm, care should be taken if using its output to search externally encoded databases. (I think this conforms to U.S. Census encoding, but I’ve found contradicting statements.) To use, copy and paste the following into the formula configuration window of a formula field. It expects to use an existing field in the table named {Word} as input, so adjust field names accordingly. (There are two instances of the field name {Word} in the formula.) Yes, it’s far from a perfect algorithm; yes, it’s rooted somewhat intractably in American English; yes, there are alternative encodings that may be more appropriate for many uses: Feel free to modify, enhance, and improve as you see fit — preferably releasing your improvements to the community afterwards. LEFT( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUT
This may be obvious to many, but it eluded me until today… It is a HELL OF A LOT easier to code (and debug) formulas in Textedit (or the text editor of your choice), inserting returns between segments (B). When you paste your code into Airtable, it’ll smartly remove those returns and create the code block we’re used to seeing (A). A IF({Auto-Status} = “Awaiting Review”, “ :mag: ”,IF({Auto-Status} = “Complete”, “ :checkered_flag: ”,IF({Auto-Status} = “Design”, “ :art: ”,IF({Auto-Status} = “Released to Supplier”, “ :rocket: ”,IF({Auto-Status} = “On Our Radar”, “ :satellite: ”,IF({Auto-Status} = “Production”, “ :triangular_ruler: ”,IF({Auto-Status} = “Cancelled”, “ :skull: ”,IF({Auto-Status} = “On Hold”, “ :zzz: ”,IF({Auto-Status} = “Design Queue”, “ :art: :soon: ”,IF({Auto-Status} = “Content Needed”, “ :question: ”,IF({Auto-Status} = “Unassigned”, “ :busts_in_silhouette: ”,IF({Auto-Status} = “Design Route”, “ :art: :arrows_clockwise: ”,IF({Auto-Status} = “Copy”, “ :pencil2: ️”,IF({Aut
I could not figure out why when doing an alphabetical sort, some records were coming in “at the bottom.” For example I’d have A to Z for records 1 to 100 followed by a second A to Z of records 101 to 200. I could see no extra spaces, or anything to indicate why this was happening. At long last I discovered that occasionally CSV imports (mine were exported from Zoho) have a glitch where hidden tabs can tag along. The fix is a wee bit tedious, as you can’t just do a global replace (I did try that!), but it sure beats the alternative of retyping things (which was what I did for a while before getting determined enough to find the answer). Steps: Open exported CSV file in your spreadsheet program. For each column, insert a blank column next to it on the right. In that column, add the formula =CLEAN(A1) [or whatever cell is your first entry]. Use the copy / drag function (copy, format down) to fill the entire second column. That column now has clean data with no extemporaneous tabs. It
So, I have been trying to find a way to make weekly recurring tasks, and have figured something that works for me. Basically, just a complicated formula that updates the due date field each week to the same day of the week and time of day. Make a table that will act as a template for new tasks. This Post got me started. Make a date field, with the time, that will set the time you want to be your due date each week. Use this formula below, to make a separate field that will update to that day and time, each week, automatically. (You will need to edit the time zone to match where you are.) DATETIME_FORMAT(SET_TIMEZONE(DATETIME_PARSE(CONCATENATE(DATETIME_FORMAT(NOW(),‘ww’)," “, DATETIME_FORMAT({due time of week}, ‘ddd’),” ", DATETIME_FORMAT({due time of week}, ‘LT’)),‘ww,ddd,LT’),‘Asia/Bangkok’),‘D/M/YYYY h:mma’) Then have Zapier trigger each week, and use that new date field as the date when creating the new records. Optionally, you could have the zap find and reset the due date of
Without using Zapier or another app, would love to see empty, example bases of how to handle subtasks with Airtable. Thanks in advance.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.