This is a bit complicated. You don't actually want x separate forms, as you need to be able to submit a single form (so you want x copies of the input fields, but all wrapped in a single form). If you do that, though, for each field, you'll get a list of values (one for each copy of the field in the form). Alternatively, you could change the name of each input to include the day number. Either way, you'll need custom backend code to process all the submitted data and do the database inserts.
Another option would be to load a set of separate forms via Ajax (possibly as web2py components), and when the user is ready to submit, run some Javascript that programmatically submits each form separately via Ajax. In that case, the backend code would be very simple (just a single standard SQLFORM) -- all the complexity would be in the Javascript. This is a bit less efficient, as you'll get a separate HTTP request for each day's form.
Anthony