-
wrtAsked on July 28, 2015 at 2:41 PM
I need to create a spreadsheet that contains four individual days, several services with different times that vary on the days. The client needs to select those service times they are interested in by preference 1 thru 3. Any idea?
-
jonathanReplied on July 28, 2015 at 4:07 PM
Hi,
Can you also share to us the URL of the form you are working this on. We can evaluate further once we understand how the form will be.
---
Initially, I think you will need to have the following fields/data on the form.
Days
Services type
DateTime
because you will probably need to filter the would be generated submission data base on those fields/data.
If you will be integrating the form to Google Spreadsheet (since you mentioned spreadsheet), we know that the form submission data will only go to a single spreadsheet every time.
So there will be a need to work outside the form submission spreadsheet (by copying the submission sheet separately), to be able to do all the filtering process -- that is, create Sheet for Days, Services, and DateTime.
Let us know how we can be of further assistance.
Thanks.