At our facility we order a lot of unique items but also have an inventory of some items. I am trying to add some logic that when ordering an item, there is a check to see if the ordered item name is in the inventory (inventory.name). Then person ordering is made aware that a similar item is in inventory and maybe we need to pull that item out of inventory versus ordering that part if it is indeed the correct part, size, color etc...
On Thursday, February 11, 2016 at 5:52:23 PM UTC-7, Anthony wrote: > > What are you trying to do? Do you want to store this information in the > POrequest table, or do you want to prevent inserts if the item is not in > the db.inventory table? If the latter, IS_IN_DB will certainly work, but > note that validators only get run if you are using SQLFORM or if you call > .validate_and_insert(). > > Anthony > > On Thursday, February 11, 2016 at 6:02:16 PM UTC-5, Greg White wrote: >> >> I should have mentioned that I tried IS_IN_DB first off and it didn't work >> >> On Wednesday, February 10, 2016 at 4:25:48 PM UTC-7, Dave S wrote: >>> >>> >>> >>> On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, Greg White wrote: >>>> >>>> Want a computed field to show whether or not a field value exists in >>>> another table >>>> >>> >>> >>> I'm not sure that is the right approach. I think that the standard >>> validator IS_IN_DB() is what you want, instead. >>> >>> <URL: >>> http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators >>> > >>> (IS_IN_DB is the second validator in that section) >>> >>> The example shown appears to be similar to what I think you're trying to >>> do. >>> >>> /dps >>> >>> >>>> started with this... >>>> >>>> db.define_table( >>>> 'inventory', >>>> Field('name'), >>>> Field('qty', label='Quantity'), >>>> Field('MatSize',label='Material Size'), >>>> format = '%(name)s') >>>> >>>> db.define_table( >>>> 'POrequest', >>>> Field('name', 'reference requestor', label='Requestor'), >>>> Field('JobNum', 'reference jobs', label='Job #'), >>>> Field('description', 'text', notnull=True), >>>> Field('InInventory', compute=lambda r: r['description'] IN r[ >>>> db.inventory.name]), <<< this row right here is what I need help with >>>> format = '%(name)s') >>>> >>>> trying to verify row by row in a computed field if >>>> db.POrequest.description is in any row of db.inventory.name >>>> >>>> help please. >>>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
