Hi all,

I have multiple checkbox fields on a layout. They are filled by a value list based on the product IDs in the back and the product names in the front, so the user can see the name when selecting and I would get the ID for my relationship. When there are a lot of selections though the users want to be able to select a product name for all checkbox fields, so I was thinking about replace field contents or a loop but I can't script the checkbox field to select a name?

Can someone help with that?

Thanks.

Hi all,

They are filled by a value list based on the product IDs in the back and the product names in the front, so the user can see the name when selecting and I would get the ID for my relationship.

Value can be set up to display only value from second field but insert ID. In your 'Specify Fields for Value List' (inside Edit Value List, Specify Field), you select your ID in the left pane and the name in the right pane. Then below, select 'Show Values only from second field.'

UPDATE: I might not understand. If you have it set up this way and want to simply select all values at once, it would be like this:

Set Field [ yourCheckBoxField ; ValueListItems ( Get ( FileName ) ; "yourvaluelistname" ) ]

Edited June 10, 201015 yr by Guest
Added update

Yes, I have set them up like that. There lies the problem. I have multiple communities with a checkbox set with available products for each of them. I can pick and choose one or multiple products for each community because each product of each community has a separate ID. But I can't select one product only for all communities. Please check out the screenshot.

Thanks.

You might try something like the attached. You would of course be setting the IDs instead but the principle is exactly the same.

UPDATE: I switched it to IDs so I match what you said you had.

checkbox.zip

Edited June 11, 201015 yr by Guest
file attached

Thanks. This solution does what I am looking for. Please explain how you are doing it, because if I understand correctly it won't work in my case where each product for each community has a separate ID, i.e. the Directory for Abbots Pond is 1, but the Directory for Aberdeen is 2.

Then I didn't understand. How are you structured? Do you have a different products table for EACH community? Or do you have a value list with a community field? It just doesn't make sense to me.

I'll need to understand more before I can make a good suggestion because all I can see now, understanding a bit more of what you have, is that you will need to translate depending upon the community or use a join from name to name (such as Directory to Directory) but I still don't have enough to work with to see your structure. It would probably work best to see your file (or an empty clone) zipped.

Hi all,

I have multiple checkbox fields on a layout. They are filled by a value list based on the product IDs in the back and the product names in the front, so the user can see the name when selecting and I would get the ID for my relationship. When there are a lot of selections though the users want to be able to select a product name for all checkbox fields, so I was thinking about replace field contents or a loop but I can't script the checkbox field to select a name?

Can someone help with that?

Thanks.

Why would a user want to do this in the first place?

Is there some way you can upload your file; or a clone; or a simplified example of what you're trying to do?

Thanks. I revised the file you sent me to see how I am setup. Unfortunately I inherited a very complex solution which was build by a different person who set some relationships on Names and some on IDs. Which of course doesn't make my work any simpler

I appreciate if you have another crack at it.

checkbox.fp7.zip

Thanks for the interest and hope you can help.

I am inhouse in a publishing company, where the customers should be able to select any number of products for any number of communities and create an order, so I need the ability to select single products separately or multiple products at once (the actual number of communities is about 150, so manual selection of the same product for all will be too slow.)

I am inhouse in a publishing company, where the customers should be able to select any number of products for any number of communities and create an order

There is no Orders table in your file. Please clarify this point: a customer orders a newsletter for the Aberdeen community. Does that mean that the community did not have a newsletter until now, but will have one from now on - or does it mean that the customer wants to receive the newsletter that the community already has?

Hi, the customers are buying ads in the publications already existing for a community. I am only including a small piece of the solution because that is where I am stuck. For our purposes I am just trying to collect a paragraph return separated list of the IDs representing all selected products, that I can use for my relationships.

OK, but something still doesn't fit here. Suppose a customer wants to place an ad in 4 communities. They select "Directory" - but not all communities have a directory.

Correct. If they select directory, all directories from the list should be selected. It will just skip the communities that don't have one. Some kind of a loop that checks for "Directory" within the available products like a PatternCount of the ValueListItems, and then selects the "Directory". The selecting is where I get stuck, because I can't select the name, and the ID is different for each community.

I can't see the forest for the trees in your file. Perhaps this might help you:

checkbox2.zip

Thanks a lot. I don't know what you mean with the "forest and the trees", but yes, it does help. It gives me an easy way to get the different IDs for the same product for each subdivision and than I can use that list to set my selection (I added a Set Field to the Communities:Selected) and then go to the full list of related publications.

I am attaching the finished file, in case anybody is interested.

Thanks again for the help to you, LaRetta and BruceR. Have a great day.

checkbox2.fp7.zip