This is kind of two questions but I would like to build a app to handle 
Invoicing, We have some "satellite" offices in other towns and it would be nice 
to get rid of our hand written paper forms and faxing(FORM 
https://drive.google.com/file/d/0BydRLdL9cc4mNzhjR1U3MHVPVjA/edit?usp=sharing 
). I would like to know whats the best practice for building the data model on 
large forms? Should the form be all one table? There's about 35 items, which 20 
or so would just be integers (amounts of item).. below I have an example of 
what I'm thinking of going with. Finally I would like to implement a 
auto-filling form, for example if the user types in a location that has already 
been put in once before it will automatically fill in the mileage and person to 
attn to, would this be best handled with a javascript framework? If so could 
you push me towards one to learn? (my javascript is weak but I'm working on it 
:))

Thanks in advance!
    Jesse Ferguson

EXAMPLE MODEL

db.define_table('invoice',
    Field('price_list', 'integer'),
    Field('account_code','string'),
    Field('company', 'string'),
    Field('attn', 'string'),
    Field('customer_order_number', 'string'),
    Field('ccc_so_num', 'string'),
    Field('date_of_work', 'date'),
    Field('wo_location', 'string'),
    Field('lease', 'string'),
    Field('details', 'list:reference'),
    )

-- 
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to