Exporting task link

Hi,

I am trying to export a list of tasks to excel including shotgun links to open those tasks but I can’t seem to figure out a way to do it. Any suggestions?

Cheers
Rohit

YES! We use the URL Template field to copy links out of Shotgun into Slack & other stuff so folks can go directly to versions & notes, so I’m sure you can use the same trick on Tasks.

Set up a field on Tasks that is a URL Template, and export the information to Excel that way. The field set up would look like this:
https://YOURSTUDIONAME.shotgunstudio.com/detail/Task/{id}

And then in Excel it looks like this:
https://YOURSTUDIONAME.shotgunstudio.com/detail/Task/12345
https://YOURSTUDIONAME.shotgunstudio.com/detail/Task/12346
https://YOURSTUDIONAME.shotgunstudio.com/detail/Task/12347

I don’t know enough about Excel to tell you how to make that text into hyperlinks but I’m sure someone out in the world wide web has posted a how-to for that part.

2 Likes

Thanks Jessica, that worked!

1 Like