Calculation and edit link issue.

  • Profile Image
    kirpalttc
    Asked on February 09, 2021 at 04: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

     

    email_logo_small.png

    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

    4887122859168101066_signature_26.png

    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


  • Profile Image
    Jed_C
    Answered on February 09, 2021 at 07: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.

    1612917947_60232cbbd9171_calculation.gif

    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.