Half of the functionality is lost if I cannot set a trigger somewhere to send an email after adding a drone flight request. Also, I planned to set a trigger on the valve inspections to examine that top(1) record descending on last_edited to notify a crew if the valve_condition is unsatisfactory. Any help greatly appreciated.
It would be help to have more information. Your post is rather vague.
1. Is the feature class or table you want to have a trigger on versioned?
2. How are you flights inputted? Manual or automated. What is the process?
3. What is the trigger code you are using?
4. Are you using workflow manager?
5. When would the valve condition trigger fire? On flight input? on inspection? nightly/daily?