Auto populate some fields based on the another fields

[AbhishekA]

Hi All,

I have a question here . i need to auto populate some of the refrence fields and store them in the custom table. from that table it should be given to the dashboard. please help me out here

[Jaspal Singh]

Hi Abhishek,

So what is that you have tried and stuck.

[Seraj]

Hi @AbhishekA 

Can you please explain more about your requirement.

Best Regards,

Seraj

[AbhishekA]

I am creating a business rule in which it should autopopulate some refrence fields and store that values in other custom table which is used for dashboard

[Maddysunil]

@AbhishekA 

1. Create a Business Rule: Write a Business Rule that triggers on the insertion or update of records in the source table (the table from which you want to auto-populate reference fields). In this Business Rule, you can include script logic to fetch data from the source table, populate the reference fields, and then insert/update records in your custom table.

2. Populate Reference Fields: Within the Business Rule script, you'll need to query the required data from the source table. Then, set the values of the reference fields in your custom table accordingly.

3. Store in Custom Table: Once you've populated the reference fields, insert or update records in your custom table with the relevant data.

4. Display on Dashboard: After data is stored in your custom table, you can create a ServiceNow dashboard using Performance Analytics or Reporting modules. Configure the dashboard to fetch data from your custom table and display it as per your requirements.

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks