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.
| Column Type | Output |
|---|---|
| String | Raw Data |
| Number | Raw Data |
| Integer | Raw Data |
| Date | Raw Data (in epoch time) |
| DateTime | Raw Data (in epoch time) |
| Time | Raw Data (in epoch time) |
| Single Select List | Selected Option Value |
| Multi Select List | Selected Option Values (separated by comma) |
| Checkbox | True or False |
| Userlist | Selected Users' Username |
| Formula |
| Formulas' Result |
| Sequence |
| Order | |
| Textarea | Raw Data |
| Attachment | Attatchment Download URL |
Of the previously mentioned type, the following types might need some extra effort in orther other to accuratly accurately display what they are actually supposed to represent.
...
While exporting a column which type is DateTime the time in secounds seconds (epoch time) will be exported. To get the actual date from this we can use the following script:
...