how to use "Insert action"

[Former Member]

Hi, experts:

I am facing one problem.

I try to use system action "insert action" to insert a new row into table view from a form view,

I have assign "To" to the target table in the Insert action properties.

When test program, table view did add a new row after click insert button in the form view, but all cell value are blank.

Any hints would be very appreciate.

Thanks.

Best regards,

Nick.

[Former Member · Accepted solution]

Hi Nick,

I think you are trying to use the fields on the From View to insert the rows with those values in the table View using the 'INSERT' action. You have also configured the 'TO' field of the 'INSERT' action to point to your Target Table View.

By default the INSERT Action will insert a blank row. In order to populate the values in the table, do the following:

1.Right Click your Target Table View.

2. Select 'Define Data'

3. For each field in the table set the default value to the corresponding field from the source 'Form view'

For doing this Double Click the 'fx' button in the Default Value column

Open 'Data Fields'

Open Your Source Form view

Double Click the required field

Clcik Ok

3. Save, Compile and Deploy the Application

Regards,

Ajay

[Former Member · Accepted solution]

Hi, Ajay:

Thanks for your valuable response to help me resolve my problem.

I missing last step to set default value for every column in the table view.

Thanks.

Best regards,

Nick.