haa..Its an odd model I know. But it works!! punch it in in a blank project and you will see.. With my model I am trying to:
1. Concatenate the fields I just mentioned 2. I want to compute the supplier code for products so I dont have to add/select it in over and over. 3. I want to export the final output (reason why I need the concatenate in a compute). Once I export that in CSV, I can bulk upload that worksheet into RMS (microsoft)..thats the whole reason behind this application and its weird model. If you can think of a better idea, I am open for input Thanks again!! On Thursday, July 11, 2013 1:39:10 PM UTC-7, Richard wrote: > > Hmmm... I think your model is wrong... > > You can't use a compute on a reference field.. > > What you are trying to do exactly? > > Why you need to concatenate thing? For representation purpose? > > I think I really can help you what you need is easy but I can't understand > your goal from the model you posted... > > Richard > > > On Thu, Jul 11, 2013 at 4:12 PM, greenpoise <[email protected]<javascript:> > > wrote: > >> Ok..I started playing around with an empty and smaller database for the >> sake of speed. This is what I have: >> >> db.define_table('supplier', >> Field('suppliercode'), >> Field('suppliername'), >> format='%(suppliercode)s') >> db.supplier.suppliercode.requires = >> IS_NOT_IN_DB(db,db.supplier.suppliercode) >> db.supplier.suppliername.requires = >> IS_NOT_IN_DB(db,db.supplier.suppliername) >> >> db.define_table('series', >> Field('supplier','reference supplier'), >> Field('seriesname'), >> Field('seriesdescription')) >> db.series.supplier.requires = IS_IN_DB(db,db.supplier.id >> ,'%(suppliername)s') >> >> db.define_table('product', >> Field('series', 'reference series'), >> Field('supplier', 'reference series',compute=lambda row: >> db.series(row.series).supplier), >> Field('supptile', 'reference supplier',compute=lambda row: >> db.series(row.series).supplier), >> Field('tilename')) >> db.product.series.requires = IS_EMPTY_OR(IS_IN_DB(db,db.series.id >> ,'%(seriesname)s')) >> >> I want to concatenate/compute db.product.supptile with >> db.product.tilename ..Is is possible?? . >> >> >> >> >> On Thursday, July 11, 2013 11:50:07 AM UTC-7, Anthony wrote: >>> >>> Oops, sorry, I read that wrong -- thought it was a "represent" function >>> rather than a "compute" function. Yes, not sure you want to store a value >>> other than the db.series.id value in a reference field for db.series. >>> >>> Anthony >>> >>> On Thursday, July 11, 2013 2:39:39 PM UTC-4, Richard wrote: >>>> >>>> But in this case you don't have the id of the referenced record as >>>> relation key... I am not sure it's what you want. But you question is >>>> really vague so difficult to answer correctly to your I think :P >>>> >>>> Richard >>>> >>>> >>>> On Thu, Jul 11, 2013 at 2:21 PM, Anthony <[email protected]> wrote: >>>> >>>>> On Thursday, July 11, 2013 1:21:11 PM UTC-4, greenpoise wrote: >>>>> >>>>>> I think I saw some light in here! this did the trick for me: >>>>>> >>>>>> Field('supplier', 'reference supplier',compute=lambda row: db.series( >>>>>> row.series).supplier****), >>>>>> >>>>> >>>>> Should be the same as: >>>>> >>>>> lambda row: row.series.supplier >>>>> >>>>> assuming row.series is a reference field referring to db.series. >>>>> >>>>> Anthony >>>>> >>>>> -- >>>>> >>>>> --- >>>>> 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<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> >>>> -- >> >> --- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- --- 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.
