Create Checkbox Value List from Field

[Meaderman]

I need to allow the user in a runtime solution to create their own list of values for a checkbox field. The runtime version does not allow access to the Values Lists menu item and I can't configure checkbox fields with an "edit" option. How can I do this? Is there a script step that will bypass the limitation in runtime to allow the user to edit the value list of a checkbox field? I tried to create a global field for the user to input values to be used to generate the value list but it doesn't work because the global field can not be indexed. Anyone know a work around? Thanks for the help!

[Oldsneekers]

Two options come to mind thinking on the fly...

1). Make a pop up window layout with your global field formated to the value list name you desire and set THAT value list to edit. A script allows user to access the pop up window. Close button in the window hides it.

2) Make a new table with a single field (containing the value list options). Now make a pop up window layout formated to this table and buttons scripted to make new records and closing the pop up window. Define the value list to have values from this table field.

[dwins]

Another solution. Don't use the checkbox field format type. Any field can be a checkbox if you put an X in it.

Turn a little square text field into a button with Set Field script Case(checkfield="";"X") so it's a clickable check/uncheck checkbox.

A text field next to it can hold its editable label. If you want the labels to be set separately, label the checkboxes using calc fields that use a LeftValues or MiddleValues function to grab words out of a global field.

David