How to make new inventory items automatically link to the corresponding room in our building by linking or with a formula or automation.
When a new item is added, how can I make that item auto populate in another tab by room (multi select)?
This is the base.
We have a robust inventory with “ALL ITEMS” and items by room. We want each item entered into “ALL ITEMS” to populate in the room selected via “multiselect.
This shows the multiselect tab.
Any assistance is greatly appreciated!
Well you have a data structure issue here, your rooms shouldn’t each be their own table, rather there should be one table “Rooms” with 11 records (rows). Then you could use a linked record field from the Items table to connect to the Rooms table.
This whole structure needs an overhaul, but if you just want to brute force this (and there will be additional problems) you could do it via automation. Something like when Record in All Items Field Category is updated, Conditional Logic If “Operations”, Create New Record in Op Teams Table. Then you just add all the necessary conditionalities.
There’s a multitude of issues with that solution (primary among them is that the data won’t update automatically like a linked record field would) but that’s how I would approach it if rebuilding was off the table.
Thank you so very much. I’ll approach it that way and give it a try.
That’s a great suggestion
Then, you can create a Grid View for each of the rooms where you would filter for the Room record, like so:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.