I’m starting to get so frustrated. If you know of a place to find commonly used formulas in coda. I would appreciate it. So much potential but the formulas and rules are killing me!!!
When status changes to "active ". Then stamp Active date= Today().
If(thisRow.STATUS=ACTIVE,Today(), “”)
Problem is that when the status changes, the date disappears. Should the formula be in the status field? I feel like it should be a simple formula. It’s a common need to have a date stamp when status is Active.
What is the formula for just enter the date when status is " ". ??
Unfortunately what you are trying to do is not the simplest topic on Coda, it is a little more complicated than one would think at first.
This page contains a full list of the Coda Formulas. This is a free Coda resource:
Hang in there, it takes a bit of time to get the hang of the formula language, but once you get it, you’ll never look back.
I am (slowly ) building a reference manual that gives more detail than the Coda list gives, also with some explanations and comparisons. View is free, to be able to edit the doc and re-use the examples, there is a small fee.
The page Status - Button with runActions() is probably the closest to your requirement.
) building a reference manual that gives more detail than the Coda list gives, also with some explanations and comparisons. View is free, to be able to edit the doc and re-use the examples, there is a small fee.