By using custom fields on your Grid setup it is possible to setup a custom capture for any data captured by each cell. The functions available and their parameters are broken down as follows:
Copy Column (Column Name)
This function will copy the data in each row of the selected column. It is basically creating an exact copy of the selected column.
Using this function you will copy only the last line of the data on each row of the selected column removing all the other lines of data from each cell. Don't forget to set "Remove Carriage Return" to "No" on the column you want to copy data from. When the column you want to copy data from only have one line of data on each row this function will not return any data.
This function will copy the entire first line of the target column. Keep in mind that the "Remove Carriage Return" option from the target column must be set to "No".
This function will copy the desired line from the target column. Keep in mind that the "Remove Carriage Return" option from the target column must be set to "No".
This function will copy the last line from the target column. Keep in mind that the "Remove Carriage Return" option from the target column must be set to "No".
Using this function you will carry over only the first line of the data on each row of the selected column removing all the other lines of data from each cell. Don't forget to set "Remove Carriage Return" to "No" on the column you want to cut data from. When the column you want to cut data from only have one line of data on each row this function will return the entire cell.
When using a Cut function the data will be cut from the original column.
This function will carry over only the selected line of the data on each row of the selected column. For this function line 0 is the first line, line 1 is the second line and so on. If you select line 0 on a column without lines the entire cell will be carried over, if you select line 1 no data will be carried over. Don't forget to set "Remove Carriage Return" to "No" on the column you want to copy data from.
When using a Cut function the data will be cut from the original column.
Cut to Left of Reference (Column Name, Reference String)
By using this function only the number of characters from the left of the text will be carried over to the custom field. Selecting 10 characters will carry over only the first 10 characters of each row.
When using a Cut function the data will be cut from the original column.
This function can be used to cut the left most word from the source column. A word is considered a group of characters until the first space or new line.
By using this function only the number of characters to the right of the text will be carried over to the custom field. Selecting 10 characters will carry over only the last 10 characters of each row.
When using a Cut function the data will be cut from the original column.
Cut Text and Tags (Source Column, Start Tag|End Tag)
By using this function the selected tags and the data between those tags will be carried over to the custom field. The tags will be included in the custom field.
When using a Cut function the data will be cut from the original column.
Cut Text Between Tags (Source Column, Start Tag|End Tag)
By using this function only the data between the selected tags will be carried over to the custom field. The tags will be removed from the source and the target columns.
When using a Cut function the data will be cut from the original column.
This option should be setup on the Current Type Option section of the field. The field Type should be changed to custom and this function should be selected. This way, every time a row is empty, the previous row value will be copied over to it.
