Ended up using lambda instead. 

Field('conversiontype','reference conversiontype',compute=lambda r: 1 ifrequest
.vars.tileuse == '5' else '2'),


Thanks!



On Thursday, September 5, 2013 7:25:32 PM UTC-7, greenpoise wrote:
>
> Thats exactly what I am looking! Thanks, will try and post Thanks Anthony
>
>
>
> On Thursday, September 5, 2013 6:31:46 PM UTC-7, Anthony wrote:
>>
>> Does conversiontype need to be writable in forms? If not, you can use a 
>> computed field. If you are just trying to change the default value, you 
>> could do something like:
>>
>> Field('conversiontype','reference conversiontype',
>>       default=5 if request.vars.tiluse == 5 else 2)
>>
>> Note, that will only change the default on submission, so it won't help 
>> with pre-populating the form (but you can't know the value of tileuse at 
>> the time the form is created anyway).
>>
>> Anthony
>>
>> On Thursday, September 5, 2013 7:32:04 PM UTC-4, greenpoise wrote:
>>>
>>> is it possible to have an if statement of some sort in Dal to 
>>> validate/add a value based on other field?
>>>
>>> like:
>>>
>>> db.define_table('product',
>>>     Field('series', 'reference series'),
>>>     Field('suppliercode','reference supplier'),
>>>     Field('description'),
>>>     Field('tiluse','reference tileuse'),
>>>     Field('price'),
>>>     Field('cost'),
>>>     Field('picture', 'upload'),
>>>     Field('conversiontype','reference conversiontype',default=2))
>>>
>>>
>>>
>>> I need the conversiontype to be 1 if tiluse = '5' otherwise stay in 2. 
>>>  How can I accomplish this in Dal?
>>>
>>> thanks
>>>
>>

-- 

--- 
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.

Reply via email to