How to apply values to hidden fields during registration..
I have a few fields I'd like to populate in my MySQL database when a user registers as a member using the client_Registration.php page, also a few fields when the client_Profile.php page is updated by the new member. I've added hidden fields next to the submit button that should contain this info.
On the client_Registration.php page:
client_status - this is a hard-coded value of "new" since they are new
created_by - this would be the email address entered in the form
created_dt - this would be the date and time they are registering
ip_address - I believe I would choose REMOTE_ADDR to do this
On the client_Profile.php page that can be updated:
last_updated_by - this would be the email address on the form or the current person logged in (better be the same person)
last_updated_dt - the current date and time when the form is submitted.
Any ideas on how this would be done using Security Assist (or Form Builder for that matter)?