I'm a little confused about your post. Did you make a new checkbox set, or add an additional checkbox to a previous checkbox set.
Let's say the new box is called 'Box 11'. Can you make a found set of just the records that need or already have 'Box 11' box checked? If so, then you could use replace field contents.
I think that you want to select a new check box in every record of a found set without losing previously selected values.
Replace Field contents [ YourTable::CheckboxField ; List ( YourTable::CheckBoxField ; "New Value Here " ) ]
will append "new value" to the existing list of return separated values produced by clicking check boxes.
Quick question, do I just put that into the calculated result option on Replace Field contents?
Never done it before.
Yes, I want to add a second tick to my check boxes in the field in one go to 5000 records, without losing the other ticked options.
I've tried putting it into calculated result option on Replace Field contents with this in the pop up box:
client table main table::MARKET ; List ( client table main table::MARKET ; "EDUCATION " )
and it says it expects an operator + etc?
I don't think you need a calculated result, do you. Phil's suggestion was not a calculated result option, just the steps you will encounter.
If I understand you correctly, try this on a backed up or sample file (I am also assuming the checkbox you added is titled "Education").
1. Get the found set of records you want to append with the checkbox.
2. Check the box in one of the records.
3. Top menu bar Records, scroll down to Replace Field Contents.
4. The Replace Field Contents menu that pops up will have the first line with a radio button that says....Replace with: "X"
5. Hit 'Replace' at the bottom.
Yes it IS a calculated result, but you don't include the first field and semi-colon, only the expression to the right of the semi colon. What I showed was basically the script step format, so when doing this manually, you just need to enter the expression to the right of the semi colon.
That works 100% and it's a big help for what I need to do :)
That is what I have done up to now; but if I did that it would change everything to Education, not add Education to what is in there already.
Note: the draw back to this method is that if the value was already selected, you get it in the field twice--which can mess up the behavior of your check boxes. I didn't have a concern about that as it appears that you were pulling up a set of records for which none had that selected.
But there is a more sophisticated calculation that can be used that only appends the value if it is not already in the list.
@Phil, what is the more sophisticated calculation as this may happen?
And is there a way to search fields to check if a value has been entered twice?
Thanks a million as always for your help :)
If ( IsEmpty ( FilterValues ( CheckboxFieldHere ; NewValueHere ) ) ; List ( CheckBoxFieldHere ; newValueHere ) ; CheckboxFieldHere )
Finding all records where a value is present twice would not be simple to do. You could set up a calculation field:
ValueCount ( FilterValues ( CheckBoxFieldHere ; ValuetoCheckForHere ) )
And look for values greater than one in that field.
Very Useful Phil :)