Ah, of course, thank you.
On Wednesday, 12 September 2012 17:07:48 UTC+1, Niphlod wrote:
>
> format is missing for the clients table .....
>
> how should web2py show the clients records in the dropdown of the
> "newly/currently editing" record of promotions ?
>
> Il giorno mercoledì 12 settembre 2012 17:28:50 UTC+2, scausten ha scritto:
>>
>> I'm having the same trouble with the following table definition (version
>> 2.0.8)
>>
>> db.define_table('clients',
>> Field('name'))
>>
>> db.define_table('promotions',
>> Field('client', 'reference clients'),
>> Field('name'),
>> Field('starts_on', 'datetime'),
>> Field('ends_on', 'datetime'))
>>
>> I'm not getting a dropdown for promotions.client in appadmin or other
>> SQLFORMs without explicitly specifying requires=IS_IN_DB(...)
>>
>> Thanks in advance!
>>
>> On Sunday, 19 August 2012 21:02:41 UTC+1, Massimo Di Pierro wrote:
>>>
>>> Thanks. Fixed.
>>>
>>> On Sunday, 19 August 2012 14:16:47 UTC-5, Alan Etkin wrote:
>>>>
>>>> Can you make a more concrete example?
>>>>>
>>>>>
>>>> A table definition
>>>>
>>>> db.define_table("plugin_pyodel_attendance",
>>>> Field <http://localhost:8000/examples/global/vars/Field>("student",
>>>> "reference auth_user",
>>>> default=auth.user_id),
>>>> Field <http://localhost:8000/examples/global/vars/Field>("course",
>>>> "reference plugin_pyodel_course"),
>>>> Field <http://localhost:8000/examples/global/vars/Field>("paid",
>>>> "double", default=0.0),
>>>> Field <http://localhost:8000/examples/global/vars/Field>("allowed",
>>>> "boolean", default=False),
>>>> Field <http://localhost:8000/examples/global/vars/Field>("passed",
>>>> default=False),
>>>> Field <http://localhost:8000/examples/global/vars/Field>("score",
>>>> "double"),
>>>> format="%(student)s"
>>>> )
>>>>
>>>> I have previously inserted two users with the registration feature.
>>>> I attached a screenshot with the appadmin insert form view output.
>>>> For my understanding, the form should by default present a combo widget
>>>> for the student field
>>>>
>>>> Perhaps I could look for validators defined elsewhere but I'm pretty sure
>>>> I'm not using them.
>>>> No big deal if the problem is only for appadmin but would'n there be
>>>> similar problems with default forms when using crud, etc?
>>>>
>>>>
--