I have a Yes/No field "ToDo" and a date field "Date".
When I check the ToDo box I want to set the Date to Today and then uncheck the ToDo box.
I tried these equations:
1. For ToDo: A: Date=Now
2. For Date: A: ToDo=
However, only the first equation is executed; checking ToDo sets the Date, but the ToDo box is subsequently not unchecked.
I think that I read in the Doc that it is not possible the way I tried it..?? Is there a workaround?
How do I ?
Comments
An item field-value cannot…
An item field-value cannot modify itself (not directly nor indirectly as in your example). It could cause infinite loop lock-up
I modified the the 2nd…
I modified the 2nd question slightly to get:
1. For ToDo: A: Date=Now
2. For Date: M: ToDo=
Now when I check ToDo, the Date is set as before.
When I subsequently modify the Date, ToDo is unchecked.
So it seems to work if I wait "long enough" between the commands?
(I assume that setting the Date falls under modifying the Date?)
If so, can I write a VB script and include a wait command between the two equations? Something like:
or some other wait command if WScript.Shell would not work in IQ?