I am currently working on connecting a database table to a Squiz custom form. What I am trying to do is based on a query (lookup logged in user), output some fields into a form (e.g. organisation area, position etc.)
I have a separate database (MySQL) which houses a table with information based on username.
Users log into our online form and the basic global attributes are available (first/last name, username, email)
I understand I will need a DB connector (data source?) but am struggling with how
- I can use the logged in username to query the database - in query builder it didn’t work using the global key replacement
- Using the retrieved information from the database and adding it as a default value into form fields
Part of the reason I’d like to have the content added to form fields is in case there is a need to make alternations e.g. add to the existing content.
Any help/guidance would be appreciated