Date field - adding the weekday

[Andrew_Davies]

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 grouping by date and grouping by a formula field means I drag move records between groups / add new records directly to the group.

Airtable

DW WOW>NML>Install Schedule (Shared) - Airtable

Explore the "DW WOW>NML>Install Schedule (Shared)" view on Airtable.

Any other ideas / suggestions greatly received

[Ben_Young1]

Hey @Andrew_Davies

Could you provide a bit more context for what you want the final user experience to feel & look like?

Andrew_Davies:

grouping by a formula field means I drag move records between groups / add new records directly to the group.

I’m also particularly curious about this portion and would love some expanded context.

---

As a preemptive theoretical…
Is there something, in particular, that is keeping you from utilizing either the Calendar or the Timeline views?

[Andrew_Davies]

Hi @Ben.Young

Thanks so much for your reply - much appreciated!

I’m a project manager, so spend a lot of my life writing schedules. These are usually in Excel (sometimes Word) but I have always thought it would be good to do them in a database. The Excel / Google Sheet schedules I work in are always clunky - so I thought doing it in Airtable would be good as I can have set views for certain things (for example deliveries only) which saves clicking around with filters in a spreadsheet.

I simply created a table with a date, time, notes, supplier etc field - and grouped it by date, and sorted it by time and bang - there you go!

But the problems I have doing it with Airtable are -

• As you can see from the link - the “friendly” date is not very friendly and is not customisable. It’s important to know which day of the week I am working on so adding the weekday is quite important.
• Different issue to my post here, but it is not possible it seems to print a nice list view from Airtable (with fonts / logos etc). I know about Page Designer - but that is limited to only showing one record at a time - I need to customise a list view. Am really surprised this is not possible in Airtable (support has confirmed that to be the case). If anyone can recommend a way or alternative to AirTable I would be interested to know. (or an integration?). I can’t send a PDF like the one you can get from an Airtable view to a client.

The Calendar / Timeline views are good - but I - and most of my team - are used to seeing a schedule in a list format.

With regard to the grouping figure - I got round the issue of not having the week day by adding a formula field and re-formatting the date. But if you group by a formula field type - then you can not drag entries between groups in table view - nor add entries directly to a group. See screenshot attached.

Sorry this is a long post - but any help much appreciated!

Andrew

[ScottWorld]

Hi @Andrew_Davies,

Yeah, Page Designer has several limitations.

You may want to check out DocuMint, which I’ve used with a few clients. It was specifically designed for creating PDF files from Airtable, and you can print multiple records on a page to create a list.

You may also want to check out On2Air: Actions, which connects Airtable to Google Docs, where I believe you can also print multiple records on a page to create a list. @Hannah_Wiginton, is this correct?

[Hannah_Wiginton]

Yes, with the document generator in On2Air Actions, you can list multiple records on a single document.

Here’s an example. Click on the Table section

Google Docs Function - Template Guide

Google Docs Function - Template Guide

The Google Docs Template Guide is used to setup the Google Docs Function. The Google Docs Function allows you to automatically create documents inside Google Docs using your Airtable data. You can generate single page and multi-page documents that...

Thanks for the tag, @ScottWorld!

[Andrew_Davies]

Thanks all

Much appreciated. Giving Documint and On2Air Actions a try

Andrew

[Lesbobon]

Hi Andrew,

I have the same issue that I need to include weekday in the date field.  Have you figured out a good way to accomplish that?  If not, can you share how you can use the formula field format as a workaround solution?  I was surprise Airtable didn't give that option.  - Thanks.