Help

Date format in a Google Docs automation

Topic Labels: Automations
Solved
Jump to Solution
2469 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrey_Kovalev
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi everybody!

Google Docs automation works for me, but lacks some flexibility. For example, I generate meeting notes digest and would like to add a Date when document was generated in a Title of the document. There is a token TIME which allows inserting complete time, but I have no idea how to format it or truncate unneeded time part. Any ideas how to workaround this?

Regards,
Andrey

1 Solution

Accepted Solutions
Andrey_Kovalev
8 - Airtable Astronomer
8 - Airtable Astronomer

@ScottWorld , it seems I have found a solution. Before creating a document I added another step Find Records which searches through Metting records and finds today’s record, then I take a formatted Date from that record. So currently my automation consists of two searches:
auto
Anyway, thanks for your suggestion.

Andrey

See Solution in Thread

2 Replies 2

This should work if you create a formula field in your Airtable table using the DATETIME_FORMAT function, and then insert that formula field into your document.

You can learn more about DATETIME_FORMAT here:

Andrey_Kovalev
8 - Airtable Astronomer
8 - Airtable Astronomer

@ScottWorld , it seems I have found a solution. Before creating a document I added another step Find Records which searches through Metting records and finds today’s record, then I take a formatted Date from that record. So currently my automation consists of two searches:
auto
Anyway, thanks for your suggestion.

Andrey