I want to validate some data input by comparison among criteria. To do that I need to subtract two values. Is it possible to do that in data capture?
Is this a good question?
@simbed there currently isn't a way to do automated calculations at this moment in time but I'll put in a feature request on your behalf.
In the meantime, a possible solution could be to add a signoff to the step that requires the calculation. The person who does the signoff could subtract the numbers and either approve or reject it. Another option could be to set a minimum and maximum in the data capture form. A worker could then do the calculation and enter the value, if it doesn't match the criteria, they won't be allowed to continue.
Was this answer helpful?
Thank you! Your workaround solution seems good enough for now. I will follow the feature request for the future.
@simbed there isn't a direct solution for that but there may be a work around. If you can provide me with an example and some more details, I can see what's currently possible.
by Amber Klein
I want the user to enter two values and then compare the difference between these numbers to a criteria and return a pass or fail tag. We were used to use Excel spreadsheets to do this kind of thing. I would be glad if I could get rid of Excel.
by Simon Bedard