[web2py] Re: Is it easy to create a grid data entry form using web2py?
On Wednesday, 4 June 2014 01:03:43 UTC+10, Chris Green wrote: > > LaDarrius Stewart > wrote: > > [-- text/plain, encoding quoted-printable, charset: UTF-8, 52 lines --] > > > > Like this? > > > http://www.web2pyslices.com/slice/show/1928/basic-inline-editing-in-sqlformgrid-no-plugin-no-javascript > > > > Yes, that's pretty much what I'm after. > > Hi. I wrote the slice. I've used it a few times. > Just a couple of questions:- > > By "The basic idea is to use represent to show a field in the grid > as an INPUT tag" does it mean that what this does is enable > editing fields 'in place' which isn't what the basic SQLFORM.grid > offers? > Yes. Any field that you use the represent logic on will be editable because it is rendered as an INPUT. > > It also says "to add a submit button to SQLFORM.grid", but there > isn't a submit button. > the slice shows you how to do that. Look at the use of selectable when the grid is created. This will give you a submit button. > Does the bit about boolean checkboxes just mean that these are > rather more difficult to implement? (I don't need them). > It means that you need to follow the guidance and use the example boolean_widget as provided. They are not more difficult, it is just not obvious to do it that way. > > Presumably the plugin_SQLFORM_INLINE plugin is an alternative way > to do the same thing - using a plugin and some javascript. > > > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Is it easy to create a grid data entry form using web2py?
web2py comes with this: http://www.web2py.com/init/spreadsheet/index On Tuesday, 3 June 2014 07:25:19 UTC-5, c...@isbd.net wrote: > > This may be trying to run before I can walk but never mind! :-) > > Is it easy to create a grid type table editing form in web2py? I just > want an easy way to edit an existing table, edit existing fields and > add new rows. It's just simple data, text and numeric fields in a > sqlite3 database. > > I want to edit the data in place, no pop-up forms or windows, just > click on a field and edit the data, tab to the next field and the > changed data is saved (could be delayed to when on leaves the form but > I don't want to have to do any explcit 'save' action). > > Add a new row at the bottom by tab off the last field of the last > existing row or maybe cursor down on last row or just have an empty > row always at the bottom (like MS Access). > > The table will already exist and I want to see all the columns, no > need for views or selects (though I might find uses for them in the > future). > > This is to run on an existing system (xubuntu 14.04) running apache2 > web server with various bits and pieces already running on it. I'm > fairly happy with installing web apps and use Python quite a lot for > small scripts but I haven't really worked with a development framework > like web2py before. > > > -- > Chris Green > · > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Is it easy to create a grid data entry form using web2py?
sqleditable Am Dienstag, 3. Juni 2014 22:08:19 UTC+2 schrieb Chris Green: > > This may be trying to run before I can walk but never mind! :-) > > Is it easy to create a grid type table editing form in web2py? I just > want an easy way to edit an existing table, edit existing fields and > add new rows. It's just simple data, text and numeric fields in a > sqlite3 database. > > I want to edit the data in place, no pop-up forms or windows, just > click on a field and edit the data, tab to the next field and the > changed data is saved (could be delayed to when on leaves the form but > I don't want to have to do any explcit 'save' action). > > Add a new row at the bottom by tab off the last field of the last > existing row or maybe cursor down on last row or just have an empty > row always at the bottom (like MS Access). > > The table will already exist and I want to see all the columns, no > need for views or selects (though I might find uses for them in the > future). > > This is to run on an existing system (xubuntu 14.04) running apache2 > web server with various bits and pieces already running on it. I'm > fairly happy with installing web apps and use Python quite a lot for > small scripts but I haven't really worked with a development framework > like web2py before. > > -- > Chris Green > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Is it easy to create a grid data entry form using web2py?
LaDarrius Stewart wrote: > [-- text/plain, encoding quoted-printable, charset: UTF-8, 52 lines --] > > Like this? > http://www.web2pyslices.com/slice/show/1928/basic-inline-editing-in-sqlformgrid-no-plugin-no-javascript > > Yes, that's pretty much what I'm after. Just a couple of questions:- By "The basic idea is to use represent to show a field in the grid as an INPUT tag" does it mean that what this does is enable editing fields 'in place' which isn't what the basic SQLFORM.grid offers? It also says "to add a submit button to SQLFORM.grid", but there isn't a submit button. Does the bit about boolean checkboxes just mean that these are rather more difficult to implement? (I don't need them). Presumably the plugin_SQLFORM_INLINE plugin is an alternative way to do the same thing - using a plugin and some javascript. Thanks! It looks as if I will try diving into web2py. :-) > > On Tuesday, June 3, 2014 7:25:19 AM UTC-5, c...@isbd.net wrote: > > > > This may be trying to run before I can walk but never mind! :-) > > > > Is it easy to create a grid type table editing form in web2py? I just > > want an easy way to edit an existing table, edit existing fields and > > add new rows. It's just simple data, text and numeric fields in a > > sqlite3 database. > > > > I want to edit the data in place, no pop-up forms or windows, just > > click on a field and edit the data, tab to the next field and the > > changed data is saved (could be delayed to when on leaves the form but > > I don't want to have to do any explcit 'save' action). > > > > Add a new row at the bottom by tab off the last field of the last > > existing row or maybe cursor down on last row or just have an empty > > row always at the bottom (like MS Access). > > > > The table will already exist and I want to see all the columns, no > > need for views or selects (though I might find uses for them in the > > future). > > > > This is to run on an existing system (xubuntu 14.04) running apache2 > > web server with various bits and pieces already running on it. I'm > > fairly happy with installing web apps and use Python quite a lot for > > small scripts but I haven't really worked with a development framework > > like web2py before. > > > > > > -- > > Chris Green > > · > > > > > > -- > 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 web2py+unsubscr...@googlegroups.com. > > For more options, visit https://groups.google.com/d/optout. > -- Chris Green · -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Is it easy to create a grid data entry form using web2py?
Like this? http://www.web2pyslices.com/slice/show/1928/basic-inline-editing-in-sqlformgrid-no-plugin-no-javascript On Tuesday, June 3, 2014 7:25:19 AM UTC-5, c...@isbd.net wrote: > > This may be trying to run before I can walk but never mind! :-) > > Is it easy to create a grid type table editing form in web2py? I just > want an easy way to edit an existing table, edit existing fields and > add new rows. It's just simple data, text and numeric fields in a > sqlite3 database. > > I want to edit the data in place, no pop-up forms or windows, just > click on a field and edit the data, tab to the next field and the > changed data is saved (could be delayed to when on leaves the form but > I don't want to have to do any explcit 'save' action). > > Add a new row at the bottom by tab off the last field of the last > existing row or maybe cursor down on last row or just have an empty > row always at the bottom (like MS Access). > > The table will already exist and I want to see all the columns, no > need for views or selects (though I might find uses for them in the > future). > > This is to run on an existing system (xubuntu 14.04) running apache2 > web server with various bits and pieces already running on it. I'm > fairly happy with installing web apps and use Python quite a lot for > small scripts but I haven't really worked with a development framework > like web2py before. > > > -- > Chris Green > · > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.