Google Sheet connection breaks after spreadsheet modification

  • Profile Image
    Skypowerwash
    Asked on January 14, 2020 at 04:28 PM

    I would like to have a form that my bookkeeper can use to determine the number of hours each employee should be classified under different rates for workers compensation. Right now I have a checklist that each technician fills out daily. They record yes or no if they were working over 2 stories off the ground. They also put the number of hours they were working off the ground. I would like this to be exported into a google sheet so its easy for her to see and calculate each pay period. I do have the google sheet connection set up, but the problem is that I would like to just show the 4 columns (Name, date, were you over 2 stories and how many hours over 2 stories) rather than the whole spreadsheet with every answer on the checklist showing. When I edit the sheet to just show those columns it stops updating. Is there a workaround for this?

  • Profile Image
    Mike
    Answered on January 14, 2020 at 06:32 PM

    If you create an HTML Table Listing report with selected shared fields, is this something that might work in your case?

    This is also possible to use a Zapier automation service to configure a more flexible JotForm > Google Sheet connection. Note that their free plan is limited to 100 tasks/month.