Is there a way to tell Data Shuttle to upload the most recent file in a folder on Google Drive? Or can it only point to a specific file name as defined in the upload workflow builder?
Hi @Matthew_Lanterman ,
As outlined here, source files can be sourced from Smartsheet and external cloud locations such as Drive. However, the "most recent" sync feature is currently only available for attachments stored in Smartsheet. For that reason, when you have a moment, please let our Product team know about your feedback by filling in this form, here. Thank you!
I hope that this can be of help!
One way of doing this is to use zapier to watch the folder. Each time a new file is added to the folder, copy the file to a file called "Latest File". Then have the data shuttle use "Latest File" for it's input.
Hi @Julio S.
Thank you for the information. I submitted my feedback.
Do you know if Data shuttle uses a unique URL for each file in Google Drive as the identifier? Or does it look for the file name in the folder?
I ask because if it uses the URL identifier, I have to re-map the columns each time I want to run the upload workflow, and that essentially defeats the purpose of Data shuttle for this workflow. If Data shuttle looks for the file name in the folder location, then all I have to do is save a new copy of the file, and rename it.
Hi @marc4 , we do not have a zapier account, but that is a great suggestion! Thank you.
You can do it with the free level.
Note that Data Shuttle can tell if there is a 'most recent' file if:
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is this by design? If by design I vote for an update.
Hello, I am looking to leverage the Conditional Junction: Junction Match module to set a variable to ultimately decide which path to take. Taking a step back, I have 4 of the same 'When Column is Changed' triggers, which are attached to different smartsheets. Based on which smartsheet the trigger is associated with, I am…
Hello. I am a newer user of Smartsheet and am trying to identify an easy way for multiple contributors around our org to update data in a source sheet. Here is an outline of our scenario: We collect high level data of projects from around the Org in a "Combined Project List" sheet We would like to minimize access to this…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.