Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date format in a Google Docs automation

Topic Labels: Automations
Solved
Jump to Solution
2627 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
ScottWorld
18 - Pluto
18 - Pluto

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