I would like to use Dynamic Forms for a new site that will require a persons credit card number and name.

Is it possible with Dynamic Forms to input the credit card number on the form (under an SSL secure page) and then store that number for the staff of the website to retrieve after?  They don't need any payments processed right away, so Pay Pal or Authorize.net will not work. 

The credit card number just needs to be stored on the site to be retrieved later, it does not need to be emailed to the client (encrypted) 

Thanks for your help

Hi James,

Yes, the credit card number can be stored and retrieved later via View Form Results or by integrating with another reporting module.  I will make a point  to make sure you have really good security to protect this information to be PCI compliant, in the least.  Better if you can go beyond standard requirements.  Thanks!

Candace

Yes, there are two ways to go about achieving this.
1) on your dynamic forms page, let's say you have a shortname field called "CreditCardNumber", along with other fields. When you edit the "CreditCardNumber", you can go to Advance Field Options and check the box for "Encrypt / decrypt field results". However, by using this option, the only way to view the result is to use Dynamic Forms built in "View Form Results". You can configure "View Form Results" to be viewable only to Administrators of the website under "Module Configuration / View Results Option Security"

2) or you can create your own SQL table (http://dotnetslackers.com/articles/...rial.aspx) with the CreditCardNumber column as an encrypted column and use an SQL completion event (calling a stored procedure) in Dynamic Forms to insert the data into this SQL table. With this method, an admin with access to Host / SQL in DNN or SQL Management Studio can query directly against the SQL table to retrieve the CreditCardNumber (unencrypted SQL query obviously). -- David

Candace and David thank you both for your replies.  That was exactly the anwer(s) I was looking for.  I am glad it can be done.

Candace does Datasprings have a reporting module that integrates with Dynamic Forms?

David thank you for your detailed descritions. I will be using one of your methods for my form. I really appreciate you taking the time to give a detialed description. That really helps me out a lot.

Thanks again!  -- James

 

HI, we have used Open Web Studio and Indoogrid as a reporting tool to integrate with Dynamic Forms. You can check out this tutorial:
http://www.datasprings.com/Products...fault.aspx

We also provide premium support (http://www.datasprings.com/Premium-Support) if you are interested in us developing the solution for you.
-- David

In addition to David's comments, Dynamic Forms also has a built-in report feature called View Form Results which you can access from the Module Menu.  We're also working on a new reporting module called Dynamic View which we hope to roll out by end of March or so.  Thanks!