This guide helps you if you have issues navigating DataTable.
Troubleshooting DataTable
What happens if my sheet fills up?
Your sheet can fill up when the filter criteria for your DataTable connection match too many records or add more data to your sheet.
- If your sheet reaches the (legacy) capacity limit of 500,000 cells, the connection stops syncing data.
- If syncing fails, update the filter criteria for your connection to be more specific and remove rows from your sheet.
Once you create room in your sheet, the connection resumes automatically.
For a lookup mode connection, what happens if there are multiple rows in my sheet with the same unique identifier?
Each row in the sheet displays corresponding values mapped according to your connection configuration.
For a lookup mode connection, what happens if there are multiple records in my DataTable with the same unique identifier?
The connection uses the first record it finds.
For a lookup mode connection, what happens if I change the unique identifier in my sheet?
The DataTable overwrites sheet cells mapped to it
How do I create a date field in my DataTable?
How you create a date field in DataTable depends on how you created the DataTable:
- When creating it from a Data Shuttle workflow, the source file must use the ISO date format e.g. 2020-09-17.
- When creating it from scratch, you can specify the date format after selecting the Date type. This format must match the date in your source file.
If you have problems filtering against your date format, you may need to modify it. This can be done when the DataTable is created and populated via the Settings tab in the DataTable dashboard.
How do I filter based on a date field in my DataTable?
Select the field type Date and then choose the date with the date picker, using the format mm/dd/yy. For example, to filter records after July 9, 2021 use 07/09/21. For date comparisons, you can use operators like less than, greater than, between, equal to, and is not equal to.
The In the Next/Last N days filter option excludes the current day. To address this, use the filter option from today/tomorrow/yesterday. This includes today's date in the relative date filter criteria if desired.
Why are my numbers importing as text instead of numeric values?
DataTable doesn’t interpret special characters like currency symbols or commas numeric values. DataTable sees those characters as a text string.
To avoid that, use decimal places to indicate currency amounts or percentages instead.
- To format percentages, use a decimal without a % symbol. For example, 0.5 instead of 50%
- To format monetary values, use a decimal only. Don’t use a comma or any currency symbols. For example, 15000.00 instead of $15,000.00 or 15,000.00
To have your data appear on sheets as numbers
- Set the DataTable field type to Number.
- Send data into the DataTable considering:
- Strip out commas for numeric values. For example, change 1,000 to 1000
- Convert percents to decimal format. For example, change 99% to 0.99 or 78.23% to .7823
- Strip out currency symbols. For example, change $123.45 to 123.45