Is it possible to dynamically add triggers from Smartsheet to a bridge workflow?

ronhay
ronhay ✭✭✭
edited 09/27/23 inAdd Ons and Integrations

I have finally gotten my first bridge to Smartsheet workflow working. My workflow copies project plan baseline dates to an original baseline field the first time a baseline is set, and then will not set it again.

This works when I manually setup a trigger in bridge for a specific project plan sheet. However, I have 75 projects provisioned via control center and I don't want to have to manually setup a new trigger when each project gets provisioned. I would like those triggers to be dynamic if possible.

Is there any way to achieve this?

Tags:
· Share on Facebook Share on Twitter

Best Answer

  • ronhay
    ronhay ✭✭✭
    Answer ✓

    Since I don't think there is a way to do this currently, I went a different direction and setup a trigger to run daily and get a handle to the workspace that we provision all projects to, iterated through the list of folders, iterated through the sheets to identify the project plans, and continued the logic from there.

    Would be nice to have a feature that enables provisioning triggers to new projects via Control Center.

    · Share on Facebook Share on Twitter

Answers

  • ronhay
    ronhay ✭✭✭
    Answer ✓

    Since I don't think there is a way to do this currently, I went a different direction and setup a trigger to run daily and get a handle to the workspace that we provision all projects to, iterated through the list of folders, iterated through the sheets to identify the project plans, and continued the logic from there.

    Would be nice to have a feature that enables provisioning triggers to new projects via Control Center.

    · Share on Facebook Share on Twitter

Categories

Support just let me know that this issue was resolved!!!<\/p>

I tested this with Source as Box and as Excel attachments and blank values now update!!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":112131,"type":"question","name":"How to get filters in Workapp page settings?","excerpt":"Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in workapp but nothing show in the filter section. Thanks you","snippet":"Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in…","categoryID":343,"dateInserted":"2023-10-25T14:52:14+00:00","dateUpdated":null,"dateLastComment":"2023-10-27T16:15:04+00:00","insertUserID":144572,"insertUser":{"userID":144572,"name":"Kimbh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-29T18:06:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":144572,"lastUser":{"userID":144572,"name":"Kimbh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-29T18:06:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":36,"score":null,"hot":3396670038,"url":"https:\/\/community.smartsheet.com\/discussion\/112131\/how-to-get-filters-in-workapp-page-settings","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112131\/how-to-get-filters-in-workapp-page-settings","format":"Rich","tagIDs":[371],"lastPost":{"discussionID":112131,"commentID":402041,"name":"Re: How to get filters in Workapp page settings?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402041#Comment_402041","dateInserted":"2023-10-27T16:15:04+00:00","insertUserID":144572,"insertUser":{"userID":144572,"name":"Kimbh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-29T18:06:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png"},"alt":"WorkApp 10 25 2023.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T16:19:48+00:00","dateAnswered":"2023-10-27T14:00:51+00:00","acceptedAnswers":[{"commentID":402014,"body":"

Hey @Kimbh<\/a> <\/p>

In order to get a Filter to show in your Workapp settings, it would need to be a shared<\/strong> filter in the source sheet, with the \"Share filter\" box checked:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Let me know if that resolved your problem!<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":371,"urlcode":"workapps","name":"WorkApps"}]},{"discussionID":112176,"type":"question","name":"Very Small Sheet causes \"Error! Failed to issue the request,","excerpt":"I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue the request, please relogin and try again. Error code: 0 - Error message:error This only happens one direction. I can datamesh from Sheet A to…","snippet":"I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue…","categoryID":343,"dateInserted":"2023-10-25T22:34:58+00:00","dateUpdated":null,"dateLastComment":"2023-10-26T23:17:42+00:00","insertUserID":137486,"insertUser":{"userID":137486,"name":"Jack Swaton","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20Swaton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pLNVKZdwrDo!iVjUIgyE8TY!VkziYQqavjR","dateLastActive":"2023-10-27T16:43:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-10-29T23:19:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3396637960,"url":"https:\/\/community.smartsheet.com\/discussion\/112176\/very-small-sheet-causes-error-failed-to-issue-the-request","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112176\/very-small-sheet-causes-error-failed-to-issue-the-request","format":"Rich","tagIDs":[381],"lastPost":{"discussionID":112176,"commentID":401948,"name":"Re: Very Small Sheet causes \"Error! Failed to issue the request,","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401948#Comment_401948","dateInserted":"2023-10-26T23:17:42+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-10-29T23:19:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-26T22:25:03+00:00","dateAnswered":"2023-10-26T22:24:34+00:00","acceptedAnswers":[{"commentID":401942,"body":"

SOLVED!!!<\/p>

I wanted to use my target sheet with Resource Management so I turned DEPENDENCIES on in the PROJECT SETTINGS. <\/p>

My DataMesh was trying to update the START and END dates (which now were driven automatically in the target sheet) from the source sheet so Smartsheet could not update cells which were automatically updated.<\/p>

Once I turned DEPENDENCIES off in the target sheet my DataMesh worked just fine.<\/p>

:)<\/p>

Jack<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":381,"urlcode":"datamesh","name":"DataMesh"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":715,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Data Shuttle not updating blank values from source file?

    Anyone else having this issue? All the Data Shuttles that I set up, are not anymore been bringing data to Smartsheet from cells that have changed to being blank in my Source Location. This was discovered yesterday, 10/17, when I received many reports from colleagues that work on different sheets that the data shuttle…

  • How to get filters in Workapp page settings?

    Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in workapp but nothing show in the filter section. Thanks you

  • Very Small Sheet causes "Error! Failed to issue the request,

    I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue the request, please relogin and try again. Error code: 0 - Error message:error This only happens one direction. I can datamesh from Sheet A to…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video