Knowledge Base > Page Editor > Actions > Remote DB Control > User Database

This action will allow the user to insert the record in the designated table of the remote database. If the user wants to insert data then the user must create a table in Remote DB. To know more about adding a table click here.

Step 1: Open a Free Layout Page.

a. Drag and drop two Label UI parts and set Title/Display Text as "Name" and "Phone No."

b. Drag and drop two TextField UI parts to enter values for "Name" and "Phone No."

c. Drag and drop two RoundButton UI parts and set Title/Display Text as "Insert" and "Show Record".

d. Browse to the "Functions" section on "Properties Palette window" of RoundButton for applying actions.

e. Click on the corresponding Edit(0) button of the Function on which user wants to apply the Action. To know more about the Functions click here.

Note: i) Also Add a DB ListView page to view data inserted to the table. For more information click here.

ii) Apply "Page Transition" to child page on "Show Record" Button on "Page1". For more information click here.

mobilous_appexe_npe_myproject_Actions_RemoteDBcontrol_remoteinsert_page

Step 2: Click on "Add" button on the Actions window to add an action. To know more about actions click here.

mobilous_appexe_npe_myproject_Actions

Step 3: Select the Actions Category as “Remote DB Control”.

mobilous_appexe_npe_myproject_Actions_category1

Step 4: Click on the "Remote DB Control" and then click on “Remote Insert” action.

mobilous_appexe_npe_myproject_Actions_RemoteDBcontrol_remoteinsert_setaction

Click here to know about "Doc" Button.

Step 5: Enter Action Parameter:-

Parameter	Description
Service Name	Select Mobilous from the Dropdown option for RemoteDB table.
Table	Select Table Name as "employee".
Record	Define the Record.Click on Add to add table field name.To know more about the record click here.
Key	Name of the field of the table in the Remote DB For e.g "e_name" , "e_phone".
Value	Name/Identifier of the TextField UI part on the page from where value has to be fetched, in square bracket i.e "[TextField1]","[TextField2]" . e.g "[name]","[phone]" as shown in the figure.

mobilous_appexe_npe_myproject_Actions_RemoteDBcontrol_remoteinsert_setparameters

Step 6: Click on "OK" button if the user doesn't want to add more actions.

mobilous_appexe_npe_myproject_Actions_RemoteDBcontrol_remoteinsert_apply

Note: Define condition if required, by clicking on "+" Condition Button on the left. Click here to know more.

Step 7: Preview to see the output.

i) Enter "Name" and "Phone No" in their respective text fields.

ii) Click on "Insert" button to add data. Click on "Show Record" button on "Page1".

iii) Data inserted is displayed on "record" page.

mobilous_appexe_npe_myproject_Actions_localDBcontrol_insert_output1