Creating Formulas in Bovi-Insights

Creating Formulas in Bovi-Insights

All event formulas need to function for all event types. For example, a formula for treatment events won't work because the specific treatment type (specific event) is an integer and fails when texts are used. Here is an example formula ""=event_at_lactation(""trt"",""date"",""treatment"",""Lutalyse"",""-1"",""-1"",""-1"")"" will not work but the same formula with the number will work, ""=event_at_lactation(""trt"",""date"",""treatment"",""53"",""-1"",""-1"",""-1"")"".

When creating a formula in an Animal Report, we have to look up the number of the vaccination, treatment, protocol like this example - ""=event_at_lactation(""prot"", ""date"", ""protocol"", ""63805"", ""-1"",""-2"",""-1"")"".

It would be easier to copy and paste the title of the vaccination, treatment, protocol instead of trying to find the number. So, the example above would be ""=event_at_lactation(""prot"", ""date"", ""protocol"", ""Dry vacc"", ""-1"",""-2"",""-1"")"