Page History

...

The identifier can be the same as the column name, but it can also have some other value. The column ID used in the example above is the "Identifier" used while creating the Table Grids' column. This identifier can also be verified in the list of columns present in the Table Grid between parenthesis.

Column Types

In Table Grid Next Generation a column can be one of many types. This types are defined while creating the table and will not have any impact while exporting data. However, since Xporter does not know the type of each of the fields retrieved from Table Grid Next Generations, in some cases, additional formatting might be needed. The following types are the ones that might need this extra attention.

DateTime

While exporting a column which type is DateTime the time in secounds (epoch time) will be exported. To get the actual date from this we can use the following script:

// You need to replace TABLE_NAME with your Table Grids' name.
#{for n=TableGrid.TABLE_NAMECount}
	// Replace the TABLE_NAME with the Table Grids' name and DATETIME_COLUMN with the column id.
	DateTime: %{var date = new Date(${TableGrid.TABLE_NAME[n].DATETIME_COLUMN}); date.getFullYear() + '/' + (date.getMonth() + 1) + '/' + date.getDate() + ' ' + (date.getHours() - 1) + ':' + date.getMinutes()}
#{end}

Date

The Table Grids type Date will, once again, export the time in seconds, but this time without the time component. We can format the retrieved value by using a script like the one represented in the following example:

// You need to replace TABLE_NAME with your Table Grids' name.
#{for n=TableGrid.TABLE_NAMECount}
	// Replace the TABLE_NAME with the Table Grids' name and DATE_COLUMN with the column id.
	Date: %{var date = new Date(${TableGrid.TABLE_NAME[n].DATE_COLUMN}); date.getFullYear() + '-' + (date.getMonth() + 1) + '-' + date.getDate()}
#{end}

Time

The Time type will return the time as the number of seconds since January 1st 1970 (the epoch time). We can format the retrieved value by using a script like the one represented in the following example:

// You need to replace TABLE_NAME with your Table Grids' name.
#{for n=TableGrid.TABLE_NAMECount}
	// Replace the TABLE_NAME with the Table Grids' name and TIME_COLUMN with the column id.
	Time: %{let date = new Date(${TableGrid.TABLE_NAME[n].TIME_COLUMN}); (date.getHours() - 1) + ':'+ date.getMinutes()}
#{end}

Boolean

The Boolean type will retrieve only 2 simple values, true or false. We can format the retrieved value by using a script like the one represented in the following example:

// You need to replace TABLE_NAME with your Table Grids' name.
#{for n=TableGrid.TABLE_NAMECount}
	// Replace the TABLE_NAME with the Table Grids' name and Boolean_COLUMN with the column id.
	Boolean: %{${TableGrid.TABLE_NAME[n].BOOLEAN_COLUMN} ? 'Checked' : 'Not Checked' }
#{end}

Other Types

...

Sample Table Grid Export