Re: [web2py] Grid

Hi You can use selectable metod to pass selected row to a function to update records. El sáb., 21 ene. 2017 a las 12:05, Bishal Saha () escribió: > Cant we use grid to update few rows ? > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/w

Re: [web2py] Grid query

On 31 August 2015 at 15:17, Manuele Pesenti wrote: > Il 31/08/15 09:54, Manuele Pesenti ha scritto: > > to brutally by-pass the exception you can try something like... > > > > papers = db.wos_papers_by_dt.count.sum() > > setitem(papers, "tablename", "wos_papers_by_dt") > I apologize... I mean set

[web2py] Re: web2py grid edit

Also, if you look in your admin screen there are plug-ins available. One of them is plugin_SQLFORM_INLINE On Tuesday, June 30, 2015 at 10:29:40 AM UTC-7, Alessio Varalta wrote: > > Hi, i have a problem. I have a grid form but i want that the user can > modify the field without the section edit.

[web2py] Re: web2py grid edit

Maybe Tim Richardson's ideas will help from web2pyslices ... http://www.web2pyslices.com/slice/show/1928/basic-inline-editing-in-sqlformgrid-no-plugin-no-javascript http://www.web2pyslices.com/slice/show/1714/jqgrid-viewing-and-updating-data -- Resources: - http://web2py.com - http://web2py.com/

Re: [web2py] grid and field_id

It surely not going to be fix in 2.9.5... Do you check in new version of web2py if this issue is still relevant? If so consider open a ticket and maybe make a PR so others can review it. Richard On Tue, May 5, 2015 at 9:09 AM, Massimiliano wrote: > Hi, > > in web2py 2.9.5 and older I was using

Re: [web2py] .grid() my own search widget possible? How?

What you want I think is plain text search... There is a example using Whoosh, if you search the google group you should find Massimo email annoncing it... Good luck. Richard On Fri, Mar 6, 2015 at 10:44 AM, Ron Chatterjee wrote: > Basically, quick and dirty way to display the search bar on th

Re: [web2py] .grid() my own search widget possible? How?

Basically, quick and dirty way to display the search bar on the top of the site using smartgrid without showing the table. Then when someone put a query and hit, "search", be able to redirect to another page. That way, the prototype will be complete without writing a customized search routine.

Re: [web2py] .grid() my own search widget possible? How?

