'Google Tables (Area120) How to update Checklist field type?
This is for an Area 120 Tables
There are simple checkbox fields and Checklist field types.
I cannot find in the Documentation how to update the children items in the checklist from Apps Script.
Here is the code to update a checkbox:
{row: {name: r.name, values: {["Confirmation Received"]: Boolean(true)}}}
));
Area120Tables.Tables.Rows.batchUpdate({requests: updateRequest}, tableName);
Looking for the syntax on how to update the children in a Checklist.
The Checklist object has Name, and Options, but I do not know how to set the Child options in the checklist to true. I cannot find any documentation on the Field type.
https://support.google.com/area120-tables/answer/10011387?hl=en&ref_topic=10081846
Solution 1:[1]
It wasn't intuitive to me, but you send the value of the field to the name of the step you want to check. So the below code checked the Step1 box in the checklist.
{
row: {
values: {
"TestChecklist": "Step1"
}
}
},
Not sure how you would uncheck it though? Any ideas?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Mansi |