Creating a custom sublist dynamically inside a Record

if(Record_Roles[recordStatus]==runtime.getCurrentUser().role|| runtime.getCurrentUser().role=='3'){
                        let skillSelected =  scriptContext.newRecord.getValue({fieldId: 'custrecord_jj_skill_rec_req'});
                        log.debug("skillSet",skillSelected)
                        let startDate = scriptContext.newRecord.getText({fieldId: 'custrecord_jj_rec_req_start'});
                        let endDate = scriptContext.newRecord.getText({fieldId: 'custrecord_jj_end_date_rec_req'});


                       
                        let suggestionDetails=getEmployeeDetails(skillSelected,startDate,endDate);
                      
                        let customTab= scriptContext.form.addTab({
                            id: 'custpage_resource_tab',
                            label: 'Resource Availablity'
                        });
                      
                        let sublist = scriptContext.form.addSublist({
                            id: 'custpage_my_sublist',
                            label: 'My Sublist Label',
                            type: serverWidget.SublistType.STATICLIST,
                            tab: 'custpage_resource_tab'
                        });


                       
                
                        // Add fields to the sublist
                        sublist.addField({
                            id: 'custpage_resource',
                            label: 'RESOURCE',
                            type: serverWidget.FieldType.TEXT
                        });
                
                        sublist.addField({
                            id: 'custpage_skill',
                            label: 'SKILL (Skill Level)',
                            type: serverWidget.FieldType.TEXTAREA
                        });


                        sublist.addField({
                            id: 'custpage_skill_level',
                            label: 'Projects ( Start date - Calculated End Date )',
                            type: serverWidget.FieldType.TEXTAREA
                        });
                        for(let i=0;i<suggestionDetails.length;i++){


                            let employee= Object.keys(suggestionDetails[i])
                            log.debug("empss",employee[0])
                            sublist.setSublistValue({
                                id: 'custpage_resource',
                                line: i,
                                value: employee[0]
                            });


                            sublist.setSublistValue({
                                id: 'custpage_skill',
                                line: i,
                                value: (suggestionDetails[i][employee[0]]['skill']).join('n')
                            });
                            let project=suggestionDetails[i][employee[0]]['projects'];
                            log.debug("projectdsdd",project)
                            sublist.setSublistValue({
                                id: 'custpage_skill_level',
                                line: i, 
                                value: (suggestionDetails[i][employee[0]]['projects']).join('n')
                            });
                        }
                
                    }

Leave a comment

Your email address will not be published. Required fields are marked *