Page History

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 table has the list of types supported in this integration and the expected exported output.

Of the previously mentioned type, the following types might need some extra effort in orther to accuratly display what they are actually supposed to represent.

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

The other types contained in Table Grid Next Generation are automatically formated, or already formated once retrieved, by Xporter. No further formating is needed, but, if desired, you can still format your data by using the script tags and JavaScript.