I'd try changing your battle_log def to:
db.define_table('battle_log',
Field('battle_date', type='date',
label=T('Battles Date')),
Field('battles', type='integer',
label=T('Battles'),
requires=IS_IN_SET(['0', '1', '2', '3', '4', '5', '6', '7', '8',
'9', '10'])),
Field('reserved', type='integer',
label=T('Reserved'),
requires=IS_IN_SET(['0', '1', '2', '3', '4', '5', '6', '7', '8',
'9', '10'])),
Field('training_id', db.training,
label=T('Training Status'),
Field('comment', type='string',
label=T('Comment')),
auth.signature,
format='%(battles)s')
On Thursday, December 12, 2013 5:49:51 AM UTC-6, Warrick wrote:
>
> Hi Guys,
>
> I am trying to build a form. I have the drop down list working in the
> form, but when I display the record, it displays the id instead of the
> selected field.
>
> db.define_table('training',
> Field('type', type='string',
> label=T('Training Held')),
> auth.signature,
> format='%(type)s')
>
> db.define_table('training_archive',db.training,Field('current_record','reference
>
> training',readable=True,writable=True))
>
> ########################################
> db.define_table('battle_log',
> Field('battle_date', type='date',
> label=T('Battles Date')),
> Field('battles', type='integer',
> label=T('Battles'),
> requires=IS_IN_SET(['0', '1', '2', '3', '4', '5', '6', '7', '8',
> '9', '10'])),
> Field('reserved', type='integer',
> label=T('Reserved'),
> requires=IS_IN_SET(['0', '1', '2', '3', '4', '5', '6', '7', '8',
> '9', '10'])),
> Field('training_id',
> label=T('Training Status'),
> requires=IS_IN_DB(db,db.training.id,'%(type)s')),
> Field('comment', type='string',
> label=T('Comment')),
> auth.signature,
> format='%(battles)s')
>
> db.define_table('battle_log_archive',db.battle_log,Field('current_record','reference
>
> battle_log',readable=True,writable=True))
>
> In another search, I found an easier way to do this, as below:
>
> db.define_table('clan',
> Field('name', requires=IS_NOT_EMPTY()),
> format='%(name)s')
>
> auth.settings.extra_fields['auth_user'] = [Field('clan', db.clan)]
>
> The second method was by far easier, how could I implement this in the
> first example?
>
> Thanks
> Warrick
>
--
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/groups/opt_out.
