Hi @rrrrrrrrrrrr,
Here is a solution for your problem.
1. **Create a Custom Table:**
- Navigate to `System Definition` > `Tables`.
- Click on `New` to create a new table.
- Define your table with the required fields (`username` as a reference type and `waiting_for_approval_request_count` as a string type).
- Save the table.
2. **Write a Script Include:**
- Navigate to `System Definition` > `Script Includes`.
- Click on `New` to create a new script include.
- Define your script include with a suitable name (e.g., `ApprovalRequestCountUtil`).
- Write a function in the script include to fetch the count of approval requests for a given user. Here's an example function:
Script
var ApprovalRequestCountUtil = Class.create();
ApprovalRequestCountUtil.prototype = {
initialize: function() {},
// Function to get the count of approval requests for a user
getApprovalRequestCount: function(userId) {
var count = 0;
var approvalGr = new GlideRecord('sysapproval_approver');
approvalGr.addQuery('approver', userId);
approvalGr.addQuery('state', 'requested');
approvalGr.query();
while (approvalGr.next()) {
count++;
}
return count.toString();
},
type: 'ApprovalRequestCountUtil'
};
```
- Save the script include.
3. **Usage in Client Script:**
- Now, you need to use this script include in a client script attached to the form where the `username` field is present.
- In the client script, write code to call the `getApprovalRequestCount` function from the script include when a user is selected in the `username` field. You can then update the `waiting_for_approval_request_count` field with the count returned by the function.
Here's an example of how you might write the client script:
Script
function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue === '') {
return;
}
var approvalCountUtil = new ApprovalRequestCountUtil();
var count = approvalCountUtil.getApprovalRequestCount(newValue);
g_form.setValue('waiting_for_approval_request_count', count);
}
```
Replace `'waiting_for_approval_request_count'` with the actual field name where you want to display the count of approval requests.
With this setup, when a user is selected in the `username` field, the `waiting_for_approval_request_count` field will be updated with the count of approval requests for that user, fetched using the script include. Adjust the code as needed based on your specific field names and requirements.
Please hit helpful and accept my answer as a solution if it solved your problem.
Regards,
M.Ismail
