...
| Code Block |
|---|
| title | Table Grid Iteration |
|---|
| collapse | true |
|---|
|
// You need to replace TABLE_NAME with your Table Grids' name.
#{for n=TableGrid.TABLE_NAMECount}
// Table Grid fields will go in here.
#{end} |
...
| Code Block |
|---|
| title | Table Grid Iteration Row Count | collapse | true |
|---|
|
// You need to replace TABLE_NAME with your Table Grids' name.
${TableGrid.TABLE_NAMECount} |
...
| Code Block |
|---|
| title | Table Grid Iteration Column | collapse | true |
|---|
|
// 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 COLUMN_ID with the column id.
${TableGrid.TABLE_NAME[n].COLUMN_ID}
#{end} |
...
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:
| Code Block |
|---|
| title | DateTime Formating Example |
|---|
| collapse | true |
|---|
|
// 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}
|
...
The Table Grids type Date will, once again, export the time in secoundsseconds, 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 |
|---|
|
// 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} |
...
The Time type will return the time as the number of secounds 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 |
|---|
|
// 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} |
...
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 |
|---|
|
// 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} |
...