wild cards in DataShuttle
In the source sheet section, is there anyway to use a wild card in the Attachment Name?
I have two exports that have a consistent file name at the beginning, but an inconsistent name at the end because it includes a date time stamp, so it would be very helpful to have a wildcard option here.
Best Answer
-
There currently isn't a wildcard option for the file name - please submit your feedback to the Product team, here!
I would suggest choosing the attachment by "Most Recent" instead of Name, if the name will vary.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
There currently isn't a wildcard option for the file name - please submit your feedback to the Product team, here!
I would suggest choosing the attachment by "Most Recent" instead of Name, if the name will vary.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you @Genevieve P. for your response. I will submit feedback.
Currently there are two datasets (and there will more) for this process, so by using most recent instead of specifying a file name means that I need an input sheet for each dataset. I know that's not a huge issue, but I always try to build as efficiently and simple as possible, so that's why I asked about wildcards.
As it is, I've created one intake sheet with a form. The user will select the dataset from a drop down and attach/submit. The intake sheet will automatically move that row to the correct import sheet based on the dataset selected on the form, then DataShuttle then kicks in to import the data into the appropriate sheets where the data needs to reside. With wildcards, the extra step to move and additional import sheets are eliminated.
I try to find the shortest path, but the beauty of smartsheet is there is always a way to get things done.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives