DataTable Connection fails to transfer records when filter conditions change due to time passing
Hello,
Some or all DataTable Connections do not automatically transfer data to the destination sheet under this condition:
- Filter: <Field name> is greater than <#> days from today
- Today the filter shows no result
- The next day, the sheet shows no data but the filter shows there should records transferring.
If you manually refresh the DataTable Connection, the records transfer.
Have been talking to support for 70 days, since Nov 17 2023, with no resolution. Had to do about two months of self troubleshooting and follow ups before they would believe it as an issue and investigate. Apparently it affects multiple people from multiple organizations. It appears that function in DataTable Connection has failed and remains failed.
Here are screen shots of the conditions.
Actual DataTable Connection setting showing no rows to transfer for today
Today in the screenshots is Jan 24, 2024.
Note there are no records on the sheet in the background.
Setting showing rows should transfer tomorrow
Today in the screenshot is Jan 24, 2024.
Note there are no records on the sheet in the background.
Screenshots from the next day. Filter shows record show transfer but the sheet is empty
Today in the screenshots is Jan 25, 2024.
Note the empty records on the destination sheet in the background.
Regards,
Neil Egsgard
Answers
-
I have checked in with Support and they informed me they're actively working on this case with you; at this time Engineering has implemented a fix on February 16th for what you (and others) were experiencing so this should be resolved! If you're still seeing unexpected behaviour, please keep following-up on that Support ticket with the new information.
Thank you,
Genevieve
-
Hi Genevieve,
We are testing to see if it is resolved. I will post here when it is fixed.
-
The issue has been resolved by Smartsheet Support and the DataTable connections work as they are supposed to work.
