Re: [web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread mostwanted
Thanks On Tuesday, January 28, 2020 at 4:19:42 PM UTC+2, John Bannister wrote: > > If you don’t want the field to be displayed in the SQLFORM() you need to > set as follows: > > db.table.fieldname.readable = db.table.fieldname.writable=False before the > form initialisation. > > > > So

Re: [web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread mostwanted
Thank you, I overlooked that. On Tuesday, January 28, 2020 at 3:49:02 PM UTC+2, Ramos wrote: > > did you also tried writable=False > When a field is marked with writable=False, the field is not shown in > create forms, and it is shown readonly in update forms. If a field is > marked as

RE: [web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread John Bannister
If you don’t want the field to be displayed in the SQLFORM() you need to set as follows: db.table.fieldname.readable = db.table.fieldname.writable=False before the form initialisation. So something like :- db.dog.owner.readable=db.dog.owner.writable=False form = SQLFORM(db.dog) if

Re: [web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread António Ramos
did you also tried writable=False When a field is marked with writable=False, the field is not shown in create forms, and it is shown readonly in update forms. If a field is marked as writable=False and readable=False, then the field is not shown at all, not even in update forms.

Re: [web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread mostwanted
I did employ this method (db.quotation.beforeVat.readable=False!!! ) in my controller but it didnt respond, its actually the first thing i tried! Its just that i was hoping SQLFORM() may have some helpers as part of its signature that i dont know about that I could use. On Tuesday, January 28,

Re: [web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread António Ramos
Look in the docs http://web2py.com/books/default/chapter/29/07/forms-and-validators in your controller before showing your form, db.yourtable.yourfield.readable=False!!! Em ter., 28 de jan. de 2020 às 10:29, mostwanted escreveu: > I was wondering if there is a way to show the SQLFORM()

[web2py] Displaying only certain fields of choice with SQLFORM(...) update

2020-01-28 Thread mostwanted
I was wondering if there is a way to show the SQLFORM() with only certain fields for the user during a form update & not show all the fields. SQLFORM.grid(...) has the field=None argument which enables one to select the fields to be displayed in the view, is there something like that for

[web2py] Re: Saving a view as an file/image

2020-01-28 Thread Dave S
On Sunday, January 26, 2020 at 11:04:43 AM UTC-8, Scott Hunter wrote: > > The FPDF module has an HTML Renderer which you might find useful. > > - Scott > I haven't looked into that feature (that I know of), but from my previous experience with FPDF I would probably have started with doing the

RE: [web2py] Re: Saving a view as an file/image

2020-01-28 Thread John Bannister
Hey thanks a lot will try it out!! From: web2py@googlegroups.com [mailto:web2py@googlegroups.com] On Behalf Of mostwanted Sent: 27 January 2020 15:47 To: web2py-users Subject: [web2py] Re: Saving a view as an file/image Hey John, I dont know if this will help you but there was a time when

RE: [web2py] Re: Saving a view as an file/image

2020-01-28 Thread John Bannister
I have no issue styling the vouchers in HTML (this is already done in a view) my issue is how to capture that view and send it via email either as message or attachment. From: web2py@googlegroups.com [mailto:web2py@googlegroups.com] On Behalf Of villas Sent: 27 January 2020 13:26 To: