Integration with contractor connection job track

sarnold65456
sarnold65456 ✭
edited 06/14/22 inAdd Ons and Integrations

Has anyone had any success integrating Smart sheet with Crawford contractor connection job track application?

Tags:
· Share on Facebook Share on Twitter

通讯ents

  • Corinne Flanagan
    Corinne Flanagan Employee

    Hello,

    Thanks for reaching out! I'm not aware of any specific instances where a Smartsheet - Contractor Connection integration has been put in place, but the Community is a great place to see if other users have information on this.

    Please provide a few more details about what you're hoping to do with this integration so that others here can help.

    Thanks!

    Corinne

    · Share on Facebook Share on Twitter

Categories

Hi @Sandhiya07<\/a> <\/p>

Smartsheet Date columns can only house Dates, there currently isn't a Time function in Smartsheet. (System Columns can include timestamps, however these cannot be updated by Data Shuttle). <\/p>

If you need to see the time, make sure to map this column to a Text\/Number<\/strong> column in Smartsheet so that all of the text will appear. <\/p>

Let me know if that works for you!<\/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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":107332,"type":"question","name":"Bridge to update column ID in column description","excerpt":"Hi @Genevieve P. I am looking to develop a \"utility\" workflow that I can use when developing solutions. My idea is to use the \"List Columns\" element to gather the column ID's, and then a child workflow and \"Update Columns\" to update cycle through {{states.listcolumns.smartsheet.list_columns.data.x.column_id}} where x is…","snippet":"Hi @Genevieve P. I am looking to develop a \"utility\" workflow that I can use when developing solutions. My idea is to use the \"List Columns\" element to gather the column ID's, and…","categoryID":343,"dateInserted":"2023-07-07T11:22:22+00:00","dateUpdated":"2023-07-07T11:34:49+00:00","dateLastComment":"2023-07-10T08:19:06+00:00","insertUserID":125212,"insertUser":{"userID":125212,"name":"Neil Watson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Watson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pglbKXXltro!HIFbX6W_ivo!Lnqe5-nvNY5","dateLastActive":"2023-07-10T10:44:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":125212,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-10T12:12:21+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":42,"score":null,"hot":3377708488,"url":"https:\/\/community.smartsheet.com\/discussion\/107332\/bridge-to-update-column-id-in-column-description","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107332\/bridge-to-update-column-id-in-column-description","format":"Rich","lastPost":{"discussionID":107332,"commentID":384301,"name":"Re: Bridge to update column ID in column description","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384301#Comment_384301","dateInserted":"2023-07-10T08:19:06+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-10T12:12:21+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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\/4S2U8EC1EB5Y\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-08T07:59:43+00:00","dateAnswered":"2023-07-07T12:18:49+00:00","acceptedAnswers":[{"commentID":384131,"body":"

Hi @Neil Watson<\/a> <\/p>

Great idea! Yes, this is definitely possible, and I would do it exactly as you said. <\/p>

\"List Columns\"<\/p>

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

<\/p>


<\/p>

Then you can use the Array from the List Columns output as the Number of Runs in your Child Workflow Module:<\/p>


<\/p>


<\/p>


<\/p>

<\/p>

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


<\/p>

In your Child Workflow, all you would need to do is include the {{runtime.data.column_id}} as both the Column ID and the Column Description in an Update Column module.<\/p>


<\/p>


<\/p>


<\/p>


<\/p>

I've hard-coded the sheet ID in there but you can make that dynamic as well depending on how you're passing that through the Parent workflow. <\/p>

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

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":[]},{"discussionID":65721,"type":"question","name":"Live Data Connector to SAGE accounting","excerpt":"I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!","snippet":"I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has…","categoryID":343,"dateInserted":"2020-02-03T18:53:46+00:00","dateUpdated":"2022-06-14T14:36:40+00:00","dateLastComment":"2023-07-07T08:48:44+00:00","insertUserID":35371,"insertUser":{"userID":35371,"name":"tye.gardner35371","url":"https:\/\/community.smartsheet.com\/profile\/tye.gardner35371","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-27T20:42:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":21126,"lastUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-07T07:48:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1199,"score":null,"hot":3269478750,"url":"https:\/\/community.smartsheet.com\/discussion\/65721\/live-data-connector-to-sage-accounting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65721\/live-data-connector-to-sage-accounting","format":"Rich","lastPost":{"discussionID":65721,"commentID":384106,"name":"Re: Live Data Connector to SAGE accounting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384106#Comment_384106","dateInserted":"2023-07-07T08:48:44+00:00","insertUserID":21126,"insertUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-07-07T07:48:16+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":"2020-02-04T12:58:50+00:00","dateAnswered":"2020-02-04T07:52:54+00:00","acceptedAnswers":[{"commentID":238948,"body":"

Hi Tye,<\/p>

If I'm not misstaken, @JeremiahHorstick<\/a> has done this previously. <\/p>

I hope that helps!<\/p>

Have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/p>

Workflow Consultant \/ CEO @ WORK BOLD<\/a><\/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":[]}],"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":616,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Date with Time uploading in Data Shuttle comes only with Date

    Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P

  • Bridge to update column ID in column description

    Hi @Genevieve P. I am looking to develop a "utility" workflow that I can use when developing solutions. My idea is to use the "List Columns" element to gather the column ID's, and then a child workflow and "Update Columns" to update cycle through {{states.listcolumns.smartsheet.list_columns.data.x.column_id}} where x is…

  • Live Data Connector to SAGE accounting

    I was reading up on data connectors to 3rd party platforms such as Excel, Access, etc. but didn't see any information about accounting systems such as Sage or Quickbooks. Has anyone ever linked an accounting systems to Smartsheet? I am assuming it is possible, but I want to gather other's experiences if they have. Thanks!

Enter to Win a FREE Conference Pass to ENGAGE 2023

 了解更多