Dan
the problem is that you are using SQLFORM.grid instead of
SQLFORM.smartgrid. Try changing that and you should be good. Sorry for
the delay, had a busy weekend....
-Jim
On Saturday, February 16, 2013 12:20:22 PM UTC-6, Dan Kozlowski wrote:
>
> Jim,
>
> I still can't get it working. I have dailycounts which is one record per
> day and has many history records per day. Looking for a button to show all
> the history records when a day is selected form dailycounts. Below is the
> controller and DAL
>
> Thanks
>
>
> def dailycounts():
> grid=SQLFORM.grid(db.daily_counts,
> user_signature=False,create=False,editable=False,deletable=False,orderby=~db.daily_counts.add_date,
>
> fields=[db.daily_counts.add_date,db.daily_counts.encrypt_count,db.daily_counts.decrypt_count,db.daily_counts.error_count,db.daily_counts.cycle_count,db.daily_counts.directory_create_count,db.daily_counts.client_add_count])
> return locals()
>
>
> db.define_table('daily_counts',
> Field('encrypt_count','integer'),
> Field('decrypt_count','integer'),
> Field('error_count','integer'),
> Field('cycle_count','integer'),
> Field('directory_create_count','integer'),
> Field('client_add_count','integer'),
> Field('client_update_count','integer'),
> Field('client_delete_count','integer'),
> Field('encryption_key_count','integer'),
> Field('add_date','date', unique=True),
> Field('add_time','time'),
> Field('add_db_user','string'),
> Field('add_app_user','string'),
> Field('update_date','date'),
> Field('update_time','time'),
> Field('update_db_user','string'),
> Field('update_app_user','string'))
>
> db.define_table('history',
> Field('client_id','string',length=10),
> Field('command','string',length=255),
> Field('encrypt_key','string',length=50),
> Field('from_dir','string',length=100),
> Field('to_dir','string',length=100),
> Field('archive_dir','string',length=100),
> Field('error_dir','string',length=100),
> Field('in_filename','string',length=100),
> Field('out_filename','string',length=100),
> Field('encryption_type','string'),
> Field('add_date',db.daily_counts),
> Field('add_time','time'),
> Field('add_db_user','string'),
> Field('add_app_user','string'))
>
>
>
>
>
>
>
>
>
>
> On Friday, February 15, 2013 10:29:46 PM UTC-6, Dan Kozlowski wrote:
>>
>> Does anyone know if I smartgrid to can create another button next to
>> View, Edit, Delete that will allow it to open a new search screen ? I have
>> a customer ( 1 to many notes) and would like a Notes button that takes
>> you to another search screen to allow you to view 1 to many Notes a
>> customer can have ?
>
>
--
---
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/groups/opt_out.
