Click here to register.
      
Sprechen Sie WebGUI? Parlez vous WebGUI? Se habla WebGUI? Spreekt u WebGUI?

Do you speak WebGUI? Please help us translate WebGUI into your language.



     Web Design, Templates, and Themes > How to connect a Profile Field to a User Group?

How to connect a Profile Field to a User Group?

User LoopSetShop
Date 9/7/2008 9:45 am
Views 533
Rating 0    Rate [
|
]
Previous · Next
User Message
LoopSetShop

I would like to give users the choice to sign up to a newsletter via their profile.
Can I have a yes/no profile field subscribe/unsubscribe users to a certain group?

I know adding to a group can be done with the GroupAdd macro, but i would prefer a yes no choice under the profile edit.

--- (Edited on 7-September-2008 16:45 [GMT+0200] by LoopSetShop) ---



Back to Top
Rate [
|
]
 
 
perlDreamer

Yes.  This can be done.

Create a profile field called newsLetter group and make it a yesNo field.

Next, make your newsLetter group, and in the SQL Query field, put:

select userId from userProfileData where newsLetter=1

Now, the members of the group are determined by their profileField.  You won't be able to list the members of this group through the group interface, but they'll be in the group nonetheless.

If you want to make a list of members, use the SQL Report.

--- (Edited on 9/7/2008 8:32 am [GMT-0700] by perlDreamer) ---



Back to Top
Rate [
|
]
 
 
LoopSetShop

Thanks!
That is just what I needed to know. :)

--- (Edited on 7-September-2008 17:45 [GMT+0200] by LoopSetShop) ---



Back to Top
Rate [
|
]
 
 
LoopSetShop

With   you can even add spaces to the profile field.
e.g.:
as the label of the profile field put:

  • LoopSetShop Newsletter

and with SQL query in the edit group page put:

  • select userId from userProfileData where LoopSetShop Newsletter=1

Since   will appear as a space in html.

--- (Edited on 7-September-2008 18:13 [GMT+0200] by LoopSetShop) ---



Back to Top
Rate [
|
]
 
 

Recent Discussions Color Key

Design:

Development:

Et Cetera:

Install/Upgrade:  

Smoketest:

Template Group:


Re: Site paid for by advertizing by Klaus - Fri @ 02:27am

Smoke Test for WebGUI (Stable) (2008-11-21) by botaction - Fri @ 12:37am

Re: Site paid for by advertizing by pwrightson - Thu @ 10:59am

Re: Site paid for by advertizing by JT - Thu @ 08:58am

Re: Regelmäßiger Termin für Usertreffen in der Rhein-Neckar-Region by Klaus - Thu @ 06:11am

Smoke Test for WebGUI (Stable) (2008-11-20) by botaction - Thu @ 12:00am

Smoke Test for SVN (2008-11-20) by botaction - Thu @ 12:00am

Re: Improving page layouts by fdillon - Wed @ 08:38pm

Re: Improving page layouts by knowmad - Wed @ 08:25pm

Re: Site paid for by advertizing by knowmad - Wed @ 08:07pm

Re: SSL Configuration? by knowmad - Wed @ 07:51pm

Re: The Death of the Collaboration System by preaction - Wed @ 07:39pm