Thanks that was super helpful!
On Tuesday, December 4, 2012 4:31:08 PM UTC, Niphlod wrote:
>
> if form.process().accepted:
> if form.vars.is_tutor:
> ...whatever, e.g. db.table.insert(**form.vars)
>
> How do you structure your db to save this data is up to your application:
> if you need this stored next to the auth_user table the recommended way is
> extending auth_user with auth.settings.extra_fields
>
> On Tuesday, December 4, 2012 5:21:59 PM UTC+1, Daniele wrote:
>>
>> OK. So I removed what I had before (tables in a database) and moved to
>> SQLFORM.factory. I now have this in my controller:
>>
>> form = SQLFORM.factory(
>> Field('is_tutor', 'boolean'),
>> Field('image', 'upload',
>> requires=IS_EMPTY_OR(IS_IMAGE(extensions=('jpeg', 'jpg', 'png', 'gif')))),
>> Field('location', 'list:string', requires=IS_NOT_EMPTY()),
>> Field('subjects', 'list:string', requires=IS_NOT_EMPTY()),
>> Field('qualifications', 'list:string', requires=IS_NOT_EMPTY()),
>> Field('biography', 'string', length=500),
>> Field('hourly_rate', 'decimal(7,2)', requires=IS_NOT_EMPTY()),
>> Field('modified_on', 'datetime', requires=IS_DATETIME(),
>> writable=False, readable=False, default=request.utcnow),
>> table_name='tutor')
>>
>> so when the form is submitted, I now need to check if the field is_tutor
>> is True. If it is, I need to add that info to the current logged user's
>> information. Do I need to modify auth to do this? If so, how?
>>
>> On Monday, December 3, 2012 3:16:45 PM UTC, Niphlod wrote:
>>>
>>> if it's checked the corresponding var would be True.
>>> If the form is submitted the controller will receive that field as
>>> request.vars.fieldname or as form.vars.fieldname if you are using a form.
>>> When you "get to" the form.process() line the value has been already been
>>> "shipped" to the database. You must act "before": there is the onvalidation
>>> callback (but it's generally used for other things, like additional
>>> validation).
>>>
>>> If you want to skip form processing at all (and possibly doing some
>>> other custom logic) you can rely either on SQLFORM with process(dbio=False)
>>> or with SQLFORM.factory..... in either case you'll have to build (or not,
>>> depending on the checkbox) the corresponding create/update record "by hand"
>>> (not so hard with e.g. SQLFORM.factory because generally your form.vars
>>> would be ready to be inserted into the table if the form has the same
>>> structure of the table itself, e.g. db.table.insert(**form.vars))
>>>
>>>
>>> On Monday, December 3, 2012 3:27:29 PM UTC+1, Daniele wrote:
>>>>
>>>> Hey guys, I'm wondering if there's a way from the controller to know
>>>> whether a form's boolean field (checkbox) is selected or not. I only want
>>>> to add the info in the form to the database if the checkbox is selected,
>>>> otherwise the controller should not process that form.
>>>>
>>>> Thanks!
>>>>
>>>
--
