
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 21, 2022 07:45 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 21, 2022 08:11 AM
@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:
Anyway, thanks for your suggestion.
Andrey

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 21, 2022 07:54 AM
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 21, 2022 08:11 AM
@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:
Anyway, thanks for your suggestion.
Andrey
