value list items to append to field content

[DrChris]

Hi folks,

I want to set up a value list, so that when I select items on the list, it appends to other items in the field, instead of that item being exclusive for that field.

e.g. value list contains (VERY simple example here);

Red

Blue

Hat,

Shoes,

From this list, I want to be able to sequentially select certain items that build on each other, such that my field might, after the selections, read something like;

"Red Shoes, Blue Hat,"

I've seen this functionality in an ipad program (Handbase) and hoped I could replicate it here.

Chris

Edited August 10, 2010 by Guest

[comment]

I'd suggest you use two fields and two value lists.

[bruceR]

You're just talking about a checkbox field; and a second calc field, calculation:

substitute( theCheckboxField; ¶; ", ")

[DrChris]

Thanks guys,

The checkbox option sounds good - but will need to learn a bit more about that aspect of scripting first. Might keep that one for later tho.

Chris

[DrChris]

You're just talking about a checkbox field; and a second calc field, calculation:

substitute( theCheckboxField; ¶; ", ")

So just to confirm, if I have a bunch of checkboxes where each corresponds to a phrase of text, that when each is selected, the corresponding phrase is inserted into a designated field, and builds upon (appends) text inserted from the selection of a previous button.

The goal would be to have a bunch of pre-typed phrases/statements, that when their corresponding button is checked, that text is inserted into a (text) field, to build a paragraph of text.

[comment]

t when each is selected, the corresponding phrase is inserted into a designated field, and builds upon (appends) text inserted from the selection of a previous button.

Approximately, yes. To better understand the issue, place another instance of the same field on the layout and format it as edit box. Check and uncheck items in the checkbox field and observe the actual content of the field.

[DrChris]

Thankyou. Will give it a go.

Just to check - what is the 'carriage return' symbol in the script for?

[comment]

It's a calculation, not a script. It turns:

"Red

Blue

Hat

Shoes"

into:

"Red, Blue, Hat, Shoes"