I used one of the plug-ins to export submission into a Google spread sheet and something changed.

  • arborassoc
    Asked on April 29, 2015 at 8:53 AM

    We have a field that collects the applicants resume as a Word document or a pdf. The field was shown in google docs as a full string link to the document. Sometime last week it changed to just the name of the document.

    This has caused quite an issue with my client. They need the full string link.

    How can I get it back to what it was. Attaching a screen capture

    Jotform Thread 561054 Screenshot
  • Jeanette JotForm Support
    Replied on April 29, 2015 at 11:39 AM

    It seems google spreadsheet is shortening most common extensions, such as .pdf or .docx, it does not with other non common ones such as .odt or .ods

    However, I don't see the problem with shortened links, as they still work. You can even get the file upon clicking on the link.

    I used one of the plug ins to export submission into a Google spread sheet and something changed Screenshot 20

     

  • arborassoc
    Replied on April 29, 2015 at 12:29 PM

    The problem is the client does not want to have to click every link to get the url to the resume document.

    Until last week, the entire url was showing in the field. The client was exporting the Google spreadsheet to an internal Excel spread sheet and pasting the url into their browser to access the resume documents.

    Now when they export to Excel, I think they are just getting the document name and the link is lost.

    How can we get it back to the format we had before last week?

  • Jeanette JotForm Support
    Replied on April 29, 2015 at 1:39 PM

    I am not sure if this change was made due to some other users requesting the opposite. Let send a note to the developer in charge of this.

  • Jeanette JotForm Support
    Replied on April 29, 2015 at 1:53 PM

    Now when they export to Excel, I think they are just getting the document name and the link is lost.

    This is not true, we just did a test, and it works fine when exporting to Excel

    https://s3 eu west 1 Screenshot 20

    https://s3 eu west 1 Screenshot 31

     

    And it works the same for LibreOffice (Open Office)

    I used one of the plug ins to export submission into a Google spread sheet and something changed Screenshot 42

     

    So in that sense, everything is OK and I see no reason for this to request an unnecessary change.

  • arborassoc
    Replied on April 29, 2015 at 5:01 PM

    I just found this in your archive. Is this the problem I am having and a possible solution?

    See attached.I used one of the plug ins to export submission into a Google spread sheet and something changed Screenshot 20

  • Jeanette JotForm Support
    Replied on April 29, 2015 at 5:58 PM

    Yes, we have reverted back to full URLs . You should be all set.

  • arborassoc
    Replied on April 29, 2015 at 6:29 PM

    Thank you!

  • jonathan
    Replied on April 29, 2015 at 8:20 PM

    On behalf of Jeanette, you are quite welcome.

    Feel free to contact us again anytime should your require further assistance.

     

    Regards,