Hi All
I have created a new Apex application and have created a table with columns - USER_ID, ADDRESS, PHONE, CREATEDON etc
I want to read the USER_ID of the logged in user and populate this field on the form and populate the CREATEDON field with the system date. These two fields are hidden on the form.
Now when the user fills his address and phone on the form and clicks submit, 3 identical rows are inserted in the DB table. The values of logged in user and system date are successfully set.
To set the USER_ID field, I have inserted $APP_USER. in the default value section of the form. I am not able to understand, why Apex is inserting multiple rows even when the submit button is clicked once.
Please help.