Auto populate some fields based on the another fields

AbhishekA
Tera Contributor

‎05-09-2024 11:19 PM

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

0 Helpfuls
  • 388 Views
5 REPLIES 5

Jaspal Singh
Mega Patron
Mega Patron

‎05-09-2024 11:33 PM

Hi Abhishek,

So what is that you have tried and stuck.

0 Helpfuls

Seraj
Tera Guru

‎05-10-2024 12:01 AM

Hi @AbhishekA 

Can you please explain more about your requirement.

 

Best Regards,

Seraj

0 Helpfuls

AbhishekA
Tera Contributor
In response to Seraj

‎05-13-2024 02:21 AM

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

0 Helpfuls

Maddysunil
Kilo Sage

‎05-10-2024 12:26 AM

@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

0 Helpfuls