DisraeliGears01 - profile

DisraeliGears01 · Jan 06, 2025

I've tried to work my way around this problem several ways and I can't seem to figure it out... I have a nested IF statement that uses a value from a text lookup field that just doesn't want to play nice. Essentially, I have a formula title for a rec...

DisraeliGears01 · Dec 03, 2024

Hey y'all, dunno if anyone has experience with this or if it's even possible, but is there a way to turn off user caching (or enforce today centric) for an embedded calendar view?I have a publicly shared calendar interface embedded in a webpage, but ...

User Reminders as Comment Function · Nov 25, 2024

What is the proposed idea/solution?I propose adding a reminder functionality into commenting that integrates with Airtable's Notifications function. Exact implementation could vary, but the ability to tag a user (or yourself) and select a length of t...

DisraeliGears01 · Sep 06, 2024

Hi all!This has come up in a couple recent threads (and I was PMed on the topic) and I thought writing a summary collating all the information on this topic might be useful for future users.You (yes, you!) can automatically format Airtable data into ...

DisraeliGears01 · Aug 08, 2024

Wonder if anyone has something that works for this... I'm creating discrete events in a base, and I want to automate the process of turning the data points into a .ics file and attaching it to the record in an attachment field. It's a bit like this w...

DisraeliGears01 · Jan 15, 2025

Usually copy/pasting dates works fine for me, but my expectation when there's a 1 day difference error is always a timezone issue. Does your Google Sheet data include any time information, even generic time info like everything is just set to 12:00AM...

DisraeliGears01 · Jan 14, 2025

If the time display is really bothersome, I think you could add a formula field running DATETIME_FORMAT( {Due}, 'LL') and hide the original due field, which will strip away the time element and just display month/day/year. Timezone handling is one of...

DisraeliGears01 · Jan 14, 2025

This is absolutely a timezone issue, Airtable loves to convert everything to UTC/GMT. Have you tried turning on all the time fields, setting your timezone to the appropriate one, and then just ensuring your automation/formula fields format away the t...

DisraeliGears01 · Jan 09, 2025

If you want a kind of complex solution for the weekend element at least, you can use a formula to datetime format a date into it's days of the week (Monday, Tuesday, etc), then either build a filter that excludes Sat/Sun or add another formula (or pr...

DisraeliGears01 · Jan 09, 2025

As dilipborad mentioned, it's automation time! That said, I don't know if you necessarily need to create a summary table, but you do need a contact table that acts as the link between your declarations and inductions. A lot of this is dependent on yo...

User Statistics

User Activity

Using Lookup text in formula field

Disable Calendar Interface Caching?

User Reminders as Comment Function

Generating and using Calendar (.ics) files from AT data

Script to create and attach .ics file?

Re: Incorrect data imported in date format

Re: Automation is adding an extra day when creating a new record

Re: Automation is adding an extra day when creating a new record

Re: Auto-generate or be able to set non-working dates and holidays by country

Re: How to integrate data coming from 2 external forms into a single table