On Tuesday, February 23, 2016 at 12:31:03 PM UTC-8, aetag...@gmail.com wrote: > > I've been having trouble understanding how this works and could be > achieved with web2py, it seems like this concept exists within Django so I > want to understand how this can be implemented within web2py. > > > Example scenario: > A doctor logs onto the web2py application and they go onto a page which > asks them how many patients they saw for that specific day. This value will > vary, so say for this session they enter the value 4, they press submit and > this value is then passed to another controller function which takes in > this value with something like request.vars. Based on this value, instances > of a single form will generate. It is going to be the same form, but all of > the form values will differ based on the patient and what time they were > seen. > > I cannot seem to understand how the table for this form will be generated, > I think this is where I get lost with this. > > One session creates multiple instances of one form, so the database table > when viewed with sqlform.grid will look very different in each row because > each row is a separate session for separate days, therefore the first row > may have X number of columns which is based on the number of instances, > thus another session may have Y number of columns because the number of > generated instance is different for that day....I can draw this out if it's > confusing I just am very confused with how this can work based on dynamic > input. >
I would expect that the DB table would always have the same number of columns (frex -- visit_datetime, patientID, attending_doctor, summary, test_list, diagnosis). Each visit would be 1 row. Each doctor would enter multiple rows for the current day's visits (4 in your example). SQLFORM could display all visits, all visits that day, all visits for patient X, all visits for doctor Y, that day's visits for doctor Y, etc, depending on the query it was told to use. /dps > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
