HJow to use a List Box Tool in the right way

[mathias_schnoor]

Hey!

I want to use a ListBox Tool together with a Formula Tool.

I want the check concate with an existing Field.

I try:

List Box properties:

eat-drink:cat01
restaurant:cat02
petrol-station:cat03

After run iI get the error message an operator must between operants

Who is my bug?

Mathias

[michael_treadwell]

In your List Box Tool you must have 'Generate Custom List' checked.

This is replacing the string mycategory in the formula box with something like "cat01"

This means the formula is [url] + " " + ""cat01"" (note the double quotes)

This is an invalid formula.

In your Formula Tool, trying replacing "mycategory" with 'mycategory'. This will allow your app to run with no errors, however, I am not sure it is accomplishing what you need. Could you describe your use case a bit more?

[mathias_schnoor]

Hey Michael,

thank you for your support.

I try 'mycategory'

then I get

 mystring cat01=True,cat02=True,cat03=True

or mystring cat01=True,cat02=False,cat03=True

or so...

I want to get:

mystring cat01cat02cat03

How can I reach this solution?

Mathias

[michael_treadwell · Accepted solution]

In your list box configuration, choose 'Generate Custom List' then remove all characters from Start Text, Separator, and End Text.

[mathias_schnoor]

thank you for your support. again.

I have build to your instructions.

It works fine ;-)

Mathias