Re: [web2py] Web2py Forms and Javascript

2014-08-18 Thread Richard Vézina
Don't know where you get so far, but I post the code example I talked about on this thread : https://groups.google.com/d/msg/web2py/oiyOIC0IH04/6-NvVOJECU8J The example is for phone numbers, but you can reuse it for anything else. I use that code for one to many relation with normalized db schema

Re: [web2py] Web2py Forms and Javascript

2014-08-06 Thread Richard Vézina
Ok, so the list is a should be a dropbox in your app where you can pick the service or the pieces in you invoice? I guess it is now an kind of check list you receive to create the invoice? There is a lot of wording in your business you could start by simplifying all the concept the use and figure

Re: [web2py] Web2py Forms and Javascript

2014-08-05 Thread Jesse Ferguson
The service order on the right is what is completed in the field by the techs. (The part they bring me). The form on the left is what our company calls a Work-Up. The work up Is created by me by taking the service orders information and the information from a rolodex card. The rolodex card (not

Re: [web2py] Web2py Forms and Javascript

2014-08-05 Thread Richard Vézina
Could you explain the 3 differents part of the paperwork... There the invoice at the right but what is the listing in the lower left... Richard On Tue, Aug 5, 2014 at 2:57 PM, Jesse Ferguson wrote: > here is the paperwork > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Do

Re: [web2py] Web2py Forms and Javascript

2014-08-05 Thread Jesse Ferguson
I am working to move the company from paper to electronic, I work in a remote office and have to fax all of this right now. basic workflow: Service Orders Created in the field at Job site get delivered to me every day. I take the service order and create a workup (basically an invoice) usi

Re: [web2py] Web2py Forms and Javascript

2014-08-04 Thread Richard Vézina
Why item and item_entry, I don't understand the utility of item_entry and where's the invoice table (service-order is invoice?)? To me the cost and amount field of item and item_entry are going in the service_order table since they deserve the purpose of indicating the price paid for this item in

Re: [web2py] Web2py Forms and Javascript

2014-07-18 Thread Jesse Ferguson
I think this would work better however I am not sure about the items.. is the item_entry table how its normally done? Examples online vary... A completed Service order would have multiple Item_entry references... Just doesn't seem like the right way to do it.. db.define_table('company', > >

Re: [web2py] Web2py Forms and Javascript

2014-07-18 Thread 黄祥
for autofiling please check it on the book about dal default or ajax autocompletion ref: http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#Auto-completion http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer as richard said : please have normalization on your t

Re: [web2py] Web2py Forms and Javascript

2014-07-18 Thread Richard Vézina
For the prefilled data you have this : db.invoice.fieldname.default = your previous predefined form data For your model, I think it is much more complex then that... For instance, what's happen when there is new Items? You add new column to your model each time? (bad idea). Also storing company in

[web2py] Web2py Forms and Javascript

2014-07-18 Thread Jesse Ferguson
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 w