JonathanB - profile

JonathanB · Jan 08, 2023

Hi everyoneAs a little weekend project I made a simple tweet scheduler with Airtable. It allows to post tweets once daily at a time you specify. You can set the number of times you want each tweet to post, or allow to repeat indefinitely. Turn on/off...

JonathanB · Jan 06, 2023

Hi everyoneHere's a simple base with an interface that can be used for employees/visitors to clock in and out of a location:https://amazingairtable.gumroad.com/l/lvcyc The interface could be on display on tablet from which people select their name an...

JonathanB · Jan 04, 2023

Hi allHere's a little workaround I came up with to easily track how many times a checkbox has been ticked using just an automation and a formula: https://youtu.be/3C36OoWb3MQ It always annoyed me the "last modified" field will update whenever a field...

JonathanB · Jul 24, 2022

Hello everyone I love Airtable! I’ve been working with it for over five years both professionally and personally and over that time I’ve been involved with setting up plenty of complex bases for all kinds of purposes. My particular areas of interes...

JonathanB · Mar 23, 2022

Hi everyone I’ve posted previously about making a simple “to do” list that generates a new task with the same name, due a week later, whenever you tick the task complete. Here’s a slightly more sophisticated version of the same idea, where you can sp...

JonathanB · Jan 07, 2023

You're welcome 

JonathanB · Jan 06, 2023

Hi, I've been experimenting with something like this. It's a simple interface that just allows users to select their name and click a button when they arrive/leave a location. The base then calculates how long they've spent on site. All you need t...

JonathanB · Jan 06, 2023

This is possible, but it involves having a new table for each year. It will still create all the records in the same table, however, using an automation.Set up as follows:You need a table for your records, and a table for each year (or period of tim...

JonathanB · Jan 06, 2023

You will need one field for the enrollment date, and another for the date of first submission. Then use DATETIME_DIFF(... "days") to calculate the difference in days between these two dates. Wrap this inside an IF() formula, so that you get an outp...

JonathanB · Jan 06, 2023

I doubt it's something that's a priority for them at the moment, based on recent developments. But you never know...It is possible embed an Airtable view in Notion pages though, see here: https://youtu.be/gZHVg63UiNo

User Statistics

User Activity

Schedule daily tweets with Airtable

A simple clocking in and out interface

Counting how many times a box has been checked (no scripting required!)

I can help you set up your bases

How to Make a Recurring Task List with Variable Due Dates

Re: Interface reporting that shows percentage of students who completed within a set day frame?

Re: Possible to make a clock in and clock out?

Re: Autonumber that Repeats Every Year

Re: Interface reporting that shows percentage of students who completed within a set day frame?

Re: Note-taking / document Notion elements