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 DataText |
| Number | Raw DataNumber |
| IntegerRaw | DataWhole Number |
| Date | Raw Data Date (in epoch time) |
| DateTime | Raw Data and Time (in epoch time) |
| Time | Raw Data 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 | Raw DataText |
| Attachment | Attatchment Attachment Download URL |
Of the previously mentioned type, the following types might need some extra effort in other to accurately display what they are actually supposed to represent.
...