Skip to main content
Question

Is there a way to easily combine text from multiple stickies using APIs?

  • November 15, 2021
  • 2 replies
  • 301 views

Mishal
Forum|alt.badge.img+5

I have a Jobs to be done exercise and need to summarise each job at the end of the activity.

 

All the text from the yellow stickies into the pink stickies. Any advice on best way to do this (even if it involves using developer APIs etc)

Was it helpful?

2 replies

Max Harper
Forum|alt.badge.img+6
  • Miro Hero
  • 374 replies
  • November 15, 2021

@Mishal

Its not immediately available, but super doable. 

MANUALLY:

Once I built an excel or google sheet with formulas, I can run the whole process in less than 1 min. (watch end of video): 

  • Make a 3byX array of selectable objects.
    • Make the sentence stems(prompts at top) selectable (unlocked).
  • Select only the headers and the response sticky notes. 
  • Align objects perfectly using the Autoformat tool: (while you have board items 
    •  

  • Right click on your board selection and select “Export to CSV” from the menu. 
  • Open that CSV. Copy the 1 col of data and paste into your (pre-formula’ed) concatenator excel or google sheet. 
  • Select the pink col, copy and paste back into board. 
  • Use the above ‘Autoformat’ tool to get back to a 3 wide array and lasso select off the blanks. Voila! 

https://www.loom.com/share/d4db55ebfdd74bd0a76ff26aebb3e62e

 

Concatenator google sheet.

https://docs.google.com/spreadsheets/d/1z-tme3shlTBDO1MiLyWV4a2cfxZgczk6un8W_C-7ZLI/edit?usp=sharing

 

 

 


Mishal
Forum|alt.badge.img+5
  • Author
  • Group Leader
  • 74 replies
  • November 15, 2021

Wow. Thanks for the detailed walkthrough and making the time and effort to go the extra mile with recording it. I appreciate it :grinning:


Reply