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!

Passing one field value to another field value
Last Post 10-10-2012 10:51 AM by Ryan Bakerink. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
wazooUser is Offline
wading in the water
wading in the water
Posts:19
Avatar

--
10-10-2012 03:35 AM
    Hi all,

    I have two questions regarding on DF. 

    1. How to pass one field value(any type) to another field value(any type) in two different forms based on UserID? E.g. a textbox field to combo box field (drop down) by using SQL query.

    2. Can I set up a form (DF) that send email directly to that individual UserID? 
    From email address: drop down list from query
    To employer email address: drop down list from query
    To teacher email address: drop down list from query

    Description: multiple line text

    With a submit link, it would send out email to those individuals.

    I know that DF has a Dynamic Email event in completion event section, but it would not apply to the description above.

    Any suggestion is greatly appreciated.

    Wazoo
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    10-10-2012 06:09 AM
    Hello Wazoo,

    I would encourage you to invest looking into our Dynamic Form Demonstrations. Many of these functionalities you're inquiring on, are covered in our Demonstrations sections.

    http://www.datasprings.com/formdemos

    Both of these items can without a doubt, be configured within Dynamic Forms.


    ITEM 1:
    Are these two forms on 1 page or on different pages? If on the same page, you can use JavaScript or a Question Event - Set Default Value. If on different pages, you'll need to perform this assignment using SQL.

    ITEM 2:
    You can easily build a Dynamic Form to have these input fields. There's a token available to you $(UserID). This token grabs the User that's logged in and utilizing your form. With this ID you can run SQL to return any information stored on this user, E.g. First Name, Last Name, Email Address, etc..

    So you could add a Question of type Hidden Field and give it a SQL Default Value of:

    Select Email As DefaultValue from Users where UserID = '$(UserID)'


    Let me know if you have any questions.

    Thanks,

    Ryan

    wazooUser is Offline
    wading in the water
    wading in the water
    Posts:19
    Avatar

    --
    10-10-2012 07:42 AM
    Thank you for quick respond.

    These two items are interrelated.

    ITEM 1: The forms are on the different pages. First form has the field values (first name, last name, email address, description, etc.) are stored in my own table, that is , name table 1. Second form has been setting up to pull in value from table 1 field values and will be stored in table 2. 

    Your suggestion made me conclude that I should use as following in ITEM2?
    Select * from table 1 inner joint table 2 ; the field names; where as Userid = 'UserID'

    Once, the email values have populated in drop down combo field that the form can send to those individual email addresses. That means, these information will be their mailboxes? 

    Thanks again,
    Wazoo
    wazooUser is Offline
    wading in the water
    wading in the water
    Posts:19
    Avatar

    --
    10-10-2012 08:52 AM
    I just want to clarify that the form such as following:

    From Email address: me@yahoo.com
    To Email address: you@gmail.com
    Phone:
    Message:

    Send

    Would I be able to send this information to that email address from this form?



    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    10-10-2012 09:12 AM
    Hello Wazoo,

    Yes you can send an email using a Dynamic Form with these fields.

    Let's say these are the shortfield names of your Dynamic Form Questions:

    * FromEmail
    * ToEmail
    * PhoneNumber
    * Message

    These will become available tokens in your Email Form Completion Event.

    $(FromEmail)
    $(ToEmail)
    $(PhoneNumber)
    $(Message)

    You can place: $(FromEmail) in the from section of the Email event
    You can place: $(ToEmail) in the To Email section of the Email event.
    You can place: $(PhoneNumber) and $(Message) into the WYSIWYG editor/template.

    Let me know if you have any questions.

    Thanks,

    Ryan

    wazooUser is Offline
    wading in the water
    wading in the water
    Posts:19
    Avatar

    --
    10-10-2012 10:35 AM
    Thank you, Ryan.

    You have been very supportive and have learned a lot from forum.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    10-10-2012 10:51 AM
    Great to hear, that is our aim

    Hope you have a great day!

    -Ryan
    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