Can I link to an external Excel sheet in a macro?

Respondida

8 Comentarios

  • Pedro Rodrigues
    Community Moderator

    Hi Taha, what's the formula you're using, and how is data defined in the sheet?

    Let's say you have the macro IDs in column A, starting at A2, whose first macro ID is 123456789.

    To generate the URL you'll need to add the following formula to B1 (for example)

    ="https://yoursubdomain.zendesk.com/agent/admin/macros/"&A2

    Alternatively, you can use the hyperlink() formula (as in C1 below):

    =HYPERLINK("https://yoursubdomain.zendesk.com/agent/admin/macros/"&A2,"View macro")

    Hope this helps

    0
  • Taha Elaraby Taha

    Hi Pedro,

    I really appreciate your response.

    If I clicked on View macro in C2, It will direct me to a blank macro, not with the macro details which I added before. I need the link to redirect me to the ticket which contains the macro details.

     

    Regards

    Taha

    0
  • Pedro Rodrigues
    Community Moderator

    That's odd, the ="https:// yoursubdomain. zendesk .com/agent/admin/macros/"&A2 formula should open the macro page, since the macro ID is in cell A2.

    To get a blank macro page the formula would have to be ="https:// yoursubdomain. zendesk .com/agent/admin/macros/new".

    Could you please share the formulas you're using?

    0
  • Taha Elaraby Taha

    This is the macro which I want to be redirected to it once I click on the macro link: 

    The Macro Link: 

    The excel Link:

    0
  • Taha Elaraby Taha

    The ="https:// yoursubdomain. zendesk .com/agent/admin/macros/"&A2 is directing me to the Macro page without the new ticket. The point is I need to be redirected to a new ticket which contains the macro details in the same time

    0
  • Pedro Rodrigues
    Community Moderator

    Thanks for that!

    The .../tickets/new/1 URL is a new ticket page, not a macro page, which looks like .../agent/admin/macros/123456789.

    Perhaps I'm not fully understanding your request..? Just to review what I had understood:

    • You created a macro at .../agent/admin/macros/new, which generated a macro ID
    • This macro can be accessed at .../agent/admin/macros/[ID]
    • You'd like to have a spreadsheet with all your macros + links to each of them

    If your question is about a link that opens a new or existing ticket ID and that applies that macro on open, then I don't believe this is possible. Macros must be manually applied to tickets (there isn't a URL that can pre-fill it).

    0
  • Taha Elaraby Taha

    Thank you for your prompt reply.

    I really appreciate that, but if there any chance to have a feature or option to get a link that will open a new ticket with the macro applied on open it will be great.

    0
  • Dan Cooper
    Community Moderator

    Hi Taha, 

    That's an awesome idea.  You can post it in the Product Feedback and Discussion forums where Zendesk Product Managers keep an eye out for the features the community is looking for.  If you can take the time to share your use case, it gives others a chance to see it and add to your voice and make it more likely to happen.

    0

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk