- wrtAsked on July 28, 2015 at 02: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?
- JotForm SupportjonathanAnswered on July 28, 2015 at 04:07 PM
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.
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.