数据表FAQs

数据表checks for any new updates and pushes them to the sheet approximately every five minutes.

It depends on how you set up your connection.

If you useAdd & Updatemode, your connection will sync data into your sheet when a record in the DataTable is added (if you checkedAdd rows as they are added to the DataTablein the connector settings) or changed (if you checkedUpdate rows as they change in the DataTablein the connector settings).

If you useLookupmode, the connection will overwrite changes made in the sheet with data from the DataTable. Your sheet will always match what’s in the DataTable. Because of this, the connection will lock the mapped columns so that people can’t edit the data.

If you use Lookup mode, the connection will overwrite changes made in the sheet with data from the DataTable. Your sheet will always match what’s in the DataTable. Because of this, the connection will lock the mapped columns so that people can’t edit the data.

Learn more about connections.

Currently, DataTable only syncs data into cells. It does not sync formatting, attachments, proofs, comments, or cell history.

数据表syncs data one-way, from your DataTable into a sheet. It does not sync changes you make in the sheet back to the DataTable.

Your sheet can fill up when the filter criteria for your DataTable connection match too many records or add additional data to your sheet.

If your sheet reaches the capacity limits of 500,000 cells, the connection will stop syncing data.

If this happens, update the filter criteria for your connection to be more specific and remove rows from your sheet.

Once you have created room in your sheet, you can enable the connection again.

Each row in the sheet will have the corresponding values mapped in based on how the connection is configured.

The connection will use the record it finds first. Typically, that will be the record with the lowest record ID.

The DataTable will overwrite existing data in the sheet cells that are mapped to the DataTable.

When you create a new DataTable, add a field and select Date as the type, and specify the date format.

The date format tells the DataTable how to parse the data in your CSV or Excel file when Data Shuttle loads data into your DataTable. The date format only affects how the dates are parsed when importing data. For example, if you select 12/31/1999, the DataTable will expect your dates to be loaded in the format mm/dd/yyyy.

如果你DataTa加载数据ble without specifying the Date format (this will be the case if you create your DataTable initially from a DataShuttle workflow), the expected date format is yyyy-mm-ddThh:MM:ssZ, e.g. 2020-09-17T00:00:00Z.

If you later change the date format, the DataTable will need a few moments to process the change before you can load data in the new format. In addition, you will need to update any records in your DataTable that have dates in the old format before they can be filtered correctly in a connection.

When you create a new connection, select a field of typeDateand then select the date with the date picker. Dates in a filter need to be in the format defined by the date picker (mm/dd/yy).

For example, if you wanted to filter to records after July 9, 2021, you would type 07/09/21. You can use the is less than, is less than or equal, is greater than, is greater than or equal, is between, is equal to, and is not equal to operators for date comparisons.

The field's date format does not change how you need to structure the dates in your filter criteria.

数据表doesn’t interpret special characters (currency symbols, commas, percentage signs, etc) as defining numeric values; it only sees those characters as part of a text string. Use decimal places to indicate currency amounts or percentages instead.

• To format percentages in your data set, use a decimal without a % symbol. For example 0.5 instead of 50%
• To format monetary values, use a decimal only. Do not 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:

1. Set the DataTable field type toNumber.
2. Send data into the DataTable with the following restrictions:
   • Strip out commas for numeric values, For example, change 1,000 to 1000
   • Convert percents to decimal format. For example, change 99% to .99 or 78.23% to .7823
   • 剔除货币符号,因为前女友ample, change $123.45 to 123.45