Multiple Inventory widgets: Need to calculate/show which of the inventories have available stock

  • txforesttrail
    Asked on August 7, 2018 at 2:04 AM

    Hiya,

    If you could offer me some assistance, I would be very grateful....

    My form has 24 individual inventory widgets.
    I wanted to allow my users to check inventory across all 24 widgets easily.

    My thought was to create a dropdown with the names of the 24 items - and conditionally link the users selection to a calculation widget that would update an adjacent text field with the word "available" or "unavailable" based on the current inventory.

    After searching the forum for hours, it doesn't seem like it is possible to calculate the "remaining" inventory with conditions and calculation widgets.

    In a similar question, by another user, the Jotform master suggested a couple of different api-s to somehow "get" previous submissions and then preform a calculation...  

    It was just a blip of a suggestion, there was no example form for me to clone (copying the files y'all share is pretty much how I learn anything).

    Even though I described my idea as a dropdown and a text field, it doesn't have to be anything like that. I just need anything that will give the user a quick snapshot of which of the 24 inventories have available stock.

    I'm at a loss on how to move forward...

    Thanks in advance for your help.




  • roneet
    Replied on August 7, 2018 at 6:01 AM

    Allow me some time, I am working on the solution.

    Thanks.

  • txforesttrail
    Replied on August 7, 2018 at 6:02 AM

    Yay!! Thank you!

  • roneet
    Replied on August 7, 2018 at 7:31 AM

    You may also like to check the "Appointment Slots" widget and see if it fits into your requirement.

    Please take a look at the following demo form I created for you and see if this is what you wanted to achieve:  https://form.jotform.com/82183414832960

    I have added the appointment from Sept 28, 2018 to Oct 2, 2018. Feel free to clone this form for a closer look.

    The following guide should help you inform cloning:  http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Hope this helps.


    Do get back to us if you have any questions.

  • txforesttrail
    Replied on August 7, 2018 at 8:04 AM

    Oh, dear...

    I must not have explained myself well (sorry).  I am looking for a way to calculate the "remaining" inventory in multiple widgets.

    My PROJECT:
    I actually have two groups who will be using the form. GROUP1 has priority over the other. GROUP1 gets to pick a "day" via the appointment slot widget two weeks before GROUP2.

    After GROUP1 makes a selection in the Appointment widget, a corresponding inventory widget is used to collect more specific details for the "date" they selected.

    Using the inventory widget, allows both GROUPS an opportunity to pick AM shifts or PM shifts and let's us know how many of the 4 slots for each shift are still available.

    The challenge for GROUP2, is that they select from the "leftovers". It's likely, that there will be just a few available slots scattered throught the 24 Inventory widgets.

    So, my goal was to find a way to easily show GROUP2 which of the 24 inventory widgets still have availability.

    The api references in this post. sounded interesting, but there wasn't any detailed information.

    Again, I'm open to other solutions. I'm now trying to see if embedding a report might work, but I'm not sure how to get it to display "what is left" instead of what has been selected.


  • DonaldHag
    Replied on August 7, 2018 at 11:45 AM

     Unfortunately, it is not possible to get the slots left and show them on a single page using conditional logic with the inventory widget above. The slots left only show on the inventory page:

    1533656228slots left Screenshot 10

    The workaround you mention above using a report is a good solution. Refer to this guide: https://www.jotform.com/help/326-How-to-Create-Form-Reports-in-JotForm

    I would recommend using the visual report: https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions. This will allow you to create a report that visually displays the tickets that have been purchased.

  • txforesttrail
    Replied on August 7, 2018 at 12:10 PM

    Alright, Thank you!