I’m making an app to easily record and lookup all treatments given to our cattle.
When creating dependent drop downs, is there a way to make an “ALL” option?
For example, we will vaccinate an entire group of 100 cattle with the exact same thing.
I don’t want to enter that 100 separate times, but I need each cow to have that record.
I still need the option to enter a treatment for just one animal.
I have a master “Cattle Inventory” sheet with every single animal on our farm.
All of our cattle are identified by 1) Group (i.e. Spring Cows, Feedlot Calves) 2) Tag Color and 3) Tag Number.
I have a separate “Animal Health” sheet to collect treatment data (and will then have an “Animal Look Up” option so we can look up an individual animal to see past treatments).
I appreciate any help!