-
Data Shuttle not deleting rows
Hi all, Im new to data shuttle, implementing my first workflow.. overall its working fine, but what its not doing is deleting records when I attach new data to my source sheet. The scenario is, the source sheet contains a row thats not in the updated data. My expectation is when data shuttle runs it finds a target row…
-
Connect Data Table to multiple sheets, Bridge, or Salesforce
It would be nice if we were able to import information from sheets, Bridge, or a connector to a Data Table. We have a sheet that was created via multiple imports from Salesforce. We would like to add more information to it but because of Cell limits we are unable to. It would be helpful if we could setup a connector from…
-
When I upload a smaller file to my Data Table will it remove the old data if it exceeds the new?
Hello,, I'm figuring out data tables slowly and a question I have is if i upload a csv with 200k rows to my data table, then i turn around and upload the same file but it only has 150k rows, will it delete the extra 50k? thanks, Spencer
-
DataTable Run Errors
I'm trying to pull from a DataTable, but I keep getting this error message: I've tried to delete and rebuild the connection, but I'm not having any luck. Is it some type of server error, or is it another type of issue?
-
Assistance connecting document to dropdown in intake form
We would like to use the form capabilities on project sheets to prepopulate dropdown fields with preselected information from source documents or sheets that live in the same project folder. Example - if a person is updating a specific deliverable, to ensure the naming convention and correct deliverable is selcted and…
-
Multiple columns using same datatable to lookup values
Hello everyone, I have a sheet that stores part numbers / stock codes. There are 5 columns that have a part number. The "master" part number list has 45K records, and I have successfully stored this as a datatable. I have also linked this datatable to one column in my sheet, using the stock code, to look up the…
-
Merged: Validation Phone Prefix is missing for many countries
This discussion has been merged.
-
Data Table not showing data
Hi all, I'm trying to add data to a new Data Table. When I run a workflow through Data Shuttle it says 506,233 rows have been added (see image) but in my DataTable is says "There's Nothing Here" (see image 2). Any ideas?
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…
-
Be able to Store Comments, Attachments, Etc... in DataTable
I currently have a need to archive off records from a Smarthsheet to a DataTable that includes comments. Having the ability to include Comments, Attachments, Etc... in DataTable as well would allow use to archive several years of information into one DataTable repository would be a huge benefit.
