Membership managed is controlled via the module user.

I want to enable users to change their preferences/options, via a checkbox.

They can currently add a preference, but if they try to remove a preference it does not update the database.

So if a user had already selected rock_and_pop as a preference, their edit preferences would come pre-ticked, but if they unticked the box, it would not be saved.

Bump.

Another idea, if this cannot be done maybe this is might work, but not sure how to set this up: to set all the preferences to null on page load?

Bumping a thread in HTML & Design, for a third party module, after less than 24 hours? On the 4th of July weekend? Patience, grasshopper.

Sorry, I didn’t release it was less than 24hrs. I should stop being an eager beaver. I also didn’t think about the 4th of July celebrations, being British and all. Apologies.

Though, I think I know what I’m going to do now ...

A problem with a checkbox is that the browser will only include it in the request when it is checked. If it is not checked, the HTML specification suggests that it not be sent (i.e. omitted from the request).

So I’m going to use some JavaScript to tick a hidden checkbox if the visible checkbox is unticked, to produce a different value in the database.

Not ideal, as I would like the value to be null rather than “0” or “N”, but I can work with that.

A problem with a checkbox is that the browser will only include it in the request when it is checked. If it is not checked, the HTML specification suggests that it not be sent (i.e. omitted from the request).

Right. Perhaps you could make it a radio box? Or have a hidden value that you change if the box is checked? Using jQuery that shouldn’t be too difficult.

So I’m going to use some JavaScript to tick a hidden checkbox if the visible checkbox is unticked, to produce a different value in the database.

I see you’re going down that route anyway

I’m still undecided on which route I’m going to take, as I haven’t 100% figured out the JavaScript required for my idea above, as there is likely to be a name conflict.

I’m going to look at the the two other suggestions above, to see if I can figure them out.

I’m having the same problem… the closest thought I had was having the value of the box vary, depending on whether it is checked or unchecked on edit… i’ll explain my situation:

Customer orders 1 x PRODUCT which has optional extras B & C but does not want optional extras A or D so leaves these boxes unchecked. No problem there.

Customer wants to edit order however - edit form populates with existing order, unchecks B and checks A. A is added to the order but because B is unchecked, it is not changed.

Really not sure how to approach this… how did you go with some javascript? I’m just about to check jquery for the relevant type of thing but thought you may have had some luck.

Ok WOW that was easy! I’ll update if this doesn’t work as it seems a little too simple but so far so good.

Check out the link below but basically a hidden input in front of the checkbox input with the ‘unchecked’ value is all you need - if POST with the box ticked then that value is sent, if you POST with it unticked then the hidden value is sent. Good luck!

http://iamcam.wordpress.com/2008/01/15/unchecked-checkbox-values/

Yeah, spot on. That does exactly what I want it to do.

There I was thinking it was more complicated than it was, trying to figure it out with Javascript etc.

Many thanks Adrian, works a treat.