Formula to create an array of checkboxes

HCL Domino Domino Forum
1

I have a bit of a brain scratcher here,

I am trying to create a formula that will create 3 checkboxes in an array to hold 3 different years. So the result would be 3 checkboxes to hold the years 2007, 2008 and 2009.



My big hurdle seems to be a formula command that will create a checkbox, any suggestions out there?

Thank you.

2

Subject: Formula to create an array of checkboxes

You can create a checkbox field that gets its values from a formula. If, for example you wanted the checkboxes to display the next year, the current year and last year, you create a field, of type checkbox, on the second tab you select “Use Formula for choices” and your formula could be :

@Text(@Year(@Now) ): @Text(@Year(@Now) - 1) : @Text(@Year(@Now) - 2)

The selected years would be stored in the field as a text list.

Not sure if this is what you’re looking for

3

Subject: RE: Formula to create an array of checkboxes

Thank you Ernesto, your solution is exactly what I was looking for and much more straight forward than my approach.

Thanks again.