Is there a way to calculate times without using a datetime field? For example, if I have a start time of 11:30am and an end time of 3:30pm, can I use a formula to calculate the difference without using a datetime field?On the surface, I can do this b...
I’m trying to make a button in my interface that will update a date field to today, but it looks like buttons can only update fields to be a specific, pre-determined date. I wish the function was there to add relative dates like today, yesterday, a w...
I have some questions about syncing a Google calendar into Airtable. When I set up the sync, it asks for a date range sync–both a start date and an end date. Does this mean that events after the end date will no longer sync? How far out can I push th...
If I am over my extensions limit, do I need to delete them from my dashboard, or can I simply disable them? I have some that I use very infrequently, but I’d like to keep them around if possible, enable them when I need them, and then disable again.
I’m trying to create a form that can look up members of our organization by scanning the barcode on their ID card. The last 6 digits (ID number) of the barcode don’t change, but the first three digits to change when someone is issued a new card. So I...
@Ron_DanielThe hesitancy is just because this doesn't need a particular date, just a time. I guess I could just pick a random date/time but I like that @kuovonne's formula keeps the time fields as just times and the date is hidden in the formula. Tha...
So that means you can’t have a calendar sync in perpetuity, but then is best practice to put in an end date that’s just way far in the future? If you synced a calendar with an event per day, you could go 27 years out in the future and still not hit t...
I was actually able to solve this using an automation and a few extra fields. The fields are a “repeat interval” number field, a “repeat unit” single select field, a “Last Run” calendar field, and a “Next Run” formula field: DATEADD({Last Run},{Repea...
Apologies for the mislabeling. I’m pulling data from an API, and they (infrequently) change how their data is formatted. For example, about a year ago they changed the names of one of their materials from “Grey” to “Grey V4.” Same material, but diffe...
