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.

Auto change today() on column

Topic Labels: Automations
Solved
Jump to Solution
1969 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Marc_Justin_Rai
6 - Interface Innovator
6 - Interface Innovator

Hello, I don’t have a code and asking for an advice on How to do an action script that change the formula today() inside the column for I am doing a schedule weekly report in the data fetcher app and need to fetch the current date. Is it possible?

1 Solution

Accepted Solutions

Standard javascript would be to use .toString() to turn any non-string into a string. Again, the script won’t be able to change the value of the formula field on the actual record unless you’re trying to insert it into a different, non-formula field.

Still not sure what you mean here. Do you just need the CREATED_TIME() formula? When you say “auto update” what type of field are you changing, what was the value originally, and what are you changing it to?

See Solution in Thread

3 Replies 3

No script can edit a Formula. TODAY() is a formula function that will automatically change with each passing day, with no need for a script.

Hi, Thank you for your reply.

May i know if there is a script that can change the formula to string? because I wanted to create a schedule script but first it needs to have the current date on the created new rows then auto-update it.

Standard javascript would be to use .toString() to turn any non-string into a string. Again, the script won’t be able to change the value of the formula field on the actual record unless you’re trying to insert it into a different, non-formula field.

Still not sure what you mean here. Do you just need the CREATED_TIME() formula? When you say “auto update” what type of field are you changing, what was the value originally, and what are you changing it to?