Insert Text script using value list?

[MariaAux]

I have a checkbox set with 30 'topics' for children's games. Some games can include any topic, so I want to check all the boxes.

I created a script with 'Insert Text', and listed all the topics as per the value list. which does the trick nicely to select all the topics with one button. However, as the database grows, I think of new topics, and I don't want to keep updating the value list, then this script etc etc...

Can I use the data in a value list as the text to insert in an 'Insert Text' script. I have tried without luck.

Thanks so much.

[comment]

Can I use the data in a value list as the text to insert in an 'Insert Text' script.

Have a look at the ValueListItems() function.

Note also that in most cases it's better to use Set Field{} instead of Insert Text[]. One reason for this is to allow using a calculated value - as you must in this case.

[bcooney]

Maria,

Please consider using join tables. These checkbox sets will make reporting difficult for you. You should have a table of Topics and a join table btw the Games (Products) and the Topics.