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 | Template Output |
|---|---|
| String | Text |
| Number | Number |
| Integer | Whole Number |
| Date | Date (in epoch time) |
| DateTime | Data and Time (in epoch time) |
| Time | Time (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 | Text |
| Attachment | Attachment Download URL |
...