HI everyone! Im creating a base for my company operations and I have a table with our supplies (paint, clear coat, sand paper, rags, etc.) and another table with tasks. When we have supplies that are running low I would like to be able to update that in the supplies table, lets say by creating a single select column and have an option for “Order Soon” then when I select that I want a new record to be created in the Tasks table to tell me I need to order more paint. I also have an equipment table that shows what tools and equipment we have and their condition so I would like to be able to do the same here so for example if something is broken I could create a single select option for “Broken” and when that is selected a new record is created in the Tasks table to order a replacement.
I hope this makes sense. If I should explain further please let me know.
Thank you for any help or work arounds or any advice!