...
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.
DateTime
While exporting a column which type is DateTime the time in seconds (epoch time) will be exported. To get the actual date from this we can use the following script:
| Code Block |
|---|
| title | DateTime Formating Example |
|---|
| collapse | true |
|---|
|
// 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()}
|
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:
| Code Block |
|---|
| title | Date Formating Example |
|---|
| collapse | true |
|---|
|
// 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()}
|
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:
| Code Block |
|---|
| title | Time Formating Example |
|---|
| collapse | true |
|---|
|
// 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()}
|
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:
| Code Block |
|---|
| title | Boolean Formating Example |
|---|
| collapse | true |
|---|
|
// 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' }
|
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.
Sample Table Grid Export