App for Gear Room Tracker

Hi I am looking for an app where we add all our music gear and equipment into and then when people book it out it is shown as not available. Do you have a template for something like this?

Eg; 3 guitars in stock, one is booked out for 2 days and a teacher wants to book 3 on those days but the app then needs to tell them only 2 are available

Hi Yolandie,

Thanks for reaching out to Jotform Support. Let me help you with that:

We have created an app template for tracking music gear and equipment availability with booking functionality, just as you described. You can add your music gear, track stock levels, and manage bookings so that the app shows the correct availability when items are booked out.

You can access and start using the Music Gear Inventory app template right away.

Feel free to customize it further to fit your specific needs.

Additionally, once gear is booked back in it must show available

Hi Yolandie,

One of our Support Team members will take it from here to follow up shortly.

Hi Yolandie,

Jotform doesn’t currently have a full inventory management or equipment booking system built-in, but you can get something similar using widgets like the Inventory, Gift Registry, or Quantity Gift Registry. These widgets will automatically update the remaining quantity for the next submission. However, these widgets work on a fixed count, and once someone submits a booking, the quantity reduces automatically, but it won’t “free up” again unless the submission tied to that booking is manually deleted (for example, when the booking ends or is cancelled).

If you’d like a setup where you can see and track bookings live, you can integrate your form with Google Sheets. That way, every submission automatically appears on the sheet, and your team can easily check which items are booked and when they become available again. You can import data to an existing Google Sheet or a new sheet by using our Google Sheets Integration. Let me show you how to set that up. First, let's connect your Google account to the form:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. In the menu on the left, click on Integrations and select the Google Sheets integration.
3. Now, select Use an Existing Spreadsheet or Create New Spreadsheet and click on Next.
4. Then, click on Authenticate and connect your Google account.

Then, let's set up the integration settings:

1. Once you connect your Google account, click on Add Action.
2. In the Select a Spreadsheet section, click on Select, and (this option isn't available when creating a new spreadsheet, just an option to add a sheet name)
3. Select your Google Spreadsheet in the window that opens and click on Select.
4. Scroll down, make sure Send Existing Submissions to the Sheet option is selected and click the on Save button at the bottom right of the settings. That’s it.

Once everything is set up, your existing submissions will be sent to your spreadsheet. Any new submissions to your form will also update your Google Spreadsheet automatically. Check out the screencast below to see how it'll work:

Let us know if you need any more help.