As a pianist, I have a base with all the works of the composers I work on. I mark the date each time when I work on a score, so I can see later how much time (in days) has passed since I worked on it (using DATEDIFF). When I work on it again, I change the date. Is there a way to count the date-changes automatically, so that I can see how many times I work on a score?
Each time I change the date, the number should go one higher. I tried with (IF(Uitvoeringsdatum<TODAY(),“”,Totaal+1) but that only works for the present day. (the next day the condition doen’t apply anymore)
If you have a field called “number of times changed”
A field with a checkbox called “edited”
A field with last modified (only for the checkbox) include time
A formula field with - number of times changed +1
Then whenever you change the piece - check or uncheck the checkbox
This will trigger the field last modified to change
Then have an automation that copies the value in the field “times changed plus one” into the field - times changed.
This will keep adding one to your number of times changed field.
Thanks for your quick answer.
Checking the checkbox triggers field “last modified” to change, but doesn’t add a number to any other field. Of course the formula does this, but it isn’t triggered by the checkbox.
I’m sorry, no, I didn’t build the automation, I’m not sure how: "the automation which copies the value in the formula field to the field with “number of changes” "–> which value?
And I don’t know how to build that automation, I tried, but don’t know how to start.