- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 11:20 PM
I have a table with a date field, an I want to link these dates to another table, but group them by month. This is so I can create rollups for monthly financial figures. I have tried to create an automation to auto fill in another field, using the date as its source and then converting the format to mmmm yyyy, from the usual dd/mm/yy. I then linked this field to the other table, but now the automation does not update it even if it runs successfully.
Can anyone help solve this issue?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 02:49 AM
Hmm, that sounds like it should work fine. I've set it up for you here so that you can check out how I'd do it: 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 11:37 PM
@ScottWorld and @TheTimeSavingCo would you be able to help on this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 02:49 AM
Hmm, that sounds like it should work fine. I've set it up for you here so that you can check out how I'd do it: 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 02:59 AM
Ah, I was trying to get a script in the automation to change the format and update the linked record all at once, but how you've done it would work fine.
Just a couple questions, does it update the linked record ('Month Year' Field) if the source date ('Date' Field) is changed and if it is a new month that has never been there before will it make a new row in the 'Month Year' table and link it to that?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 03:56 AM
does it update the linked record ('Month Year' Field) if the source date ('Date' Field) is changed
Hmm, for that you'd need to update the automation trigger to be 'When record updated' and point it at the field instead. The way it's set up now, it's only going to trigger when the date field goes from empty to not empty
---
if it is a new month that has never been there before will it make a new row in the 'Month Year' table and link it to that?
Yeap!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 04:53 AM
Thanks!
I have now altered my automation to run when the date field is updated and it works perfectly.
Thanks very much for your help!
