This solution copies all attachment names from a source row and adds one row for each attachment name onto a target sheet. Each target row contains one attachment name and the source row primary key. The solution uses a Child Workflow to get individual data values from an array in the Parent Workflow. The solution is very…
Hi, I refer you to Bridge: Smartsheet | Get Attachment article. The Get Attachment module returns useful information like: Attachment Type Created At Created By Email Name ID (of attachment) Mime type Name Parent ID Parent Type Size in Kb URL URL Expires in Milliseconds It returns the URL which allows users to download it.…
I am trying to build a help chatbot that our team members can use to quickly find help docs on various topics/processes. For example the chat would look something like this - If you answer yes I want the chatbot to loop back to the very start and clear any history from the previous questions/answers, and if you answer no…
I have an issue where my Bridge job flow has an error when processing changes on my workflow. The Source/trigger Smartsheet is created from a Datashuttle job that converts an uploaded Excel file to a Smartsheet file. This is the trigger file for this workflow. After the upload, there will be 1500 + changes and new rows…
Make it possible for Bridge to hand files as variables and results from actions. The example being a SharePoint API call returns a file that will then exist in the reference data of that complete action. This file/reference could then be used in future actions such as another API. My scenario required the use of the…
Hi, I'm trying to manage some automated attachments of files to rows in Smartsheet. I've gotten to the point of retrieving the file from its source and am ready to upload it to a Smartsheet row via API. I also have this API request working in Postman. Where I am struggling is when I try to implement this API request in…
Hi - I am trying to follow the instructions on how to copy partial rows to another sheet using a Bridge workflow (https://help.smartsheet.com/articles/2482720-copy-partial-rows-using-Bridge). I'm not getting very far before hitting a run log error. I've included the error and the step where it's occurring. I've tried using…
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…
I'm looking for some help on how to extract particular data from a JSON response from an external API call made with Smartsheet Bridge. The API call is working fine, and I'm getting the JSON response. Part of the response is an indexed set of data within the response, that includes HTML formatting tags. I'd like to strip…
I am using Bridge to try and pull information from a Resource Management report into a SmartSheet. Today I have an admin do this manually, but I would like to automate this so that it can be completed manually. I have the report running in Bridge and it is returning 34 items which is expected. I know that I need to then…