Updating a Multiselect Lookup Field
I'm currently trying to update a multiselect lookup field in a record, but it's giving me the error {"code":3001,"data":{"ID":"3268991000041877010"},"error":["Invalid column value for Staff"]} . I've tried the list method and the collection method. The lookup field I'm calling from JobSheet and inputting are also using the same records/form. Here is the code I have so far:
- id1 = rec.Job_Sheet1.ID;
- info id1;
- addStaff = List();
- eventParams = Map();
- otherParams = Map();
- for each employee in input.Staff
- {
- addStaff.add(employee);
- }
- staffList = addStaff.toListString();
- eventParams.put("Staff",staffList);
- info eventParams;
- updateStaff = zoho.creator.updateRecord
- ("joshuabetty","atelier","All_Job_Sheets1", id1, eventParams, otherParams," creator");
- info updateStaff;