I'm trying to get a form to do a validation against a list of values.

For example, if the user enters zip code in that matches value in one list, the redirect will go to page A

if the user enters zip code that matches value in another list, the redirect goes to page B.

if the user enters a value that does not match value in any list, redirect goes to page C.

Is this possible with dynamic forms?  Can anyone give me some guidance as to how to accomplish this?

Thanks in advance,

Don

Don,.

Sorry somehow this post was missed...

The more I review the request I am not sure this is possible within the current version at least. You can have users be redirected based on a forms value/result but... having that value result be based against a list is going to be troublesome. In the next release there is the ability to calculate values and call javascript functions, its possible that maybe depending on the response (zip code) it could maybe call the javascript function and the javascription function could pre-fill another field (or maybe a hidden field) with a value.

Is this close to your scenario?
1. User enters 92104, javascript function is called and based on that zip code it returns 'Southwest' into a hidden field. You then have a redirection function setup to redirect Southwest to a particular page.

2. USer enters 64015, javascript function is called and based on that zip code it returns 'Midwest' into a hidden field. Same type of completion event is redirected based on the Midwest value.

The major downside here would be that you would have to have all of the possible zip codes in the javascript function, depending on your implementation this might not be possible.

Another possibility might be to make this multiple forms. For example:

Form 1. First Name, Zip Code and set the fields to pass to the querystring variable. The page can redirect to Form 2

Form 2: Possibly setup a hidden field to retrieve the zip code from querystring variables and then use that parameter within the next query (i.e. Select Text as QuestionOption, Text as QuestionOption Value from yourtable where ZipCode = '$(ZipCodeField)' etc...

Then have your redirection based on that list?

-Chad

We would like to also do something very similar.  Any updates?

The first form would ask the user their ZIP Code. We would then like to compare the zip code to a list and redirect, on submission, to Form 2a if it is in the master SQL table OR redirect to Form 2b if it is not.

Is there a way to do this?

Trying to solve the issue above.

We attempted to use a Question Event to update another Text field with a simple 0 or 1 by using a  SQL driven new defau value - select  count(*) as DefaultValue from someTable where zip_code = '$(ZipCode)'  [also tried with double and no quotes]. This 0/1 would then be passed to Traffic director module where it would read in the queryString and redirect accordingly.

However the shorthand token (ZipCode) from the question does not appear to be passed to the Question event. Are question values /tokens passed to the Question event?

Using DNN 5.2.2 Forms 3.3.40

Do you need more details?

No.  The idea would be to redirect the user to one of two pages depending on the result of the Zip Code. The zip codes we  allow are stored in a dB and need to be compared. For example if   user entered zip code 2222 and it was in the dB then they would go to form page 2, ELSE the go to 'Sorry Page'.

Currently we can use the question sql validation feature such that form continues with IsValid and throws an error msg if not Vlaid. My questionis can we pass isValid=0 to a form completion event and redirect fomr there?

Question validation used and working [ select count(*) as IsValid from TABLE where zipcode = '$(zipcode)'  ]

Is there another module you know of that can preform this redirect step if  Dynamic forms / registration can not?