I am playing around with creating a custom form and am hitting a bit of a snag. There are two things I would like to happen when someone fills in the form listed below but am struggling with how to even begin to put this together. Hopefully you all can help!
In this case, an app user is filling out appointment data in a form. Since their request will happen more than once, they are being asked to enter an end date and which days of the week they need their appointment to be.
First need: I would like the Days of the week to be contained in one cell per request. For example is someone made an appointment for Monday, Wednesday, and Friday, the cell data for [Days of the week] would read - "Monday, Wednesday, Friday".
Second need: Will function like setting a calendar event as reoccurring in programs like outlook or google calendar. I would like to find a way for Honeycode to count the number of Mondays, and Wednesdays, between the start date and the end date and then insert the correct number of rows into a table and populate the correct date for each occurrence.
Example Case: A college professor is entering class data into Honeycode to create a homework schedule. They select that the class will be reoccurring and then enter the start date and end date. Finally the professor indicates that the class will meet two days a week - Mondays and Wednesdays. Assuming that the class is a normal semester (15 weeks) the formula will indicate that there are 15 occurrences, match up the appropriate dates of each occurrence and place them into a new table in Honeycode.
Is this currently possible in Honeycode?
Appreciate any help