radview

we have some forms we wish to build that the data gets used in multiple reports, but for the user entering the data would be easier to display in different ways,
The timesheet example I used above is the simplest way I know how to explain what we are kind of trying to to.
If I had my SQL table setup columns, Weekending, Name, Job, Date, Hours and we had multiple forms setup to enter daily, or weekly, or monthly but need the data per day for other reports.

The daily form is easy its just the table and columns on a form new row for each different job worked on

The weekly entry we would want to have Sun-Sat days listed as a input field ideally with the ability to add rows prior to submission for each job eg
Weekending, Name, Job, Mon, Tues, Wed, Thrus, Fri, Sat, Sun (add row)
Weekending, Name, Job, Mon, Tues, Wed, Thrus, Fri, Sat, Sun (add row)

The form Submission would then be a loop of for all rows
Weekending = Weekending, Name = Name, Job = Job, Mon = Date(Weekending – 7days)
Weekending = Weekending, Name = Name, Job = Job, Tues = Date(Weekending – 6days)
Weekending = Weekending, Name = Name, Job = Job, Wed = Date(Weekending – 5days) etc etc

so that the form displays the weeks worth of items, but the stored data is a per date record.

This maybe something well outside the bounds of what your plugin is meant to be doing and if so I apologies.