How To Automatically Create A New Recorded Based On Information In Another Cell


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!


Create a new view > + Grid > Add a filter of that single select column

It will not create a separate “Task” sheet. Instead a “Task View” (sort of) will be created containing supplies with “Order Soon” and “Broken” tags.



I didn’t think about doing that. Works great, thank you very much!