Hey Jessica, you could make the primary column a formula field and make the date the format you need
Form:

Setup:

I’ve set up a base here for you to check out, and here’s the form
That is what I originally wanted to do, but here is the hangup I ran into (if there is a way around it, please let me know!):
The table that pulls in the shifts is integrated with a Google Calendar and, while under the advanced options you can choose a different calendar field as the Primary field, it doesn’t seem to allow for creating a non-Google Calendar populated Primary field… originally, I did want for my Primary field to be a formula that showed both the start and end date/time (so that this is what a person filling out a form sees), but I couldn’t figure that out so I just ended up selecting the G-cal’s start date as the Primary.
That is what I originally wanted to do, but here is the hangup I ran into (if there is a way around it, please let me know!):
The table that pulls in the shifts is integrated with a Google Calendar and, while under the advanced options you can choose a different calendar field as the Primary field, it doesn’t seem to allow for creating a non-Google Calendar populated Primary field… originally, I did want for my Primary field to be a formula that showed both the start and end date/time (so that this is what a person filling out a form sees), but I couldn’t figure that out so I just ended up selecting the G-cal’s start date as the Primary.
Ah, I see, sorry about that.
Hmm, so this is via automations, with When event created
? I can’t seem to find a setup area where there are advanced options and such, and think I’m missing something, apologies.
If this isn’t via automations, may I know how the table is integrating with the Google Calendar?
Sorry for the questions; I want to try to emulate the exact environment you’re using to try to create a solution
If it’s possible to invite me to a test base that would be excellent too
Ah, I see, sorry about that.
Hmm, so this is via automations, with When event created
? I can’t seem to find a setup area where there are advanced options and such, and think I’m missing something, apologies.
If this isn’t via automations, may I know how the table is integrating with the Google Calendar?
Sorry for the questions; I want to try to emulate the exact environment you’re using to try to create a solution
If it’s possible to invite me to a test base that would be excellent too
When you create a new table, Google Calendar is an option you can select

When you create a new table, Google Calendar is an option you can select

Ahh, I see, thanks! That’s pretty nifty.
Hmm, if I were you I think I’d end up doing the following:
- Make another table (let’s call it
Table 2
)
- Create a link field between the Google Calendar synced table and
Table 2
- Create an automation that, on creation of a new record in the Google Calendar synced table, will create a new record in
Table 2
that’s linked to the record in the Google Calendar synced table
- Create lookup fields in
Table 2
to grab the data I need to display
- In
Table 2
, make the primary field a formula field as you mentioned above, using the date value from the lookup field
- Make the form in
Table 2
Really not the most elegant solution, and also a bit annoying to have two bases with the exact same data, but the alternative would be making automations that mimic the functionality of the Google Calendar sync which seems like much more work
Jess I actually don’t think it’s supposed to display like this. I’ve just come to these forums to see if anyone else is having this issue. I’ve been using forms with dates for ages, and they’ve been displaying them the same way as they are displayed in the view that you’re using to link to that form.
I actually think there’s an issue with Airtable…
Jess I actually don’t think it’s supposed to display like this. I’ve just come to these forums to see if anyone else is having this issue. I’ve been using forms with dates for ages, and they’ve been displaying them the same way as they are displayed in the view that you’re using to link to that form.
I actually think there’s an issue with Airtable…
Yes, it is displaying totally normally now. It looks like you were right and it was just a weird display issue.