-
hgamermanAsked on December 2, 2020 at 10:21 AM
Hi,
I have already a google sheet with all members of my team and activities they need to perform every day.
i would like to know how can i set up a form that each one can fill up the quantities of the activities perform every day and when they submit will feed the google sheets in the specific cells for each member and for each activity
Thank you
Henry Gamerman
-
John Support Team LeadReplied on December 2, 2020 at 11:57 AM
Hello Henry - This isn't directly possible with Jotform. You can integrate the form with Google Sheets but the integration only sends all the data received to the sheet. Each submission will be added as a new row and it will not be selective/customizable.
GUIDE: how-to-integrate-forms-with-google-sheets
There is a workaround to achieve the requirement you mentioned but it can only be done with Google Sheets alone. You may set up another worksheet for the Table on your screenshot then just extract necessary data from the integrated sheet. I must say this will involve multiple IFs and Importrange functions, so I would recommend consulting with a Google Sheet expert/specialist to plot the formulas. Here are some guides you can use:
Using ImportRange - https://support.google.com/a/users/answer/9308940?hl=en
Using the IF function - https://support.google.com/docs/answer/3093364?hl=en