Hi everyone ! When I click on 'Group by Date" it keeps grouping it in different groups because of the hours difference. Is there a way to make it as it only group the entries per date but without taking the hour in account ?Thanks !
Context: I'm working on an Animated TV Show and have made a Base for tracking the Production. The main function so far has been tracking all of the various Meetings/Milestones/Working Periods that happen within a certain Department. I also have a ...
I have a View of records with populated date fields. Is there a way to change all the times so that all the times are 5:00pm while keeping the same date? I only want to do this to a view of records in the table, not the entire table.June 4, 2023 12...
Hi! I’m looking for a way to limit the Date field in my form so that the person filling out the form is not able to select the current date, only dates in the future. Is this possible?
I’d like to update the Status column of a record when a specific time listed in that record is passed. This is to create a social media publishing calendar. I add a post time to a record. When it is that time, the records status column is updated to ...
Hello,I am having a table in Airtable that contains a text field with dates. I imported a CSV files. And all dates were added as text field in a wrong format (MM/DD/YY). So I am basically looking for a way to: Convert these text date field to a real ...
I have a grid view in my base shared with a specific group of people, it includes all records with a date/time within five days in the future AND all records in the past.For easy viewing and sorting, is it possible to group the records into two group...
Hello :wave: I used this article to create a booking system. I haven’t changed anything apart from adding my availability. In the Time field, I DIDN’T enable the “same timezone” option so people can see their local time. So, for my test, I have mad...
Alright, so, I'm asking for help because really i've just tried to do the 100th formula and it just doesn't work, so i'm taking my chances by asking for help. See, what i'm looking for is this:I need to have a calendar view to control a car workshop....
- I have a report that I am trying to create that will take all my dates request and I can sort by month. Below is my table and I am needing to run a report for the month of march. So what I want is for the provider name to show all the data that hap...
When I copy and paste a date and time value between 1/04/2023 16:00:00 and 2/04/2023 01:00:00 from Excel to the Airtable, it automatically moves it by one hour (i.e. 1/04/2023 16:00:00 becomes 1/04/2023 17:00:00). The values are being pasted correctl...
Hello Is it really not possible to have the weekday shown in a date field? Seems an odd omission - and the ‘friendly’ date format not that friendly. I know I can use a formula field to format it how I like but a) that’s a workaround and b) I am grou...
Hi! I want to calculate time that falls within a specific intervall. I want 1 column for weekend hours, 1 for evening hours and 1 for night hours. The rules would be as stated beneath. How would I do this? My time columns are "start" and "**bleep**"....
Is there a way to set the time zone for all tables in a base? I just noticed that my “where Ordered is today” filtered out all orders and it’s only 6:31pm – the day is not over yet. :neutral_face:
Hi everyone!I am trying to find the right approach to calculate the number of consecutive unattended days at course by a same student.I currently have a "participation" table. It is a junction table with: The date (date field) - The Student (link rec...
I am using the Gantt view. I have 50 tasks. Every 10 tasks has a milestone. And each set of tasks is marked as dependencies for each milestone they come under. I would like the milestone dates to be updated automatically when the end dates for one o...
Hi there! I've been searching across the Airtable (AT) community for answers, and none so far.I am trying to create a production schedule that has multiple dependencies across time. I followed the template that AT provided. I also included a new form...
Not sure where the correct place to put this one is. I am trying to get a formula or automation to update the period field in the attached screenshot based on the cadence. I have tried using automations, but it essentially circular references itself ...
Hi! Im having trouble wrapping my head aroubd this but I am trying to duplicate records and assign then a random date inside the current month and then make them not to duplicate on the same date. So duplicate 1 = month/day 5 Duplicate 2 = month/day ...
Context: I have a series of trainings that is being accessed by those in multiple time zones. Previously, I have marked everything in GMT, yet it continues to confuse respondents who are only thinking in their current time. Therefore, I’m trying to...
