Skip to main content
Solved

Trying to create an inventory base for inventorying fire trucks every 6 months

  • March 21, 2025
  • 1 reply
  • 9 views
S
Forum|alt.badge.img+14

Have built 4 tables to collect inventory information on our fire department’s truck inventory.

Tables:

  • cabinets i.e. E-211 Cab. #1
  • items i.e. 2 1/2” Brass Male to Male Coupler
  • inventory: list and # of item in each cabinet
  • archive inventory: because the governing body wants it.

I am trying to create this using Interfaces. What I am trying to do is use a Record Review template that has the cabinets in the left pane and the inventory items for each cabinet in the right pane. I have been successful in that. I have a working Inventory Interface page. The item list is complete (2,501 items). The Cabinet list is complete (65 cabinets).

Truck Captains will use an iPad to open Airtable to the Inventory interface and choose one of the truck/cabinets they are responsible for from the left hand list and check off the inventory items they find. If they find an item missing or the quantity less than that listed they will enter that number in the OH field. When they finish that list they will open another cabinet on the left and start it. There are 8 trucks with a total of 65 cabinets so eight Truck Captains will be doing this.

When all the cabinets are finished I want to have a button to click that will run an automation that will run a script that copies the entire inventory into an archive inventory table, clear the data from 3 fields in the Inventory table and send an email saying that the inventory is complete. I have the script.

Problem, Record Reviews do not have a button function that will allow me run an automation. So I thought about using a blank page instead of a Record Review page so I could have an automation button, but I cannot figure out how to duplicate the function of the Record Review page.

So I thought that I would take the blank page and put a button on it that would allow me to run the automation that runs the script. I cannot figure out how to do this. I am stuck.

I have tried to use a record picker to get the button to update a record in a table I created to hold a field that could be updated. I stopped there because now my head hurts.

Does anyone have some guidance nohow to proceed?

Thanks, Scott

Best answer by Scott_Brasted

Ha! I figured out a way to do it. I will describe it in case anyone else ever thinks this is a good idea. Ugh.

I created a summary table with the date of the inventory as a field and a checkbox field called Completed. I then created a Blank Interface page that has 2 text boxes for information for users and a grid linked to the summary table with the date and check box field showing and allowed edits. So far so good. 

Then I created an automation that checks for a change pin the check box field. Clicking the check box field runs the script. The script archives the inventory, clears the 3 fields used to collect data and sends an email telling the chiefs the inventory is done. The archive table can be shared with the government body that requires all this nonsense.

So, that’s it.

Thanks, Scott

View original
Did this topic help you find an answer to your question?

1 reply

S
Forum|alt.badge.img+14
  • Scott_Brasted
  • Author
  • Inspiring
  • 47 replies
  • Answer
  • March 21, 2025

Ha! I figured out a way to do it. I will describe it in case anyone else ever thinks this is a good idea. Ugh.

I created a summary table with the date of the inventory as a field and a checkbox field called Completed. I then created a Blank Interface page that has 2 text boxes for information for users and a grid linked to the summary table with the date and check box field showing and allowed edits. So far so good. 

Then I created an automation that checks for a change pin the check box field. Clicking the check box field runs the script. The script archives the inventory, clears the 3 fields used to collect data and sends an email telling the chiefs the inventory is done. The archive table can be shared with the government body that requires all this nonsense.

So, that’s it.

Thanks, Scott

Reply


Most helpful members this week

Terms & Conditions