Hi! I have looked pretty extensively in other questions and feel like I just must be missing something.
We have a diaper bank and have one field that is a Multiple Select. That field has many selection options; we don’t care about counting most of the individual items in that field but when either Pads, Tampons, or Pregnancy test is selected, I’d like the value of “1” to be entered into the Pads, Tampons, or Preg test field (so we can correctly count how many of each item we are giving out.)
Can someone please help me with the formula? Thank you!
This method is pretty dope, depending on what you’re trying to accomplish.
You’re functionally building a summary field that lets you quickly glance over records and see a “summary” of whatever you define.
There are an almost infinite number of permutations that you can use, but this is just an example.
You can also quickly build filters around what is shown in the field since you can build filters to look for specific criteria easily.
Here’s the formula that I used in that screenshot.
I wrote it fast, so I apologize if it’s dense and not the most optimized.
This example is going to be very quick and simple, but if you have a table that tracks your inventory and a table that tracks your “outgoing” records, then by linking the two tables, you can build a dynamic, simple inventory management system that updates passively with minimal effort on your end.
Using a rollup field, I can have Airtable tell me what my estimated remaining inventory is.
You can then use that information to get metrics such as how much time passes between your restocking orders.
You can see the distribution of which inventory item is used the most.
There are a ton of really dope things you can do once you start building it out.
I’m happy to explore this a bit more if you’d like!
I’d also be happy to answer any questions you might have.
I just saw @Vivid-Squid’s reply and had to take a moment to laugh. I realize that I might have completely misunderstood the counter requirement.
If that is what you’re looking to do, then this should do it.
Thank you for the clarifying question! I was so overwhelmed/busy yesterday I wish I’d taken more time to write my process out. We separately track the numbers of supplies we give; for instance, the “Additional Support” field has maybe 20 different items listed: deodorant, condoms, body wash, as well as pads, tampons, and pregnancy tests. The only numbers I want to keep a record of is the total # of pads, total # of tampons, and total # of pregnancy tests given.
Major props to you for the thoroughness here! I am going to take a moment to look more closely at the examples you shared. Here is a quick shot of my table. Currently, what we’ve been doing is, once a week or so, just manually going through and entering a value of “1” for the corresponding field if we see that option was selected. But knowing there is likely a better way, and given that we’re a tiny nonprofit and I’m pretty much AT capacity, I wanted to work smarter, not harder.
Holy cats, that would be amazing! I am tech-oriented, but also solo managing a statewide diaper program (currently distributing about 14k diapers, among many other things every month to local families in need). I designed our Airtable a few years ago when things were a lot simpler (we had 4 full-time staff and were seeing fewer clients; now it’s just me and we have 2x the number of clients) so I know there are plenty of things we could/should be doing differently/better. Please feel free to email me! firstname.lastname@example.org