Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Form that toggles User Role
Last Post 02-11-2010 01:26 PM by Chad Nash. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Jeff SullivanUser is Offline
going with the flow
going with the flow
Posts:39
Avatar

--
02-06-2010 05:33 AM

    Hi, I've got a form with 2 questions, and I want to use the combination of answers on the questions to set or remove a custom DNN role from the user's account.

    I can't seem to get the set/unset behavior to work the way I want.

    As an example, I created 2 multiple choice (radio button) questions with 5 choices each.

    I want to set Role X if and only if the user answers question 1 with item 3 and question 2 with item 4.

    What I did was set up 2 form completion events:

    When Question 1's value = "Item 3" then Set Role X

    When Question 2's value <> "Item 4" then Unset Role X.

    I would think this does what I want, but Role X is never getting unset, no matter what answer I put in Questions 2.

    I've tried a few combos, but it appears that the not-equals test is just not working.

    Anyone have any tips?

    Jeff SullivanUser is Offline
    going with the flow
    going with the flow
    Posts:39
    Avatar

    --
    02-10-2010 03:11 PM

    Nobody has this issue?  Is there a demo config of a form that does this that I can look at?

    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    02-10-2010 03:16 PM

    Hi Jeff,

    The 2 layers of conditions is a little tricky.  Instead of role events, how about you use SQL events to add roles based on specific conditions?

    Candace

    Jeff SullivanUser is Offline
    going with the flow
    going with the flow
    Posts:39
    Avatar

    --
    02-10-2010 03:21 PM
    What's tricky about it? The logic seems clear to me -- is something about it not supported?

    I am open to trying to do this with SQL, though it's not immediately obvious to me what that would look like. Do you have a suggestion? It still seems like it would come down to 2 different form completion events, wouldn't it?
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    02-11-2010 07:02 AM
    HI, the best and easiest way to get this to work is to:
    1) create a hidden field
    2) use client side javascript to set the hidden field to say a value of "set" or "unset" based on the combination of questions
    3) create two DNN role events based on the value of the hidden field (if it is "set", add the role, if it is "unset", remove the role).

    The problem is that you want a DNN role completion event to act on a combination of two fields but a completion event can only be checked based on a value of one field which is why you need to use client side javascript to set a value for one field to compare to. -- David
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    02-11-2010 01:26 PM
    Jeff,

    Yes... David and Candace are correct. Currently Completion Events must be linked to a single field response so you can either.

    1. Use client side events to set a hidden field and base your completion event on that field
    Or
    2. Use a SQL completion event, passing the field value(s) into that stored procedure and have the stored procedure execute and insert or update to the UserRoles table. There are several examples of this within the forums... I would google 'Site:www.datasprings.com Insert Into UserRoles' to find different examples. Some are more involved then others and based on many more fields then 2 for a completion event so it might be better to go the client side events route.


    Thanks,


    Chad

    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi