Link only active employees in custom doctype

NCP · October 7, 2023, 12:59pm

Please apply the clinet script for it.

frappe.ui.form.on("ESIC Monthly Contribution Form", {
    refresh:function(frm) {
        frm.set_query("employee", function() {
            return {
                "filters": {
                    'status': "Active"
                }
            };
        });
    }
});

Please check/set the doctype and field name in the script.

Reference: Overriding Link Query
I hope this helps.

Thank You!