Hello
I am using SQLFORM smartgrid. My child table field is not shown on my form
(status.s_code). Why?
Also. If I (user) click(s) on edit, all fields are editable. how do I set
which fileds are or can be editable and which one not.
Is it possible to create a form that is click in editable (like excel?), so
u don't have to open another window?
thank you
This is my code in contorller.
workers = db(db.worker.w_organisation == 10).select(db.worker.w_id_w,
db.worker.w_organisation, db.worker.w_first_name,
db.worker.w_last_name,db.worker.w_nick_name,db.worker.w_email,db.worker.w_status,db.worker.w_note).as_list()
#Define the query object. Here we are pulling all contacts having date of
birth less than 18 Nov 1990
query = ((db.worker.w_organisation == 10) )#&
(db.worker.w_status==db.status.s_id_s))
fields = (db.worker.w_id_w,db.worker.w_first_name,
db.worker.w_last_name,db.worker.w_nick_name,db.worker.w_email
*,db.status.s_code*,db.worker.w_note)
#Define headers as tuples/dictionaries
headers = {'worker.w_id_w' : 'Id',
'worker.w_first_name' : 'Ime',
'worker.w_last_name' : 'Priimek',
'worker.w_nick_name' : 'Vzdevek',
'worker.w_email' : 'E-posta',
'status.s_code': 'Status',
'worker.w_note' : 'Komentar' }
#Let's specify a default sort order on date_of_birth column in grid
default_sort_order=[db.worker.w_last_name]
form = SQLFORM.smartgrid(db.worker,fields = fields,headers=
headers,linked_tables=['status'])
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
