Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListCreate a form with reply message and field look up value from different databaseCreate a form with reply message and field look up value from different database
Previous
 
Next
New Post
9/19/2010 11:47 AM
 
Hi

I am pretty much newbie to DNN and would like to do the following

Site Name : ( List Box which connects to DB1->Table 1->Column 2)
Building No: (List Box which connects to DB1 -> Table 2->Column 3)
Room No: (List Box which connects to DB1 -> Table 3-> Column 5)
Category : List Box (values will be keyed in by the admin)
Contact Person: (Free Form Text keyed by the user)
Phone : keyed by the user typing this request
Email :  uesername(@domain name) -  The user name is keyed in by the user and the domain name is constant the value being @c1.com
Description of the problem: (keyed in by the user - free form text)

                    Once the user keys in the above mentioned details and click "Submit" Button, the user should receive an email message which the above mentioned details. The same mail will be bcc to helpdesk@c2.com.

Please suggest how this could be done.

 
New Post
9/19/2010 2:16 PM
 
FnL has no option to access existing SQL tables. you will need to use a 3rd party module or create your own data types.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/20/2010 12:33 AM
 

Thanks for that information

Well if thats the case

Site Name : text box
Building No: text box
Room No: text box
Category : List Box (values will be keyed in by the admin)
Contact Person: (Free Form Text keyed by the user)
Phone : keyed by the user typing this request
Email :  uesername(@domain name) -  The user name is keyed in by the user and the domain name is constant the value being @c1.com ( should be displayed in the form)
Description of the problem: (keyed in by the user - free form text)

Once the user keys in the above mentioned details and click "Submit" Button, the user should receive an email message with the above mentioned details to the mail address mentioned above. The same mail will be bcc to helpdesk@c2.com.

any help/thoughts appreciated. :)

 
New Post
9/20/2010 5:34 AM
 
Sounds to be possible using FnL, what is the issue you encounter?

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/20/2010 7:18 AM
 
Hi Sebastian

Please find the columns i have created
     Column Name    Type
1. Building No:         (Text) - with list values supplied
2. Room No:             (Text ) - supplied by the user
3. Email:                    Email

In the Email Settings  i gave the following values
To: [field:email]
BCC: servicedesk@c2.com

But when i click on submit , i get the error
Tracking/Notification issue: Field field:email is either not a valid source for email adresses or it was not found inside fields definitions.
         I want the user who is filling out the form to recieve the message with all details which is trapped in Email Address

Issue No:2 - Is there any way i could get a message displayed on the web page once i click on the Update Button
                  " Thank you for using the Online Maintenance request Form. Our team will contact you shortly"

Issue No:3 - I dont want any user to know what other users have put the request for.

Issue No:4 - Is there any way the key word " Add New Record"  could be changed to " Create a request"

Thanks

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListCreate a form with reply message and field look up value from different databaseCreate a form with reply message and field look up value from different database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out