How to selectively show fields on Google Sheets?

  • Profile Image
    northpacificcouncil
    Asked on June 25, 2020 at 06: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? 

  • Profile Image
    KrisLei
    Answered on June 25, 2020 at 07: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.