I am creating a end of day banking form to include all cash and eftpos transactions recorded currently in Excel. It would be great to have a Check button that checks all the calculations against a formula column to ensure it balances prior to submitting the form. If it is incorrect then it would produce an error and not allow submitting. I am doing this with an automation to trigger an email for an error in the balance amounts but this is handling a form more times than should be necessary. Live data calculations which were being worked on since 2024 I believe would negate this requirement.
