Sign in to submit new ideas and vote
Get Started

Data Shuttle Workflow Triggered by a Workflow

With the various amounts of ideas in the community and potential implementations already in progress, who knows if this idea might become redundant at some point. But from what I've seen so far this doesn't seem to exist just yet.

I think being able to trigger a Workflow in Data Shuttle based on the execution of another Workflow(s) would be a great addition. It sounds simple enough but could potentially open up a multitude of new automation possibilities. It doesn't sound like it would be all that hard of a thing to implement either.

For context: I'm trying to develop a Learning Management System (LMS) within Smartsheet, and I've been unsuccessful in being able to automate a certain task. Our HR department provides my team with an Employee List on a weekly basis, and in order for our training Forms to have an up-to-date dropdown list, I'm utilizing a Workflow to run on attachment of said Employee List. The issue I'm running into is that I first need a Workflow to merge the new list with the existing data, and afterward update the dropdown list on our training form. Currently there only exists a "Run on Attachment" and "Run on Schedule." Which I will make due with for the time being, but this doesn't allow for us to have up-to-date employee lists without manual intervention or a delay in data.

I think having multiple triggers to a Workflow or at the very least, a cascade / order of Workflows would be a great addition to the Data Shuttle and maybe even an integration with sheet automation triggers.

17
17 votes

Idea Submitted · Last Updated

Comments

  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭✭

    Having the ability to setup an automation that can trigger a shuttle to run would be super sweet.

    Ken Armstrong

    Smartsheet Project Manager, GE Aerospace

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

  • I agree this would be very powerful addition to the automation process, I currently have the exact scenario I would like to use this on if it was made available.

  • Alex Br
    Alex Br ✭✭
    edited 09/05/24

    Instead of either manually triggering a data shuttle, or having it on a minimum 15 minute timer, make it so that it can be triggered using automation workflow. So for example, if I were to add a row into a sheet, it automatically offloads and uploads to a second sheet.

    In the absence of dynamic cascading dropdowns, I have to use data shuttle on a timer to put added/removed information into a dropdown on a second sheet. When it is added, it would be useful for everyone to be able to have it immediately available on that dropdown so in the absence of other features to allow this, and to reduce the hundreds of revised, uploaded docs to the second sheet, please make it more streamlined by allowing us to only trigger the shuttle offload/upload when a change is made.