You want the table to pop when there will be results selected? If so, I guess you will need some JS. You will need to init the table with a query that prevent any result to be selected (this query will require to be hiden somehow JS this is the tricky part, you will need to clear behind the scene

Re: [web2py] .grid() my own search widget possible? How?

I just posted a question in the web2py group. Searching I came to this post. Since you guys worked on this. What if I do like the default search and want to stick with it and display the search box that comes out of SQLFORM.grid or smartgrid but I don't want to display the table underneath. Do

[web2py] Re: web2py grid auto page

On Saturday, September 20, 2014 9:43:34 PM UTC-7, T.R.Rajkumar wrote: > > I have a SQLFORM.grid. It paginates the returned rows. Now I want to move > through all the pages on a set timer interval without clicking the page > numbers, i.e I want to auto page like an album without post back using

Re: [web2py] grid problem

On Wednesday, July 30, 2014 4:59:41 AM UTC-4, Manuele wrote: > > Il 30/07/14 09:30, ceriox ha scritto: > > thanks Javier! > > but can you explain "must be a function"? > > i use this code in other functions (for other tables) and it work fine! > > how i need to change it? > Dear ceriox, > I t

Re: [web2py] grid problem

Il 30/07/14 09:30, ceriox ha scritto: > thanks Javier! > but can you explain "must be a function"? > i use this code in other functions (for other tables) and it work fine! > how i need to change it? Dear ceriox, I think here lie the problem: https://github.com/web2py/web2py/blob/master/gluon/sqlht

Re: [web2py] grid problem

thanks Javier! but can you explain "must be a function"? i use this code in other functions (for other tables) and it work fine! how i need to change it? Il giorno martedì 29 luglio 2014 17:51:47 UTC+2, Massimo Di Pierro ha scritto: > > good catch! > > On Tuesday, 29 July 2014 10:39:15 UTC-5, J

Re: [web2py] grid problem

good catch! On Tuesday, 29 July 2014 10:39:15 UTC-5, Javier Pepe wrote: > > form = SQLFORM.grid(db.t_proposte, >searchable=True, > deletable=True, >details=False, > * selectable**=True,** <- must be a funct

Re: [web2py] grid problem

form = SQLFORM.grid(db.t_proposte, searchable=True, deletable=True, details=False, * selectable**=True,** <- must be a function* csv=True, user_signature=False) #

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

it works, thank you so much, anthony e.g. product_status = {'On Sale': T('On Sale'), 'Hold': T('Hold'), 'Sold': T('Sold')} table.status.represent = lambda status, field: SPAN(product_status[status], _class = 'text-success' if status == 'Sold' else 'text-warning' if status == 'Hold' else 'text-e

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

On Wednesday, June 11, 2014 3:48:15 PM UTC-4, 黄祥 wrote: > > Hi, Anthony, is it possible to combine the represent for change the color > depend on the value with the represent for is_in_set translate above? > e.g. > Sure, instead of SPAN(status, ...) do SPAN(mydict[status], ...). Anthony -- Res

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

Hi, Anthony, is it possible to combine the represent for change the color depend on the value with the represent for is_in_set translate above? e.g. table.status.represent = lambda status, field: SPAN(status, _class = 'text-success' if status == 'Sold' else 'text-warning' if status == 'Hold' els

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

Sorry, do it this way: mydict = {1: T(''), 2: T('')} Anthony On Wednesday, June 11, 2014 11:24:34 AM UTC-4, Stefan van den Eertwegh wrote: > > Hi Anthony, > > I am sorry but it doesnt work. > Also gives pycharm an error at the rule mydict = dict > > Stefan > > Op woensdag 11 juni 2014 17:06

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

Hi Anthony, I am sorry but it doesnt work. Also gives pycharm an error at the rule mydict = dict Stefan Op woensdag 11 juni 2014 17:06:06 UTC+2 schreef Anthony: > > mydict = dict(1=T(''), 2=T('')) > > db.define_table('mytable', > Field('myfield', represent=lambda v, r: mydict

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

mydict = dict(1=T(''), 2=T('')) db.define_table('mytable', Field('myfield', represent=lambda v, r: mydict[v])) Anthony On Wednesday, June 11, 2014 10:50:06 AM UTC-4, Stefan van den Eertwegh wrote: > > Hi Anthony, > > Me and my colleges tried it with represent but we cant figure

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

Hi Anthony, Me and my colleges tried it with represent but we cant figure it out. Can you give an example how this should work? The table and column is templates.type (key: value) Regards, Stefan van den Eertwegh Op woensdag 11 juni 2014 16:37:13 UTC+2 schreef Anthony: > > The IS_IN_SET validato

[web2py] Re: Web2py grid shows key from IS_IN_SET({key: value}) model

The IS_IN_SET validator affects form widgets but not other displays of the values in the field. If you want to change the way a value is displayed in a grid (or SQLTABLE), you must use the "represent" attribute of the field. Anthony On Wednesday, June 11, 2014 8:58:54 AM UTC-4, Stefan van den E

Re: [web2py] .grid() my own search widget possible? How?

Dear Richard, Would you (and Jim) please post your sample code? Thanks in advance. Love and peace, Joe On Thursday, April 24, 2014 8:10:01 AM UTC-7, Richard wrote: > > I am reading the sqlhtml.py search_widget... > > So I would just pass my function (search widget) like that : > > SQLFORM.grid

Re: [web2py] .grid() my own search widget possible? How?

I am reading the sqlhtml.py search_widget... So I would just pass my function (search widget) like that : SQLFORM.grid(..., search_widget=my_search_widget_function) ? Thanks Richard On Thu, Apr 24, 2014 at 10:38 AM, Jim S wrote: > Yes, you definitely can. > > I don't

Re: [web2py] .grid() my own search widget possible? How?

Yes, you definitely can. I don't ever use the default search. In a nutshell, you have to create your own search form and then apply the results of that form to the query passed to the grid. Let me know if you need an example and I'll see if I can put a quick one together for you today. -Ji

[web2py] Re: Web2py Grid: Hiding from the main grid but show on other views

Thanks Villas! That did it! On Wednesday, June 12, 2013 5:41:56 PM UTC-4, villas wrote: > > I seem to remember doing something like this once - worth a try: > > if not 'view' in request.args: > db.CodeMaster.Code_Example.readable = False > db.CodeMaster.Code_Example.writable = False > el

[web2py] Re: Web2py Grid: Hiding from the main grid but show on other views

I seem to remember doing something like this once - worth a try: if not 'view' in request.args: db.CodeMaster.Code_Example.readable = False db.CodeMaster.Code_Example.writable = False else: db.CodeMaster.Code_Example.readable = True db.CodeMaster.Code_Example.writable = False --

[web2py] Re: Web2py Grid: Hiding from the main grid but show on other views

use the fields attribute of the grid. On Wednesday, June 12, 2013 1:35:03 AM UTC+2, Joe Magaro wrote: > > Hi Massimo. > > Perhaps I explained this incorrectly. > > When I added db.CodeMaster.Code_Example.readable = False that did two > things: > a) Removed the Code_Example Field from the Grid (go

[web2py] Re: Web2py Grid: Hiding from the main grid but show on other views

Hi Massimo. Perhaps I explained this incorrectly. When I added db.CodeMaster.Code_Example.readable = False that did two things: a) Removed the Code_Example Field from the Grid (good!) b) Removed the Code_Example Field from the display view. (Not what I want) (a) is what I want, but I when I dis

[web2py] Re: Web2py Grid: Hiding from the main grid but show on other views

I tried db.CodeMaster.Code_Example.readable = False I tried db.CodeMaster.Code_Example.writable = False Now put the two lines in the action before the grid(...) and it will only apply to that grid. On Tuesday, 11 June 2013 15:34:30 UTC-5, Joe Magaro wrote: > > Hi, I am just learning web2py and I

Re: [web2py] Grid inside Form

Try changing the route for the edit button with routes.py, and before create your own controller with the form edit and the grid El 27/10/2012 09:45, "Santiago Avendaño" escribió: > Hello, > > My example app has two models. > > db.define_table('person', Field('name')) > db.define_table('dog', Fie

Re: [web2py] grid without

Il 02/04/2012 11:06, Johann Spies ha scritto: Use 'deletable=False' in the argurments for the grid. Documented at http://www.web2py.com/books/default/chapter/29/7#SQLFORM.grid-and-SQLFORM.smartgrid-%28experimental%29 Regards Johann Hi Johann, thanks for your replay but that's not what I'm l

Re: [web2py] grid without

On 2 April 2012 10:46, Manuele Pesenti wrote: > Hi, > is there an easy way to use grid and smartgrid without the delete botton? Use 'deletable=False' in the argurments for the grid. Documented at http://www.web2py.com/books/default/chapter/29/7#SQLFORM.grid-and-SQLFORM.smartgrid-%28experimenta

Re: [web2py] Grid examples

http://www.web2pyslices.com/slices/take_slice/148 On Tue, Feb 28, 2012 at 12:04 PM, greenpoise wrote: > Any good source out there of grid examples? I am struggling even with > the book in hand..The grid comes out but in an ugly manner. I just > want to customize it to remove/add headings etc. > >

Re: [web2py] grid doesn't like requires?

Have you tried removing the last , after the IS_IN_DB()? On Wed, Jan 18, 2012 at 7:05 AM, Martin Weissenboeck wrote: > Hi, > > that's my model > > db.define_table('report', >Field('person', 'reference auth_user', > #requires=IS_IN_DB(db, db.auth_user.id, "%(last_name)s" ), # > <--

Re: [web2py] grid usage

at the moment you can't pass vars to grid, instead use args. 2011/10/19 Manuele > On 19/10/2011 13:49, brushek wrote: > >> Hello, >> >> I want to use SQLFORM.grid in one controller like this: >> >> def klienci(): >> if request.vars.a == 'adresacje': >> grid=SQLFORM.grid(db.**adresacj

Re: [web2py] grid usage

On 19/10/2011 13:49, brushek wrote: Hello, I want to use SQLFORM.grid in one controller like this: def klienci(): if request.vars.a == 'adresacje': grid=SQLFORM.grid(db.adresacje,user_signature=False) elif request.vars.a == 'serwery' or 'serwery' in request.args: gri

Re: [web2py] grid

Live demo and download here: http://powertable.blouweb.com/ ALPHA 0.0.0.0.0.0 Version (too much working in progress), Tests and suggestions needed, something can broke, fails or whatever, this is teh first plugin I wrote, and I have too much to enable on this. I am going to publish it to BitBuck

Re: [web2py] grid

Here the answer : http://datatables.net/forums/comments.php?DiscussionID=2815 - Known limitations: Absolute positioning is used, so in some browsers which are a little slower (basically everything but Webkit), there can be a little jarring when scrolling. Fixed positioning cannot be used for Fixe

Re: [web2py] grid

Hello Bruno, DataTables not your plugin.. Did you notice with FF when you fix Column when you xscroll that the fixed column also tends to drag with the other columns... With Chrome no problem... With IE it is even worse the fixed column overlay... Richard On Tue, Dec 14, 2010 at 11:24 AM, Bru

Re: [web2py] grid

Datatable2, MagicDatatable, SmartDataTable, RadDataTable. Because you are using datatable :P 2010/12/14 Bruno Rocha : > To avoid confusion and to avoid problems with the author's old plugin for > DataTables. http://web2py.com/plugins/default/datatable > > I decided to rename the plugin, and I am

Re: [web2py] grid

PowerTable? ;) On Tue, Dec 14, 2010 at 4:02 PM, Bruno Rocha wrote: > To avoid confusion and to avoid problems with the author's old plugin for > DataTables. http://web2py.com/plugins/default/datatable > > I decided to rename the plugin, and I am in doubt, what about? > MagicTable, MagicGrid, Smar

Re: [web2py] grid

To avoid confusion and to avoid problems with the author's old plugin for DataTables. http://web2py.com/plugins/default/datatable I decided to rename the plugin, and I am in doubt, what about? MagicTable, MagicGrid, SmartTable, SmartGrid, RadTable, RadGrid ? -- Bruno Rocha http://about.me/ro

Re: [web2py] grid

Even not complete, I'll release this for http://w2pexhibition.appspot.com/15th December. Not every functionality will work on this fitst version, but I'd like if you can help me testing. In-line editing uses jquery.jeditable, which calls a function in a controller passing some index information a

Re: [web2py] grid

Hello Bruno! Seems very fantastic ! I like the in-line editing so much ! I was trying to include most of your features in my own view. Not enough skills to make in-line editing... To my ming your plugin seems much more functionnal to the jquery widget provided with plugin_wiki Looking forward to

Re: [web2py] grid

Hello Bruno, Where can we get this really nice work! How did you get it to work with the T() internationalisation of web2py? Richard On Mon, Dec 13, 2010 at 2:38 AM, Bruno Rocha wrote: > > The new datatables plugin is almost done! > > I am working now on Server Side (Json/XML) data processing

Re: [web2py] grid

Thank you very much for drawing my attention to this plugin Thadeus I succeed! Richard On Fri, Dec 10, 2010 at 3:58 PM, Thadeus Burgess wrote: > I really enjoy working with DataTables. It is easy to use and extremely > configurable! > > Not only that, but it can load results from any JSON reque

Re: [web2py] grid

You can easily extend plugin_wiki to include a new widget. I dont know if it is better than jQgrid, because I never uses jQgrid, but I am finding everything I need in datatables and its plugins. It is good to have more options. 2010/12/13 Anthony > Is this better than jqGrid? plugin_wiki has a

Re: [web2py] grid

Is this better than jqGrid? plugin_wiki has a jqGrid widget -- should it also have a datatables widget?

Re: [web2py] grid

Wold love to test it with joins.

Re: [web2py] grid

in my TODO: plugin.datatable.fixed = ['header','column'] I'll try to release it for testing today, and put it to bitbucket. 2010/12/10 Richard Vézina > It have a fixed column feature : > > http://www.datatables.net/release-datatables/extras/FixedColumns/index.html > > >

Re: [web2py] grid

It have a fixed column feature : http://www.datatables.net/release-datatables/extras/FixedColumns/index.html Great! Richard On Fri, Dec 10, 2010 at 5:08 PM, Richard Vézina wrote: > What's about fixed column with Dat

Re: [web2py] grid

What's about fixed column with DataTables or other grid plugin? My table are very large... I can't remeber if jqgrid where exposing a lateral scroll bar when width is fixed. Regards Richard On Fri, Dec 10, 2010 at 3:58 PM, Thadeus Burgess wrote: > I really enjoy working with DataTables. It is

Re: [web2py] grid

Can help test! Just ask. Richard On Fri, Dec 10, 2010 at 4:20 PM, Bruno Rocha wrote: > 2010/12/10 Thadeus Burgess > > I really enjoy working with DataTables. It is easy to use and extremely >> configurable! >> >> Not only that, but it can load results from any JSON request, so you can >> hand

Re: [web2py] grid

I really enjoy working with DataTables. It is easy to use and extremely configurable! Not only that, but it can load results from any JSON request, so you can handle filtering, ordering, and pagination in your queries on the server. -- Thadeus On Fri, Dec 10, 2010 at 9:43 AM, Richard Vézina

Re: [web2py] grid

Here other links fruit of my search for a fixed header and left column jQuery plugin : http://cross-browser.com/x/lib/view.php?s=xlibrary Other library like jQuery (as far as I understand) seems very rich GPL http://johnsobrepena.blogspot.com/se

Re: [web2py] grid

Forget about what I said, DataTables is the best one so far! http://www.datatables.net/examples/server_side/server_side.html I am having a good time with this one, all features in one table plugin. This is already in /plugins http://web2py.com/plugins/default/datatable, but need more documentat

Re: [web2py] grid

Thank you for sharing this good stuff. I selected the best plugins to test: http://flexigrid.info/ (seens to be the best, better than jqgrid in my opinion) http://www.sprymedia.co.uk/article/KeyTable (very nice edit inplace feature) http://www.rebeccamurphey.com/jquery/graphTable/table.html (C