I'm a new Zoho Creator user and I've been impressed with the service overall. Very robust and simple to use. But before I can bring my organization's data over fully, I need to figure out a solution to one problem ... I can't seem to figure out how to bulk edit a check list (multiple item) field without deleting the existing data in a record. This is a frequent need so I need figure out a work around.
In another thread, "
Suggestion for bulk edit of a multiselect field", a Zoho employee indicated that scripting could be used as a work around for multi-select fields by dummy or temporary field that could hold the newly added data and then update the "master" field.
This makes sense, but I've been unable to implement the solution from that thread. I pasted the following code as a custom function, but I keep getting an error back.
- void new_upd(int ID, list:string master_list, list:string bulk_list)
- {
- mod_data = for_check [ID == input.ID]; // fetches the record
- for each item_1 in input.new_Lst
- {
- if (!input.master_list.contains(item_1)) // checks if the item isnt present in the list.
- {
- input.bulk_list.add(item_1); // adds item to list.
- }
- }
- mod_data.All_Names = input.master_list; // updates the multi line field.
- }
The error I receive is Error at line:0
Form for_check does not exist in this application
I don't know much about scripting, but I'd appreciate it greatly if someone could assist me with this.
Chris