Stamp a Record with User Profile Data

After you have enabled Web User Authentication you can stamp all new records with user profile data from the authentication table.  This is often the first step to creating Record Level Security because all new records will be automatically associated with a user or group.

Steps to stamping records with user profile data:

1.   Enable Web User Authentication 

In order to stamp records with information from the authentication table you need to have Web User Authentication enabled.

2.   Mark the field as Hidden

In the Caspio Bridge Explorer window go to the DataPage view.  Select the DataPage that will stamp records and open the DataPage wizard by pressing the Edit button.  Proceed to the Select Fields screen.  In a Web Form there is only one Select Fields screen, but in a Search and Report DataPage we will want to proceed to the Select Details Page Fields screen because this is the only page where data can be edited and input into hidden fields.  Include the field where you want to store the user profile data by moving it from the left panel to the right-hand panel using the arrow button.  Click Next.   Select the field where you want to store the user profile data.  Using the Form element dropdown, select Hidden.

3.  Choose the field from the Authenticated field dropdown

Two radio buttons will now be visible in the Field Options section.  Click on Authenticated field.  In the dropdown field you will see all of the available fields from the authentication table.  If the authentication table and the base table field’s data types are not compatible, the authentication table field will not be visible in this dropdown.  Select the field you would like to save.  Press Finish to save your DataPage.  Now when a record is created by this DataPage (or edited in the case of details pages) this hidden field will be automatically stamped with the user profile data you selected.