How to get a sum for "Total Points" based on "Points" entered for attendance and show it in the "Total Points" field on the same form.
I am a newby...so bear with me. I have a form called, "Employee Personal Data" for personal employee info. I then have a form called "Employee Attendance Record." On this form I have a field called "Points" to enter .5, 1, 1.5, 2, etc. as points for an absence. Once entered, I want the "Total Points" field on the Employee Attendance Record form to show the running total for the year for that particular person (up to 12 points total).
I have a Lookup Field to pick the employee's name from the Employee Personal Data form.
I can't figure out the Deluge Script to get this total. It's probably simple, but after studying Deluge, I'm just not getting it yet. Can you help?
Thanks,
Jack