I have a form that we developed for submitting PTO Requests. It has worked well for months. Now I have an issue that cropped up since I upgraded to Forms 10.2.1.
I have a field, that is part of a table that adds up the upcoming PTO days that are pulled from a table that is populated from a lookup. If there is populated data from the lookup there are no issues.
However, if there is no data populated from the lookup then no data is placed in that field. This causes another an error on submission. A Laserfiche employee at the help center at the LF conference in February helped me do a formula that accounted for missing data and put a 0 in if there was no data from the lookup. Here is the formula: =MAX(SUM(OpenPTORequests.Hours_Requested_1),0)
This formula worked fine until the upgrade.
Thoughts?