Hi

I have a value list of ages

it is:

All

0-4

5-10

10-14

14-19

20-30

30-40

40-50

50-60

60-70

70-80

80-90

90-100

100-110

I set it up as a check box option in the field entry

My questing is : How to I use a calculation to set the field with several options selected?

In my script I used this:

Questions::age&"40-50"&"50-60"

The script is called middle ages because I wanted to select all those groups at once. I can't seem to get this to happen. I would appreciate your help. Thanks

Try Set Field [ YourField; List ( "40-50"; "50-60" ) ]

I tried it but it doesn't work. There is an error. I don't know how to correct it.

[ Questions::question; List ( "40-50"; "50-60" ) ] is the calc I used in the set field.

What is th error?

Was List() in FMP 9?

Try: inserting the literal text "40-50¶50-60". The pilcrow character is a carriage return and it separates the different values.

Here is a screen shot of the error

IIRC it came out in 8.5

I cant see it, please post it here.

Sorry you couldn't see it

I used

[ Questions::question; List ( "40-50"; "50-60" ) ]

The error was

A number, text constant, field name or “(” is expected here.

the first "[" was highlighted

Sorry you couldn't see it

The forum accept tiff files, why didn't you post it here?

I did post it as a tiff file. Somehow it didn't work.

Hi hartmut

As you might have noticed, I having been testing how to attach a tiff image. I forgot that we have changed sites and software since I last did this. IIRC, you used to be able to paste a TIF image directly into your post. If you do that now you get the crazy URL that takes you nowhere. If you attach it as a file, it's downloaded like a FileMaker file.

If you convert the TIF to a PNG, and attach it as a file, then it will show in your post.

Hope this helps

Lee

I converted it to a png but I can't see how to attach it to the post.

Like you would if it was a FileMaker file. Only you don't need to zip it.

Step 1

Find the file on your hard drive.

Step 2

Do not use the Quick Reply, BUT instead, choose the More Reply Option

Step 3

Click on Attached Files and this will take you to your hard drive to locate your file that you want to attach and that you previously zipped. Select the file, and then click Attach This File, and then click Add Reply.

I think that you've mistaken what goes in the calc dialog.

List ( "40-50"; "50-60" ) is the only part that goes in the calc dialog.

Try Set Field [ YourField; List ( "40-50"; "50-60" ) ]

I think that you've mistaken what goes in the calc dialog.

List ( "40-50"; "50-60" ) is the only part that goes in the calc dialog.

I tried it but it doesn't work. There is an error. I don't know how to correct it.

[ Questions::question; List ( "40-50"; "50-60" ) ] is the calc I used in the set field.

As you see it in the Script Step, does it look like this?

Set Field [ Questions::Questions; List ( "40-50"; "50-60" ) ]

if not, how does it differ?

List ( "40-50"; "50-60" ) that works - that was all i needed in the calc dialog box. i didn't understand thanks everyone