Hello. I am trying to sync Airtable with Google Calendar. In the form of “Add” the URL of Airtable’s “Calendar view” to Google Calendar. However, there was one minor problem. Airtable’s “Date” field now selects Date format and Time format, no more op...
Hi Team, Soooo, because Airtable doesn’t have a stand alone time field (it really needs one) I need to create a ridiculous bodge… I start with a Date field set to local format lets call it {CommDate} Next I have a bulk standard number field set to in...
Hi, everyone. I’m wondering if there’s a way for me to adjust the date and time in the following format: [MM/DD/YYYY XX:XXpm] for Slack and Email. I can’t seem to do that in the automation box. Would I need to insert a formula or some other solutio...
Hi, In my table I have a field where I want the expiration date of a contract be automátically calculated based on another date field (when the contract was signed) + 36 months duration period. The formula is as follows: DATEADD({signed}, 36, “months...
Good morning, I’m trying to create a gantt chart in which I can represent a proyect with different beginnings and ends. But instead of appearing below, continues in another start date on the same line, as it shows in the following picture: The pr...
Hey everyone, Sorry if this has been asked before, I couldn’t find anything. I am still a beginner. My Problem is the following: IF({Laufzeit (Monate)}= BLANK(),"", DATEADD(Vertragsbeginn,{Laufzeit (Monate)},“Month”)) It works, but the result it is n...
Hi folks, I’m an Airtable rookie trying to do something fairly complex… thanks in advance for the help! My main table has a list of projects (films) with several additional fields, the most relevant being Completion Date, Revenue, Team Hours Dedicate...
How do I filter a view where the date record created is greater than a specifc date? ie ony show records more recent than July 1st 2021 I assume it is simple but I can’t work it out.
I track contract dates in Airtable. I need to use this field as a reference in an email automation. However, in order to have the date show up correctly in the automation, I have to use the Set_Timezone formula –here’s my formula --DATETIME_FORMAT( S...
I am having trouble sorting a list of records in chronological order by date using a field that I have formatted with a formula that calculates the day of the week, month, day of month. The sort is defaulting to alphabetical. The formula I’m using i...
