Groups
Sign in
Groups
web2py-users
Conversations
Labels
API
Catalina
DAL
Field
GAE
GIS
HL7
JavaSctipt
LOAD
MySQL
Paypal
PostgreSQL
REST
RFC
URL
admin
advocacy
ajax
apache
app
appadmin
args
array
auth
backups
bug
bugfixes
cache
calendar
callback
components
contract
contrib
controller
create
criticism
crud
css
csv
dal
database
date
db
debugging
delete
demo
deployment
development
docker
documentation
e-learning
edit
error
error_handling
exception
expiration
folder
for
form
forms
framework
gluon
grid
html
html_helpers
ide
imap
import
input
internationalization
is_scheduler
javascript
jquery
json
keyed
l
legacy
links
login_bare
mac
mail
markmin
minor
models
modules
movuca
networking
nginx
nosql
operators
packages
password
payments
plugin
plugins
post
primarykey
product
py4web
pyDAL
pycharm
pyodel
python
python3
pythonanywhere
query
redirect
redis
registration
release
request
requires_login
rewriting
routing
save
scheduler
service
services
session
session_auth
sessions
setup
site
smtp
social
sqlform
sqlite
ssl
static
stupid_css
symbol
table
tampering
testing
trunk
typo
upgrade
upload
uploadfolder
uploads
users
uwsgi
validation
versios
views
w
web2py
web2pyslices
websockets
widget
wiki
About
Send feedback
Help
web2py-users
Contact owners and managers
1–30 of 34885
Mark all as read
Report group
0 selected
P Page-McCaw
,
villas
2
7/20/20
Q&A
problem with list:reference
Your model deletes the records and recreates them every time the model runs. This is not such a good
unread,
Field
db
Q&A
problem with list:reference
Your model deletes the records and recreates them every time the model runs. This is not such a good
7/20/20
p a
3
2/22/20
Q&A
select for list:integer, but in a specific position
And a second version with SUBSTR def operator_field_starts(field, first_int, query_env={}): '
unread,
Field
dal
pyDAL
table
Q&A
select for list:integer, but in a specific position
And a second version with SUBSTR def operator_field_starts(field, first_int, query_env={}): '
2/22/20
cdbaron
,
Paul Ellis
4
11/4/19
SQLFORM.grid search with fields readable = False
It works, but the solution is db.table.field.listable = False to hide fields in the grid and search,
unread,
Field
grid
SQLFORM.grid search with fields readable = False
It works, but the solution is db.table.field.listable = False to hide fields in the grid and search,
11/4/19
Yebach
,
Massimo Di Pierro
2
8/18/19
Q&A
IS_IN_SET or write in
possible but not implemented. honestly this is complicated and I'd rather do it i vue.js in
unread,
Field
forms
Q&A
IS_IN_SET or write in
possible but not implemented. honestly this is complicated and I'd rather do it i vue.js in
8/18/19
dgm...@gmail.com
4/24/19
Q&A
ExporterCSV fails if virtual field included in fields=[... in SQLFORM.grid
my SQLFORM.grid includes a virtual field in fields[]. Displays perfectly in the grid, but CSV button
unread,
Field
csv
grid
Q&A
ExporterCSV fails if virtual field included in fields=[... in SQLFORM.grid
my SQLFORM.grid includes a virtual field in fields[]. Displays perfectly in the grid, but CSV button
4/24/19
João Matos
2
3/22/19
Q&A
How to add an on select event to a drop down list box and pass the selected value to the js fuction?
Found the solution. form.element('#no_table_equipment_id')['_OnChange'] = '
unread,
Field
javascript
sqlform
Q&A
How to add an on select event to a drop down list box and pass the selected value to the js fuction?
Found the solution. form.element('#no_table_equipment_id')['_OnChange'] = '
3/22/19
João Matos
2
5/3/19
Q&A
Checkboxes are shown without space between checkbox and label
Found a kludge. # Fix the lack of space between the checkbox and the label. # The ' ' below
unread,
Field
css
sqlform
views
widget
Q&A
Checkboxes are shown without space between checkbox and label
Found a kludge. # Fix the lack of space between the checkbox and the label. # The ' ' below
5/3/19
Paulo Serrão
, …
Val K
5
11/14/18
Q&A
Interacting with Postgres Integer Array Field
See Custom Field types in the book
unread,
Field
dal
Q&A
Interacting with Postgres Integer Array Field
See Custom Field types in the book
11/14/18
Sandeep Patel
, …
Anthony
3
5/9/18
Q&A
How to show conditional fields with multiple conditions
I'm not sure that show_if supports & and | queries, but if it does, the correct syntax for a
unread,
Field
forms
Q&A
How to show conditional fields with multiple conditions
I'm not sure that show_if supports & and | queries, but if it does, the correct syntax for a
5/9/18
Dave S
,
Anthony
5
3/24/18
Q&A
custom ordering of select results
On Wednesday, March 21, 2018 at 11:21:28 AM UTC-7, Dave S wrote: On Wednesday, March 21, 2018 at 5:30
unread,
Field
dal
Q&A
custom ordering of select results
On Wednesday, March 21, 2018 at 11:21:28 AM UTC-7, Dave S wrote: On Wednesday, March 21, 2018 at 5:30
3/24/18
Yi Liu
,
Anthony
4
2/2/18
Q&A
appadmin.py interpret represent differently than default.py, causing keyError or attributeError
Thank you so much for your detailed explanation. You also solved my puzzle about the behavior of join
unread,
Field
Q&A
appadmin.py interpret represent differently than default.py, causing keyError or attributeError
Thank you so much for your detailed explanation. You also solved my puzzle about the behavior of join
2/2/18
Dragan Matic
, …
tim.n...@conted.ox.ac.uk
3
1/11/18
Q&A
Is there a way to put icon or image picker in form?
If you want to avoid javascript magic, you'll want to create a custom widget, probably something
unread,
Field
form
forms
table
Q&A
Is there a way to put icon or image picker in form?
If you want to avoid javascript magic, you'll want to create a custom widget, probably something
1/11/18
Jordan Myers
,
Massimo Di Pierro
2
9/30/17
Broken backwards compatibility: Using a field in multiple tables yields error
Thanks for reporting this. We will fix this in 2.15.5 shortly. On Monday, 25 September 2017 11:38:51
unread,
Field
bug
dal
table
Broken backwards compatibility: Using a field in multiple tables yields error
Thanks for reporting this. We will fix this in 2.15.5 shortly. On Monday, 25 September 2017 11:38:51
9/30/17
Luciano Laporta Podazza
,
Leonel Câmara
2
8/8/17
Q&A
Select image path and content from a db(table).select()
I haven't tested it, but you could do something like import base64 def my_awesome_api(): def
unread,
Field
services
upload
Q&A
Select image path and content from a db(table).select()
I haven't tested it, but you could do something like import base64 def my_awesome_api(): def
8/8/17
narcissus
, …
Rodrigo Sacht
7
7/14/18
JSON field with MySQL database
from gluon.dal import SQLCustomType json_type = SQLCustomType(type ='text', native='JSON
unread,
Field
dal
JSON field with MySQL database
from gluon.dal import SQLCustomType json_type = SQLCustomType(type ='text', native='JSON
7/14/18
Maurice Ling
6/9/17
Q&A
ValueError in encypted field using filter_in/filter_out
Hi I am trying to encrypt a field (using pyDes.py which is located in modules folder of my
unread,
Field
dal
sqlite
Q&A
ValueError in encypted field using filter_in/filter_out
Hi I am trying to encrypt a field (using pyDes.py which is located in modules folder of my
6/9/17
Maurice Ling
6/7/17
Q&A
Key length error when trying to store encrypted value into field using gluon.contrib.AES
Hi all, I am trying to store one or more encrypted values into their respective fields, which has to
unread,
Field
contrib
dal
error
sqlite
Q&A
Key length error when trying to store encrypted value into field using gluon.contrib.AES
Hi all, I am trying to store one or more encrypted values into their respective fields, which has to
6/7/17
mke...@halstead.com
,
黄祥
4
4/1/17
Q&A
How to format the result of a sum()
of course you can do it in controller eg def index(): import locale sum = db.log.severity.sum()
unread,
Field
forms
grid
sqlform
Q&A
How to format the result of a sum()
of course you can do it in controller eg def index(): import locale sum = db.log.severity.sum()
4/1/17
Oasis Agano
,
Dave S
3
4/3/17
Q&A
Autofill a field with data from the database based on 3 other fields without submit
I used event handler as you said now the issue i have is to set the value of amt to the one returned
unread,
Field
ajax
javascript
query
sqlform
Q&A
Autofill a field with data from the database based on 3 other fields without submit
I used event handler as you said now the issue i have is to set the value of amt to the one returned
4/3/17
Jordan Myers
, …
Anthony
9
2/18/18
Q&A
Trying to use Field.represent for 'blob' type in SQLFORM.grid (works in appadmin?)
On Sunday, February 18, 2018 at 7:05:37 AM UTC-5, mweissen wrote: I have tried form = SQLFORM.grid(db
unread,
Field
appadmin
grid
sqlform
table
Q&A
Trying to use Field.represent for 'blob' type in SQLFORM.grid (works in appadmin?)
On Sunday, February 18, 2018 at 7:05:37 AM UTC-5, mweissen wrote: I have tried form = SQLFORM.grid(db
2/18/18
Jurgis Pralgauskis
,
Anthony
2
3/10/17
Q&A
overriding fieldnames for SQLFORM
I think you are limited to either monkey patching FormWidget in gluon.sqlhtml or using server-side
unread,
Field
sqlform
Q&A
overriding fieldnames for SQLFORM
I think you are limited to either monkey patching FormWidget in gluon.sqlhtml or using server-side
3/10/17
Jordan Myers
, …
Kiran Subbaraman
4
3/2/17
Q&A
Is there an easier way to initiate tables with references to currently undefined tables?
I don't have a solution for your situation, but this may help you devise a mechanism that works:
unread,
Field
dal
deployment
table
Q&A
Is there an easier way to initiate tables with references to currently undefined tables?
I don't have a solution for your situation, but this may help you devise a mechanism that works:
3/2/17
Gaurav Vichare
, …
Leonel Câmara
3
1/25/17
Q&A
Store dates in UTC format across all tables
this is the simplest way: request.now = request.utcnow Your way should also work if you do it after
unread,
Field
auth
table
Q&A
Store dates in UTC format across all tables
this is the simplest way: request.now = request.utcnow Your way should also work if you do it after
1/25/17
Jurgis Pralgauskis
1/15/17
AnySQLFORM: one Form for Many Tables (even with same field names)
Hi, I try to develop layer over SQLFORM which would fully preserve field info (even better than in
unread,
Field
sqlform
AnySQLFORM: one Form for Many Tables (even with same field names)
Hi, I try to develop layer over SQLFORM which would fully preserve field info (even better than in
1/15/17
Aydin
, …
Anthony
12
10/7/16
Q&A
read a field of auth_user
Thanks Anthony, Absolutely worked fine. On Friday, October 7, 2016 at 10:35:33 AM UTC-4, Anthony
unread,
Field
auth
table
Q&A
read a field of auth_user
Thanks Anthony, Absolutely worked fine. On Friday, October 7, 2016 at 10:35:33 AM UTC-4, Anthony
10/7/16
Yoel Benitez Fonseca
2
8/30/16
custom update form multiple tables and list:string
Solved in some extend: The problem is that each widget is initialized with the record values on the
unread,
Field
forms
sqlform
custom update form multiple tables and list:string
Solved in some extend: The problem is that each widget is initialized with the record values on the
8/30/16
Jordan Myers
,
Sneka R
6
7/18/16
Q&A
How to export sqlform.grid with the labeled column names
Actually I added the following line on top of the custom_exporter.py file import cStringIO And it
unread,
Field
csv
grid
Q&A
How to export sqlform.grid with the labeled column names
Actually I added the following line on top of the custom_exporter.py file import cStringIO And it
7/18/16
pbt
, …
Leonel Câmara
8
1/11/17
Q&A
Store value in input field in a table
Can we see the entire controller and view where you're trying this?
unread,
Field
forms
table
views
Q&A
Store value in input field in a table
Can we see the entire controller and view where you're trying this?
1/11/17
pbt
, …
Jim S
6
7/12/16
Q&A
adding onFocus event to a field of an sql form
@JIM S Yes,both questions are same.I am finding two different methods for this question.So,I asked
unread,
Field
form
javascript
sqlform
table
Q&A
adding onFocus event to a field of an sql form
@JIM S Yes,both questions are same.I am finding two different methods for this question.So,I asked
7/12/16
Steve
, …
pbreit
4
6/1/16
Q&A
auth.signature and Format ....issue
You might try: Field('work_position', 'reference work_position', label=T('
unread,
Field
auth
table
Q&A
auth.signature and Format ....issue
You might try: Field('work_position', 'reference work_position', label=T('
6/1/16