Bridge to update column ID in column description
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 the column number.
Is this possible?
The end state would be all columns having the their ID as per below:
Best Answers
-
Hi @Neil Watson
Great idea! Yes, this is definitely possible, and I would do it exactly as you said.
"List Columns"
Then you can use the Array from the List Columns output as the Number of Runs in your Child Workflow Module:
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.
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.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Awesome! Yes, exactly!
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
Hi @Neil Watson
Great idea! Yes, this is definitely possible, and I would do it exactly as you said.
"List Columns"
Then you can use the Array from the List Columns output as the Number of Runs in your Child Workflow Module:
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.
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.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Thanks - very clear explanation and worked correctly first try!
It's not a major issue to hard code the Sheet ID, but out of interest how do you make the sheet ID from the parent pass through dynamically to the child workflow?
-
I think I worked this out. I included the "Get Sheet"module into the parent, and then used the Sheet ID reference in a key I called "ParentSheetID".
The child trigger then contains this Key, which I use in that workflow.
Is that correct?
-
Awesome! Yes, exactly!
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 434 Global Discussions
- 153 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- Hey! This automation was working fine - but now that I've ensured that as i look to leave the company we have better owners, i can't select this sheet. They're in 2 workspaces, which wasn't a problem …
- Under the User Subscription Model, can internal collaborators designated as viewers (not members or guests), enter data into a dynamic view? Our group is still on the Legacy Collaborator Model and use…
- I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, t…
