I want to create a form for students to complete and parents to approve. In addition to student info the form would have the parents first and last names, and email address.

I'd like to use the SQL Completion Event to create a DNN User and assign it the Parent Role.

Can I use the SQL Statement to execute a stored procedure to insert a record into the DNN User table? If so, how would I include a Password since its not part of the user table?

Thanks.

Hi,

Unfortunately I don't believe you would be able to do this with Dynamic Forms. I think you would probably have to use an HTTP Post event and probably using Dynamic Registration Silent Post option to have the user created. This would be necessarily because there are a lot of tables and processes that go on behind the scenes then just some SQL / Data in the tables. Dynamic Registration uses DNN Core API calls that handle these which then include having the password setup in HASH mode, adding data to all of the right tables (users, userprofile, aspnet_user, aspnet_membership, userroles, userportals, etc.. ). So... Unfortunately I think you can come close trying to update just these tables but for many areas you will not be able to create the user properly from SQL alone.


Thanks,

Chad