Checkmark fields in this table

[Josef Senti]

I have a lot of rows in a table field. One of the columns is a checkmark field to take record if I have seen this episode. (image in the attachment)

Now I try to write a script that sets all the checkmarks to false in this table for this series.

I found out how I can change a checkmark field alone, but not when it’s in a table.

Can someone pleas help me.

Ideally I’d like to press a shortcut and all the checkmark fields in this table get set to false.

Attachments:

You must be logged in to view attached files.

[Daniel Leu]

You’re using a custom layout. So you can add a button that will launch a form script.

What you do is get the field value of your table field. This is an array of records. Each record represents a row in your table. Then you just loop over it and clear the checkmark field.

Here’s the form script. You just have to set the ID of the aforementioned fields

function Clear_Checkmarks() {
	const table_id = 'fld-xxx'; // id of your DVD Verwaltung table
	const table__check_mark_id = 'fld-xxx'; // id of your Gesehen field

	let tableRecords = record.getFieldValue(table_id);
	
	tableRecords.forEach((a) => {a.setFieldValue(table__check_mark_id,0)});
	document.saveAllChanges();
}

Clear_Checkmarks();

;

• This reply was modified 1 month, 1 week ago by Daniel Leu.

[Josef Senti]

Thank you so much! This is perfekt!!
And I finally found the button you mentioned;)

[Author]

Posts