Expand all | Collapse all

Inventory Troubles

  • 1.  Inventory Troubles

    Posted 02-11-2020 18:53
    I am in the process of building an app to track inventory. The biggest problem that I face is that some items are tracked by serial number, while others are tracked by quantity. I want to be able to use my Purchase Order table to input the quantity purchased, then create that many new records in my inventory table (where I can input the serial numbers if need be) when I click a checkbox. Alternatively, I wouldn't mind inputting the serial numbers in the PO, but quantities could range from 1-200, and creating 200 separate "serial number" fields (and then automations after) seems like a lot of extra work that can probably be avoided.

    Katlyn Allen

  • 2.  RE: Inventory Troubles

    Posted 02-12-2020 10:21
    Katlyn, I think that this can be done, but it might take some one on one consulting time to get this working.
    Part of the solution might be the technique here https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=8d321e15-bd9a-4f49-b4c9-e89822b6677f&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer&ReturnUrl=%2fcommunities%2fallrecentposts

    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach