Add a clickable image / button with a specific link for each recipient

Comments

6 comments

  • Avatar
    Fanibio Pitasse
    Can I use this feature after submitting a form, or do I need to manually fill in the column?
    3
    Comment actions Permalink
  • Avatar
    Tom Kalinoski

    What if I want the link to be dynamic based off of another value in the row.  I'm trying to use an if statement, but it isnt working.

    1
    Comment actions Permalink
  • Avatar
    YAMM Team

    @Tom Kalinoski

    YAMM has hard time processing multiple functions and different syntax (such as inserted variables from different cells). We are aware of the issue and it will be resolved as soon as possible.

    Sorry for the inconvenience caused.

    1
    Comment actions Permalink
  • Avatar
    Alena Sitnikova

    What if my picture is the same, but link is different for each client? Can I insert picture in the body of the email first, but change link from eamil to email? 

    Its a header for edm so when im inserting picture in the body of email  I can make necessary adjustments 

     

    0
    Comment actions Permalink
  • Avatar
    Delphine Leroy

    Hi Alena Sitnikova

    Sorry, this option is not possible. If you want to use the same clickable picture with different link, you will have to add it on each row.

    Thank you for your understanding

    0
    Comment actions Permalink
  • Avatar
    Tom Kalinoski

    Solved!

    I approached this a little differently.  The URL for my destination and image aren't statically defined, rather they come from other locations within the sheet.

    =ArrayFormula(If(isblank($A2:$A),"","<a href="&""""&VLOOKUP($D2:$D,'Zoom Links'!$A2:$D,3,False)&""""&"><img border="&""""&"0"&""""&" alt="&""""&"Add to google calendar"&""""&"src="&""""&'Image Links'!$B2&""""&" width="&""""&"24"&""""&" height="&""""&"24"&""""&"></a>"))

    The above code ends up creating,<a href="https://calendar.google.com/calendar/render?action=TEMPLATE&dates=20210216T144500Z%2F20210216T154500Z&location=https%3A%2F%2Fciu20.zoom.us%2Fj%2F97592367631%3Fpwd%3DVUVMZDZCRW9ERHZYQ3V2SEpTTGdQUT09&text=Career%20Readiness%20for%20Students%20with%20Low-Incidence%20Disabilities"><img border="0" alt="Add to google calendar"src="https://drive.google.com/thumbnail?id=1RCziF9SIc4Na5xn0WA3sVScDvI3AMY_D" width="24" height="24"></a>, which is perfect for my needs. 

     

    The Vlookup ends up finding the selection that the user made in the form and finds the corresponding url for the selection made. I simply reference this column header in my draft email, and it ends up inserting the linked image in the email.  By the way, you can use the width height variables to size your image to whatever you'd like. You're welcome YAMM :-)

    0
    Comment actions Permalink

Please sign in to leave a comment.