How to selectively show fields on Google Sheets?

  • northpacificcouncil
    Asked on June 25, 2020 at 6:00 PM

    We want to be able to export only certain fields of a form into a google sheet.  Is there a way we can select which fields only? 

    We'd like all the info to be available to the admin team, but for the public we want to hide any phone/email/personal info.  Is there a way to do that? 

  • KrisLei Jotform Support
    Replied on June 25, 2020 at 7:08 PM

    Hi,

    To my understanding, you would like to share the submissions made on your form in public but not the personal data in it, correct? Unfortunately, when integrating the submissions in Google Sheet, it will automatically export all the data to the sheet. 

    However, this is possible by generating a Grid List or HTML Table Listing report that can let you select only specific fields or data to display and share the generated link publicly.

    I hope this helps. Let us know if it didn't meet your requirements.