Single click checkbox + update multiple records at once

[Joshua]

Hi all,
Part of my app is used to reconcile our different credit cards. I have a table that shows all credit card transactions. I have a field called “Add to report” that is a checkbox. Right now, I have turned on inline editing and you have to click the field, and then you can click the checkbox. Is there a way to be able to just click the checkbox without having to click the field first?
Also, I do not want any of the other fields to be changed. With inline editing turned on, someone could click and change something. Can I turn off inline editing for some fields?

Once all of the transactions are added to the report and it is reconciled, I would like a button that will update all records to change a field called “Reconciled” to “Yes”. I can’t seem to find a way to update multiple records simultaneously. Currently, I have to go into the Knack Builder and update the records from there.

Thanks.

[Sunny_Singla]

Hello Joshua,

Yes, this can be done using some javascript. But turning off inline edit for other fields is easy to go to each field and there is an option to turn off inline edit.

Thanks,
Sunny Singla
ssingla1985@gmail.com
+919855089359

[Joshua]

Thanks Sunny. I found where to turn off inline editing for those other fields.

Are there any javascript examples you can point me to?

[Sunny_Singla]

Hello Joshua,

Please check the below link

Update multiple records with a checkbox

This first requires you to add the checkbox snippet from this example:  Add checkboxes to a table This following snippet will add an "Update" button below your view header and update all checked records with the data you specify in the data variable. Once all records are updated, an alert will display confirming the update. Note: This still needs some work! There's no function to catch errors, etc.   var addCheckboxes = function(view) { // add the checkbox to to the header to select/unsele…

Thanks,
Sunny Singla
ssingla1985@gmail.com
+919855089359