Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Auto filling a linked record from a date field

Solved
Jump to Solution
185 5
cancel
Showing results for 
Search instead for 
Did you mean: 
oakley
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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: 

Screenshot 2025-02-11 at 6.49.02 PM.png

Screenshot 2025-02-11 at 6.48.57 PM.png

See Solution in Thread

5 Replies 5
oakley
6 - Interface Innovator
6 - Interface Innovator

@ScottWorld and @TheTimeSavingCo  would you be able to help on this?

TheTimeSavingCo
18 - Pluto
18 - Pluto

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: 

Screenshot 2025-02-11 at 6.49.02 PM.png

Screenshot 2025-02-11 at 6.48.57 PM.png

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?

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!

 
 

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!