[web2py] sqlform grid to show a field entirely, without cutting off the text

2019-06-18 Thread Vlad
Is there an easy way to force the SQLFORM grid to show one specific column entirely, without cutting it off, even if the row would have to be extended vertically, just whatever it takes to see the full text content? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - h

[web2py] sqlform grid search widget expression question

2019-06-05 Thread Vlad
How can I search for None values? For example, the search expression table.customer == "1" gives me records with customer equals 1. I can't figure out how to search for records with customer field equals None. Tried none,NONE, None, "none", etc. Nothing helped :) Is it possible at all?

[web2py] SQLFORM grid customization HELPPP

2019-02-18 Thread Alain Márquez Pérez
Hello everyone, the SQLFORM.grid customization is very wide(i think is using the ui = ), i need some help with the edit,view Views, by the way im not using the native web2py bootstrap, im using mdbootstrap, i know my problem is related to this, but cant find any info about the grid customiz

[web2py] SQLFORM grid search : Get ids of filtered records

2016-10-24 Thread Madhavi
Hi, I am new to web2py and am working on application with a SQLFORM grid with the search feature along with selectable option. I added extra buttons to my grid to set a boolean value for selected records using selectable feature, and added another button to set a boolean value for all the reco

Re: [web2py] SQLFORM grid special edit form for specific record

2015-11-02 Thread Manuele Pesenti
Il 02/11/15 04:15, Yebach ha scritto: > Hello > > SO I have a SQLFORM.grid. > > I would like to create an edit view for specific records in db (based > on one field name) that instead of text field shows checkbox and > writes True/false into database > > I hope question is understandable > > any su

[web2py] SQLFORM grid special edit form for specific record

2015-11-01 Thread Yebach
Hello SO I have a SQLFORM.grid. I would like to create an edit view for specific records in db (based on one field name) that instead of text field shows checkbox and writes True/false into database I hope question is understandable any suggestions? thank you -- Resources: - http://web2py.

[web2py] SQLFORM grid, adding buttons

2015-09-17 Thread Ron Chatterjee
Is any reason that I don't see "add record" and "view" button with my sqlform.grid (like shown in the example here: http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid)? When I use @auth.requires_login(). I do see the edit and delete button. # db.py db.define_tab

[web2py] SQLform grid custom function for delete

2015-09-14 Thread Yebach
Hello Is there a way to use SQLform.grid and add a function and new buttons for delete record and other purposos I do not allow user to actually delete records just to change status in database, so the record still stays there. Any suggestions? -- Resources: - http://web2py.com - http://web

[web2py] SQLFORM grid process not working

