Is it possible to password protect a form?

I want to force users to enter a password in order to access the form.

Hello Brett,

Yes, this can be accomplished with Dynamic Forms. However this can be very advanced to implement. You may want to think of this as a Promo/Coupon Code type of functionality. You verify the code provided and perform an action when valid or invalid.

Unfortunately I'm unable to elaborate more in detail as how to configure this type of custom development using Dynamic Forms.

Data Springs has a Premium Service options that can assist you with getting this configured:
www.datasprings.com/support/premium-support/premium-support-options

Please let me know if you have any questions.

Thanks,

Ryan

Thanks Ryan. I ended up creating a separate login page and then doing a redirect if the correct password is entered. That solved the problem.

Great to hear that you found a solution that works for your needs.

Sounds like you're handling this in a different manner than your initial inquiry, however sounds like you have the condition you need to "password protect" the form.

Please let us know if you ever have any questions.

Thanks,

Ryan

This isn't exactly how I wanted it to function but it will work. I didn't understand the "Promo/Coupon Code functionality" that you mentioned previously. Thanks.

Thanks for the details Ryan and Brett... Just a quick note that you can also use "SQL Validation" for this. You can set a password field up (you can also use the short field name of 'DSPassword' within the name to represent a password look and feel) and then pass the value into a SQL query or stored procedure that can return a column called "IsValid". You can reference the user guide for "SQL Validation" for several examples and more information on how this actually works.

Thanks!

-Chad

Thanks. One question. If I use SQL validation to check the password can this be done on the same page as the form using panels?

Or would I need to create a separate page with just the password field? That would then redirect to the form using a completion event if the password was valid?

Hello Brett,

I believe you stated that you're using Dynamic Login for your solution to your initial question.


SQL Validation is a feature within Dynamic Login that you can utilize further. However Dynamic Login is probably not the best tool to use if you're validating a Password that's irrelevant to a User Account. Dynamic Login simply verifies and validates the User account information provided.

Perhaps a simple method for you would be to build a Host -> List named "Passwords". Then you can access this List by using SQL:

Select * from Lists where ListName = 'Passwords'

Then you can use a Tool like Dynamic Forms SQL Validation to verify that the Password inputted is valid:

---------------------------------------------------------------------------------------------------
DECLARE @COUNT INT

SET @COUNT = (SELECT COUNT(*) FROM Lists WHERE ListName = 'Passwords' AND Value = '$(PasswordField)'

IF @COUNT > 0
BEGIN
SELECT 1 AS IsValid -- PASSWORD WAS VERIFIED
END
ELSE
BEGIN
SELECT 0 AS IsValid -- PASSWORD DOES NOT EXIST
END
---------------------------------------------------------------------------------------------------


'$(PasswordField)' = the field on your Dynamic Form that collects the password value from the User.

Please let me know if you have any questions or concerns.

Thanks,

Ryan

Thanks Ryan! I got this working using your example.

There is one last thing - For some reason the Validation Error Message isn't firing for an invalid password. Is there something special that needs to be done for this to display? I just put "Invalid Password" into that field.

Hello Brett,

The Validation Message below the SQL Validation needs to contain the text "Invalid Password" if you wish this to be the error message returned.

Sounds like you need to check the logic, if you return IsValid = 0 or IsValid = 'False', this means that the SQL Validation will fail and Dynamic FOrms will return any value provided in the SQL Validation Error Message TextArea box.

Please let me know if you have any questions.

Thanks,

Ryan

This ended up being a simple fix. There was a missing ")" in the SQL. Everything is working nicely now. Thank you for all of your assistance with this! 

Great to hear.

If you ever have any questions please let us know.

Hope you have a wonderful day!

-Ryan