How do I get alerted when my data shuttle workflow to update drop downs failed?
Hi - I have several data shuttle workflows to update dropdowns. They all appear to be running successfully, but then I find that a mapped value is not present in the drop-down. When I go to edit the workflow I get the following error - One or more of the columns in your target sheet are out of date. Please refresh your mapping to retrieve the latest column.". i know what is happening, the file being exported has additional columns. I would still think my column mapping should map properly, especially because it appears it is based on the run and green check. But it's not and Because I don't necessarily know when columns are added to the source file being exported, i need a way to be notified of this.
Any advice or recommendations would be greatly appreciated.
Answers
-
for more context… i have a master employee list what i'm using Data Shuttle to do is create a drop-down of employee names across various forms that have workflows. This runs nightly so as employees come and go the drop downs in the respective workflows are updated. Everything appears to be working and i'm getting the green check mark but I'm finding the new names are not added. I then investigated and find it's because the file with the employee names has changed since the mapping was created. Ideally, I'd like no one to mess with my employee list export but that will be tricky so is there a way I can get notified when this misalignment or error occurs? Even if it gave me the red ! mark vs. green check. The green check is misleading in this situation.
-
Hello @lehill,
It looks like Smartsheet just updated the Data Shuttle Error Notifications on April 25th! Make sure you're opted in to receive the notifications, but you should now get notified. Please see this article for more information!
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives