Insert constant value or submission date

Previous  Top  Next

You can enter a constant value in the destination database. The same constant value will be placed in the desired column each time a respondent completes a survey.

For the string data type, the following actions are available:

1.	Insert string value: Enter the value that you wish to insert in the right pane.

2.	Insert numeric value: Enter the numerical value that you wish to insert in the right pane.

3.	Insert date: Choose the date you wish to insert from the date picker or enter it manually. You can also choose the special value <<DateParticipated>>. If you choose this option, the date at which the respondent completes the survey will be used.

4.	Insert boolean value: You can choose to enter the value true or false here.

For the number data type, the following actions are available:

1.	Insert numeric value: Enter the numerical value that you wish to insert in the right pane.

2.	Increase with value: If the operation type is update, this action will increase the number that is present with the desired value. You can enter the amount by which the present number should be increased in the right pane.

3.	Decrease with value: If the operation type is update, this action will decrease the number that is present with the desired value. You can enter the amount by which the present number should be decreased in the right pane.

The actions increase with value and decrease with value are only present when the operation type is update.

For the date data type, the following action is available:

1.	Insert date: Choose the date you wish to insert from the date picker or enter it manually. You can also choose the special value <<DateParticipated>>. If you choose this option, the date at which the respondent completes the survey will be used.

For the boolean data type, the following action is available:

1.	Insert boolean value: You can choose to enter the value true or false into the destination field.