Forum Discussion
ChayceDuncan2
6 years agoQrew Cadet
Based on what I'm reading I think I might have a solution. So based on the above - you already know if something should process each month based on the Jan - Dec field. So - you can use those, and the current month to run you 'Process' checkbox, using a the below formula
var number currentMonth = Month(Today());
If(
$currentMonth=1,[Jan],
$currentMonth=2,[Feb],
$currentMonth=3,[Mar],
.....etc
)
Its a little different than I initially proposed - but in a nutshell it will say,
If the current month is January - the whether or not it will process will be the output of [Jan]. So its just copying the yes/no output of that checkbox. If its February, copy the output of that field all the way through december. That way each month its just checking on the right field, and you can simply re-purpose that pre-existing logic without have to do anything overly complicated. Hopefully that sounds feasible.
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
var number currentMonth = Month(Today());
If(
$currentMonth=1,[Jan],
$currentMonth=2,[Feb],
$currentMonth=3,[Mar],
.....etc
)
Its a little different than I initially proposed - but in a nutshell it will say,
If the current month is January - the whether or not it will process will be the output of [Jan]. So its just copying the yes/no output of that checkbox. If its February, copy the output of that field all the way through december. That way each month its just checking on the right field, and you can simply re-purpose that pre-existing logic without have to do anything overly complicated. Hopefully that sounds feasible.
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base