Discussions

Expand all | Collapse all

Inventory Troubles

  • 1.  Inventory Troubles

    Posted 6 days ago
    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 5 days ago
    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
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------