Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Live Content v1.6 :: Web 2.0

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Dynamic Forms 2.7

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Data Springs Collection 2.0 (20+ Modules)

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Catalyst By DrNuke

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Thursday, December 04, 2008   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Subject: Reservation Number & email features
Prev Next
You are not authorized to post a reply.

Author Messages
Igo
Posts:3
02/27/2008 9:22 PM  

How can I create reservation number, I would like it to change by +1 each time new request is placed through form.

Another question is how can I send two emails one with complete information to the admin and another with few fields to the person who filled out the form? Is it even possible?

Thank you in advance
Chad
Posts:2271
river guide
river guide
02/28/2008 5:33 PM  
Hi there... Well this can be a tricky situation.

1st. Does the number HAVE to be +1 or does it have to just be unique? If it just has to be unique you could take the current $(UniqueCompletionID) tag which is a global unique identifier (also known as GUID). This could work, I can also tell you a way to use SQL as a SQL Default and get another GUID...

A identifier like this would look similar to: 60026C1D-65C3-4469-9E45-0FC0B2065936

So, if that will work you can either use the $(UniqueCompletionID) tag or you can create your own GUID using the SQL default.

2nd. The other option here is to create your own table and use a SQL Insert Statement to insert the data into this table. You would not be able to give the user the reservation ID at the end though (well without some tricky implementation with our Tailored Text/HTML module which could be done but again tricky). On your table just setup a Auto Number field and each time you insert the data into the data it will create the number for each entry.

3rd... Just to highlight one option is to use a SQL Default and pull in the next number (number +1) into the form for the next user. The problem here is that if two users went onto the form at the same time, or if users started submitting the form and then went to lunch, their 'reservation number' would probably be the same as another user and thats why this method is really not a reasonable solution.


As far as the other emails... You can setup as many (or as few) completion events as you would like. So you can setup one for the admin and another you can use the dynamic tokens within the email to field. For example if the shot field name is 'myemail' you can use $(MyEmail) as the email to field.


-Chad
Igo
Posts:3
02/28/2008 10:30 PM  
Chad thank you very much for your thorough response.

I would like to have some smaller reservation number that I would be able to send to user and that would go in line (+1). Would you be able to clarify how to do it with SQL. I am sorry I am a newbee in this

Thank you so much for your time!
Igo
Posts:3
02/28/2008 10:35 PM  
Another Idea, do you know if it would be possible to have date plus time plus first 1 letter added together to create reservation number in the hidden field? I saw some other forms do mathematical calculations like that, but I can't seem to find anything on this in the form.
Chad
Posts:2271
river guide
river guide
03/06/2008 4:48 PM  
You could use the SQL trim functions along with the grid or maybe the SQL left / right functions to maybe get the first 10 characters within the SQL GUID?

-Chad
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > Reservation Number & email features


ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement