Need help running the calculate event depending on a checkbox value | Community
Skip to main content
nowackem
New Participant
January 10, 2022
Solved

Need help running the calculate event depending on a checkbox value

  • January 10, 2022
  • 1 reply
  • 720 views

Hi all,

I'm having trouble incorporating the calculate event to execute depending on whether a checkbox is checked or unchecked. Seems like any way I go, they will not play together. This might be easy for a JS expert but its not working for me. So below is a link to the form and I have stripped it of anything I've tried that didnt work so you can have a clean slate. I have two tables on this form that are essentially the same thing so if we can get the top one working I can get the second one working on my own.

 

Here is how it should work. The repeating row in the first table (tblWarrants) has a Quantity (quantity) and Unit Cost (unitCost) fields when multiplied together will show that value in either the Maint. Cost (maintCost) or Engr. Cost (engrCost) fields. What determines this is if the checkbox (cbEng) is checked or unchecked. If cbEng is checked then I need the calculation to run on the engrCost field and show the value. When the cbEng checkbox is unchecked then I need cbEng to be null and the maintCost field to calculate its value. Upon opening or by default, I need the cbEng to be unchecked and engrCost field to be empty/null. 

 

https://drive.google.com/drive/folders/10wPFynb1frPGLHtdwaclgRTUDfyYaHek?usp=sharing

 

Thank you!

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Mayank_Tiwari

@nowackem Please check out this form and let me know if it is working as expected. Thanks!

1 reply

Mayank_Tiwari
Mayank_TiwariAccepted solution
Employee
January 11, 2022

@nowackem Please check out this form and let me know if it is working as expected. Thanks!

nowackem
nowackemAuthor
New Participant
January 11, 2022

Thank you! That's perfect.