2014-07-21 Thread Yebach
Hello I have a SQLForm.grid. I want to create a response.flash message but on my if evaluation I get an error when my edit view is done 'DIV' object has no attribute 'process' even on my sqlform.grid view this is my controller function form = SQLFORM.grid(query=query, left=db.stat

[web2py] SQLForm Grid

2013-12-13 Thread LaDarrius Stewart
Is there to only give the add(create) functionality of the sqlform.grid Example: db.define_table('Participant', Field('FirstName' , 'text'), Field('LastName' , 'text') fields = [ db.Participant.FirstName ] headers = {'Participant.FirstName': 'FirstName'} form2=SQLFORM.grid(db.

[web2py] SQLFORM grid Export all the fields and not only visible fields

2013-11-14 Thread Gaurav Agrawal
Hello, SQLFORM.grid(db.table_name,fields=visiblefields) visiblefields is a list that contains only few fields among the all the fields in the table When I use the export option to export in html, it contains only the fields that are available in the visiblefields but the view/edit normally cont

[web2py] SQLFORM grid save checkbox state in multi-page results

2013-09-24 Thread ewong1111
I have the same question as asked here: https://groups.google.com/forum/#!searchin/web2py/grid$20checkbox$20pages/web2py/laMiQozWj_k/Wq6SdDDSajUJ I know how to use ajax to call a controller function that will register the checked row in a session variable. What I don't know is how to use the

[web2py] SQLFORM grid returns a error : query object has no attribute _tablename

2013-07-15 Thread Sarbjit singh
I am doing the following steps : >>> db = DAL('sqlite://storage.db') >>> db.define_table('person', Field('name'), Field('country')) >>> db.person.insert(name='John', country='UK') >>> db.person.insert(name='David', country='US') >>> query = db.person.name=="David" >>> SQLFORM.smartgrid(query) Tr

[web2py] SQLForm grid vertical pagination issue

2013-04-01 Thread Rahul
Hi All, I am trying to use jquery-ui with sqlform grid. Here is my grid code from my controller - form = SQLFORM.grid( query=query, fields=fields, headers=headers, orderby=default_sort_order, user_signature=False, create=False, deletable=False, editable=False, csv=False, maxtextlength=64

[web2py] SQLFORM grid shows reference id instead of name

2013-02-16 Thread Edwin Haver
Hello, I have created a grid with SQLFORM but the grid shows the country id instead of the country name. The form shows the name as expected but the grid does not. However, if I use 'reference country' it does but then I cannot leave the country empty in the account. Is there an easy way, other

[web2py] SQLFORM grid: No records, No Add button?

2012-09-29 Thread lyn2py
Hi guys, I just noticed that if the grid is empty, there is no ADD button, even when I explicitly used create=True. Is this the expected behavior? I have lots of empty grids for users to input, and need a ADD button on the grid for that. Is there a way to add such a button? Thanks guys! --

[web2py] SQLFORM grid

2011-12-02 Thread peter
I am having the following problem when I use 'edit' on SQLFORM grid, and then submit the changes. I tried downloading the latest trunk and also created the app afresh to ensure things were otherwise clean 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. Traceback (most recent call las

Re: [web2py] SQLFORM grid Authentication.

2011-11-09 Thread Naleen Yadav
On Wed, Nov 9, 2011 at 3:52 PM, Bruno Rocha wrote: > try some like this: > > *def myfunction(): >> ** if request.args(0) in ['edit', 'new'] and not >> auth.has_membership('admin'): >> ** redirect(URL("NOT AUTHORIZED URL"))** >> ** return dict(grid=SQLFORM.grid(.))* > > > > > O

Re: [web2py] SQLFORM grid Authentication.

2011-11-09 Thread Bruno Rocha
try some like this: *def myfunction(): > ** if request.args(0) in ['edit', 'new'] and not > auth.has_membership('admin'): > ** redirect(URL("NOT AUTHORIZED URL"))** > ** return dict(grid=SQLFORM.grid(.))* On Wed, Nov 9, 2011 at 8:16 AM, Naleen Yadav wrote: > Hii All, > >

[web2py] SQLFORM grid Authentication.

2011-11-09 Thread Naleen Yadav
Hii All, I am using sqlform grid and i just want to put some authentication on each some functions of grid i.e(Delete , Write) for certain groups' users I can do this by using crud.xxx() but i m unable to use authentication with sqlform grid(). regards, Naleen

[web2py] SQLFORM grid Authentication.

2011-11-09 Thread Naleen Yadav
can we put some sort of authentication on sqlform grid on the basis of membership so that the user can perform specified operation for which the user is allowed. thanks

Re: [web2py] SQLFORM grid and smartgrid

2011-09-14 Thread Martín Mulone
> > 2. Can I override the default links for Add and Edit? links = [lambda row: A('Edit',_href=URL("default","edit",args=[row.id])), lambda row: A('Delete',_href=URL("default","delete",args=[row.id]))] table = SQLFORM.grid(query, links=links, deletable=F

Re: [web2py] SQLFORM grid and smartgrid

2011-09-14 Thread Jim Steil
Looks like I found the answer to #1. Updated to latest trunk and recreated app from scratch. Must be something new in the scaffolding view/css that changed the default behavior. -Jim On 9/14/2011 11:01 AM, Jim Steil wrote: I understand that these two grid are brand new, but has anyone cr

[web2py] SQLFORM grid and smartgrid

2011-09-14 Thread Jim Steil
I understand that these two grid are brand new, but has anyone created any documentation on all of the options and how to use them yet? Here are a couple issues I'm wondering about: 1. In reading this post - https://groups.google.com/forum/#!msg/web2py/1eSMh8TlHGs/rB9Hx2UIP4cJ - and looking