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?
Solved
Auto change today() on column
Best answer by Kamille_Parks11
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?
This topic has been closed for replies.
+27No script can edit a Formula. TODAY() is a formula function that will automatically change with each passing day, with no need for a script.
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.
+27Hi, 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.