Calculation and edit link issue.

kirpalttc

Asked on February 9, 2021 at 4:16 PM

Hi,
I have noticed that when edit submission button is pressed it shows all hidden fields in the form and still not calculating the hours.
Thanks
Kirpal
It is from the email below that was sent to Lara.
FYI
From: Kirpal Parhar [mailto:noreply@jotform.com]
Sent: Tuesday, February 9, 2021 3:51 PM
To: Nofal, Lara <Lara.Nofal@ttc.ca>
Subject: [EXTERNAL] We have received your response for CSR Sign In Sheet

Email from outside TTC, proceed with caution

Edit Submission

CSR Sign In Sheet

Date
02/09/2021
Lara Nofal
lara.nofal@ttc.ca
Supervisor Name
Lara Nofal
Supervisor Employee No.
23949
Supervisor Email
Lara.Nofal@ttc.ca
Supervisor Phone No. (only for internal contacts)
416-899-7008
Supervisor Signature
Project/Closure Name
Subway Closure - Finch to St Clair
All Photo IDs Checked
Yes
COVID Screening Done
Yes
CSR Work Location
Finch
CSR Company
Manpower
1. CSR Lead - CUKA no.
COO12345
1. CSR Lead CUKA no. Counter
1
1. CSR Lead - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 PM - 02:00 AM (4:00)
1. CSR Lead - First Name
DAVE
CSR 1 Lead - Last Name
MCLEAN
2. CSR CUKA No.
C0012222
CSR 2 CUKA no. Counter
1
2. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 PM - 02:00 AM (4:00)
CSR 2 First Name
STEVE
CSR 2 Last Name
SMITH
3. CSR CUKA no.
C0013333
CSR 3 CUKA no. counter
1
3. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 PM - 02:00 AM (4:00)
3. CSR First Name
STAN
3. CSR Last Name
MCBEAN
4. CSR CUKA no.
C0014444
4. CSR CUKA no. counter
1
4. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
05:00 AM - 03:00 PM (10:00)
4. Total CSR Hours - Excluding Break (Auto Populated) - can be edited if needed
-0.50
4. CSR First Name
DAN
4. CSR Last Name
BILLY
5. CSR CUKA no.
C0015555 NOT DEDUCTING
5. CSR CUKA no. counter
1
5. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
03:30 PM - 01:30 AM (10:00)
5. Total CSR Hours - Excluding Break (Auto Populated) - can be edited if needed
0
5. CSR First Name
DEREK
5. CSR Last Name
PAUL
6. CSR CUKA no.
C0015556
6. CSR CUKA no. Counter
1
6. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
07:00 AM - 04:00 PM (9:00)
6. Total CSR Hours - Excluding Break (Auto Populated) - can be edited if needed
-0.50
6. CSR First Name
NORMA
6. CSR Last Name
BETTY
7. CSR CUKA no.
C0016666 xxxxxxx
7. CSR CUKA no. Counter
1
7. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 PM - 03:00 AM (5:00)
7. CSR First Name
BETNA
7. CSR Last Name
METNA
8. CSR CUKA no
C0012939XXXXXX
8. CSR CUKA no. counter
1
8. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
05:00 AM - 04:00 PM (11:00)
8. CSR First Name
BETSY
8. CSR Last Name
WESTY
9. CSR CUKA no.
C0018974
9. CSR CUKA no. counter
1
9. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
09:00 AM - 05:00 PM (8:00)
9. Total CSR Hours - Excluding Break (Auto Populated) - can be edited if needed
-0.50
9. CSR First Name
STEVE
9. CSR Last Name
URKEL
10. CSR CUKA no.
C0015864
10. CSR CUKA no. counter
1
10. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 AM - 02:00 PM (4:00)
10. CSR First Name
MASTER
10. CSR Last Name
NERD
11. CSR CUKA no.
C0036985
11. CSR CUKA no. counter
1
11. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 AM - 03:00 PM (5:00)
11. CSR First Name
DEAN
CSR 11. Last Name
SMITH
12. CSR CUKA no
C00145698
12. CSR CUKA no. counter
1
12. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 AM - 04:00 PM (6:00)
12. Total CSR Hours - Excluding Break (Auto Populated) - can be edited if needed
-0.50
12. CSR First Name
LINDA
12. CSR Last Name
CARTER
13. CSR CUKA no.
C0015975XXXNOT DEDUCTING
13. CSR CUKA no. 14 counter
1
13. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
10:00 AM - 10:00 PM (12:00)
13. CSR First Name
DAN
13. CSR Last Name
THE MAN
14. CSR CUKA no.
C0065478
14. CSR CUKA no. counter
1
14. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
02:00 AM - 10:00 AM (8:00)
14. Total CSR Hours - Excluding Break (Auto Populated) - can be edited if needed
-0.50
14. CSR First Name
CHRIS
14. CSR Last Name
CHRISSY
15. CSR CUKA no.
C0025874xxxxx not deducting
15. CSR CUKA no. counter
1
15. CSR - Shift Time (if CSR is late or leaves early you can edit this info accordingly even after submission)
04:00 PM - 02:00 AM (10:00)
15. CSR First Name
NEWS
15. CSR Last Name
MAX
Comments
FEW CELLS NOT DEDUCTING 1/2 HR BREAK
Jed_C

Replied on February 9, 2021 at 7:47 PM

1st issue: Edit link shows the hidden field is expected especially if you are logged in. It shows the hidden field because you are the admin. Try logging in using Incognito or Private browsing.
2nd issue: Hours not calculating correctly. It is because most of your hours fields has their assigned value and also you added a condition to insert some value. You can't combine a value assignment + conditional rule to insert value as it will conflict.
ex.

Either remove the assigned value or remove the conditionals rule that inserts the value. You have this method in most of your fields which is causing a conflict. Please review all of your conditions again.