Workflows have caused a considerable lag in one of my applications. I would love to hear feedback about how people are resolving such issues.
The app is being used to manage security camera orders. The main form is an order form, and I have a subform with locations where the cameras will be installed. Several fields dictate the status of the order and subsequent installation. The only way I have come up with to ensure the application functions properly is to have the same syntax in 12 workflows. However, doing this sets off a change of actions that has caused considerable lag. For example, fieldA changing causes fieldB to change, and the result is a change in the overall status when those values are combined with the values of other existing fields.
I am not a developer, but I have learned a lot in the past few years. That said, I am hoping there is something I am not thinking of that will reduce lag. Any feedback would be greatly appreciated.
Writer is a powerful online word processor, designed for collaborative work.