Can we use jotform to query data from a google sheet?

  • Profile Image
    thesocialbarber
    Asked on June 27, 2019 at 03:57 PM

    I want to use an existing sheet and filter data in an existing google sheet.  I need to share the sheet with a lot of people so I don't want to allow them edit access to my sheet.  A lot of them don't know how to use google filters.


    I want it to work like this: 

  • Profile Image
    Alan_D
    Answered on June 27, 2019 at 05:05 PM

    Unfortunately, there is no direct integration, tool, widget, etc. to accomplish your goal. 
    But, I can recommend you our Data Grid widget. You should be able to able to customize your data as the widget's format to use it. 15616687687.png15616687758.pngThis is my demo form. You can clone and inspect that. 15616694889.pnghttps://www.jotform.com/91776057508971 
    Guide: How-to-Clone-an-Existing-Form-from-a-URL