Hello @civilvicky
Yes. You can insert a checkbox field as the last column, as you did with the other fields, and use them in the equations.
For example, your first row includes the “Total” fieldname5, the second row the “Total” field fieldname10, and the third row the fieldname15. Furthermore, you have “Total Cost” field that sum them: fieldname5+fieldname10+fieldname15
Assuming you have a checkbox field per row, fieldname20, fieldname21, fieldname22, respectively. And you want to add the “Total” values in the “Total Costs” equation only if the corresponding checkbox is ticked.
In this hypothetical case the equation could be edited as follows:
IF(fieldname20, fieldname5, 0)+IF(fieldname21, fieldname10, 0)+IF(fieldname22, fieldname15, 0)
And that’s all.
Best regards.
I think I have messed up something, check it once https://hindistatuslibrary.com/?cff-form=1
Hello @civilvicky
You left empty the value of the checkbox fields. Please, enter number one as the choices’ values. You can leave the choices’ texts empty but not their values.
Best regards.
Yeah Got it. I was wondering if we can created the tables with calculation just like the same in excel sheet
Hello @civilvicky
I’m sorry. Excel manages concepts like columns (A, B, C, …), rows (A1, B3), and cells range (A1:D1), but our plugin is not an Excel interpreter or emulator. You cannot apply the same concepts.
Best regards.
Ok. Thank you for the help.
P.S : Can the number of checkbox be counted. For example if there are 10 check boxes and out of which 8 are selected, it should display the total selected check boxes number i.e 8
Hello @civilvicky
If you have entered number one as the choices’ values, you only need to sum the checkbox fields fieldname17+fieldname18+fieldname19 and so on.
Best regards.
