I am working on a batch scheduler and I need to add in more criteria to the Option Range. Currently, the template for the scheduler gives 4 cells to input criteria. I will need to add 7-10 options to the scheduler. How do I go about adding additional criteria to the scheduler?
Date
Votes
4 comments
-
Jet Reports Historic Posts Could you attach the template as I'm not sure what your starting point is?
-
Jet Reports Historic Posts I think I figured it out. I used the batch scheduler template that Jet supplies and updated the Command Line tab to include more Range and Value columns. Please see the attached and let me know if it makes sense. The Parameters tab used to have 4 options and I have added more options so there are a total of 15 additional options.
-
Jet Reports Historic Posts The range1 and value1 cell references on the command line sheet look a bit odd (the don't reference the same section as the rest, on the other sheet), but it looks like you've extended number of options just fine. Give it a bash!
-
Jet Reports Historic Posts Thank you for reviewing. The range1 and value1 cells are correct on the Command Line, as it is referencing the Batch Range cell on the Parameters tab. I did not alter any formulas in those cells, and that is how the formulas looked in the schedule template. The scheduler works and can be used by anyone who is looking for additional options to the scheduler.
Please sign in to leave a comment.