Setting a default value for a reference field

[mostwanted]

Is there a way to create a placeholder for a reference field?

e.g:

{{

Field('place', 'reference locations', label=SPAN('Place of operations'), widget=lambda field, value: SQLFORM.widgets.reference.widget(field, value, _placeholder="Whats your place of operations?"))

}}

Regards;

Mostwanted

[Jim S]

Reading from this stackoverflow post, it appears it isn't something you can do.  But, they show some alternatives:

https://stackoverflow.com/questions/5805059/how-do-i-make-a-placeholder-for-a-select-box

However, that post is pretty old, maybe someone else has some better solutions.

-Jim

[Annet]

I wonder why the IS_IN_DB() validator doesn't suit your needs.

I have a field day:

Field('day', 'reference cal_day', default=None, required=True, requires=IS_IN_DB(db, 'cal_day.id', '%(id)s %(name)s',  zero='Select a day'), ondelete='RESTRICT', notnull=True, label='Day *'),

Doesn't zero = 'Whats your place of operations?' do what you want?

Annet

Op vrijdag 18 september 2020 om 12:41:11 UTC+2 schreef mostwanted:

[mostwanted]

Thank you Annet