Hi John Smith

Do download and try out the free Joget app to create user account in Joget Marketplace which emulate what you are trying to do above. You can examine the forms and processes, including examples on using the Database Update Tool in your workflow.

Tip: Ensure you use the "Run Process" menu to execute the workflow, and not the CRUD Add menu.

Hi Matthew,

I am actually trying to create an additional form so that new users would be able to create accounts for themselves thus removing the need for me to create new users individually. The Database Update Tool can add data to other tables other than the default ones created by Joget.

You can try to use the Directory Form Binder instead of composing your own SQL statement.

Using this method worked too but is it possible to capture the data inputted in my form to multiple database tables? Using the Directory Form Binder causes data in my Form Table to be NULL, I'm trying to get both data inputted in my Form table and dir_user.

Yes, it is possible to call multiple store binder with one set of form data. You can check out the example used in https://dev.joget.org/community/display/KBv5/Bean+Shell+Programming+Guide#BeanShellProgrammingGuide-8.Reuseexistingpluginsinyourcodetomakeitcleanerandeasytomaintain