+ Reply to Thread
Results 1 to 2 of 2

display image from a forms URL on report page

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    534

    display image from a forms URL on report page

    I have a form that allows someone to take an image which is displayed on the responce page as an URL link.
    There will be a report page which will populate based on the date entered using vlookup and index match formulas.
    I am looking for a way to display the image on the report page rather than just a URL link.

    I found one formula that works, but you need to cut the image name out of the original link and apply it to the image formula in order to see the image.
    The report should be dynamic and have all the fields populate without the user cutting and pasting.

    Any Thoughts?
    https://docs.google.com/spreadsheets...#gid=516169362

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: display image from a forms URL on report page

    I found one formula that works, but you need to cut the image name out of the original link and apply it to the image formula in order to see the image.
    The report should be dynamic and have all the fields populate without the user cutting and pasting.
    You are talking about two different issues.

    As for the "cutting of the name" (which is actually the fileId, NOT the name), that is necessary due to the link type not being compatible with the type required for discplaying the image. You can easilly see this by looking at the original file link starting with "https://drive.google.com/open?id=" and the url for display uses "https://drive.google.com/uc?id=" (but can also use "https://drive.google.com/uc?export=view&id=").

    Regarding being dynamic, that is entirely up to you to use enough criteria to either LOOKUP or FILTER for the correct row that you want displayed.

    In any case, the way the file is currently setup, you can remove the mass of formulas you are using and replace with these 3:

    =IMAGE("https://drive.google.com/uc?id="&REGEXEXTRACT(VLOOKUP($F$5,'Form Responses 3'!$B:$EY,12,0),"=(.+)"),2)
    =IMAGE("https://drive.google.com/uc?id="&REGEXEXTRACT(VLOOKUP($F$5,'Form Responses 3'!$B:$EY,13,0),"=(.+)"),2)
    =IMAGE("https://drive.google.com/uc?id="&REGEXEXTRACT(VLOOKUP($F$5,'Form Responses 3'!$B:$EY,14,0),"=(.+)"),2)
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Add image from worksheet to Image1 with no user forms
    By Boechat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2019, 08:54 PM
  2. [SOLVED] vba code to concatenate text at each end of page report from right to left page
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2017, 10:47 AM
  3. Search box code - Will display an image and clear to remove image
    By mutzie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2016, 11:10 AM
  4. [SOLVED] Linking Image to a cell value, and display the selected image in new sheet
    By siva venkata in forum Excel General
    Replies: 12
    Last Post: 03-25-2014, 02:34 AM
  5. Display Image Based On Image Name In Cell
    By processchip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 10:11 AM
  6. VBA report with forms
    By moroformat in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 12-17-2009, 09:15 PM
  7. VBA to display image on a form - image is defined in Range Name
    By Tan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2006, 10:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1