Report using a script to calculate Subform data
Hi Experts,
I would have liked to be able to add a button to my form so that we can automatically add multiple entries to a subform but a search of the forum indicates it's not possible. Please tell me if I am wrong :-)
(Add a start date & number of weeks to the main form, press button and then it then adds an entry for each week [on a Monday] to the subform)
On the strong assumption that it's not possible I have a requirement to create a report showing bookings by week/month but that detail is not held. Only the Start date & how many weeks booked.
So if we imagine that we only have 2 bookings in the system:
Name: Mark
Start Date: 11 Dec 2017
No Of Weeks: 3
Name: Eric
Start Date: 04 Dec 2017
No Of Weeks: 2
A report by week would count each week's booking where applicable. Such as....
Date No Of Students
| 27-Nov-17 |
0 |
| 04-Dec-17 |
1 |
| 11-Dec-17 |
2 |
| 18-Dec-17 |
1 |
| 25-Dec-17 |
1 |
| 01-Jan-18 |
0 |
Is this even possible? I am new to Zoho so don't know much Deluge and can't even seem to add a report column via script; they just get ignored :-(
Mark