What I would like is to be able to select multiple values from the drop down list and have them put in a field separated by a "+"
If the field already contains the value it should simply delete that value from the field
That seems a contradiction. What difference in user action distinguishes between selecting a value and having it replace an existing value instead of appending it to the field with a + character as the separator?
Why use + as a separator?
For what it's worth, you can hold down either shift or control keys while selecting values from a value list to select multiple values from a list, but the values will be separated by returns, not the + character.
I would like them to be separated by the "+" character in the end.
The drop down list will most likely have values like this:
I would like to be able to have multiple selections so the field will look like this:
I guess having them select a number that is already in the field to delete it is a contradiction and probably isnt a good decision
Does that help at all?
You can set up this auto-enter calculation in field options and the multiply selected values will be separated by + instead of returns:
Substitute ( self ; ¶ ; "+" )
and clear the "do not replace existing value..." check box.
that did it! thanks!