How to auto-populate a set of field with a given set of values upon creation of a change record.

[Shwetha Shenoy]

Hi Community, here is a use case I need to auto-populate a set of fields with a given set of values (like how we do it for standard change upon creation)  but for a different change model.

Not using any kind of templates here, please suggest to me any other way that I could use to solve this use case.

Please help me resolve this use case.

Thanks in Advance.

[Danish Bhairag2]

Hi @Shwetha Shenoy ,

Certainly! In your scenario, you can create an `onBefore` Business Rule that triggers before a new record is inserted. This rule will check the specific conditions you define and populate the fields accordingly. Here's a more specific explanation of the steps:

### Creating an `onBefore` Business Rule:

1. **Navigate to Business Rules:**

   - Go to `System Definition` > `Business Rules` in ServiceNow.

2. **Create a New Business Rule:**

   - Click on `New` to create a new Business Rule.

   - Choose the appropriate table (the table for your change model).

3. **Configure Business Rule Conditions:**

   - Set the `When to Run` field to `Before`.

   - Define the conditions under which the Business Rule should run. For example, you might want to check the type of change or other specific fields to identify the records that need auto-population.

4. **Write the Script:**

   - In the `Advanced` tab, write a script that checks your defined conditions and populates the fields accordingly. For example:

   (function executeRule(current, previous /*null when async*/) {

       // Check conditions to identify the specific change model records

       if (current.type == 'specific_type' && current.field_name == 'specific_value') {

           // Populate fields with desired values

           current.field_name1 = 'desired_value1';

           current.field_name2 = 'desired_value2';

           // ... Populate other fields as needed

       }

   })(current, previous);

   Ensure that you customize the conditions (`current.type`, `current.field_name`, etc.) to match the criteria for the records you want to auto-populate.

5. **Test the Business Rule:**

   - Create a new record that meets the defined conditions to trigger the Business Rule.

   - Verify that the fields are auto-populated as expected.

By using an `onBefore` Business Rule, the fields will be populated before the record is inserted into the database, ensuring that the desired values are set during record creation based on your specified conditions.

Mark my answer helpful & accepted if it helps you resolve your query.

Thanks,

Danish

[Shwetha Shenoy]

Hi, 

This isn't working when we create a new record without saving, after saving the record the fields are getting auto-populated. 

I need to auto-populate the values upon creation itself.

Please find the below screenshot of the Business Rule :

 

Thanks @Danish Bhairag2 

[Sandeep Rajput]

@Shwetha Shenoy You can use the Template feature to create a template for the change request and then apply the template on the form to auto populate the fields.

Also, from the previous post it looks like the business rules are out of equation for you as you would like the template to be applied on the form itself before the changes are saved in databse.

Here you can either use the template feature or use a onLoad client script to populate the data on the form.

Hope this helps.

[Shwetha Shenoy]

Hi @Sandeep Rajput,

Templates weren't allowed to be used in this use case, but the on-load client script seems to work nicely. Thank you so much.

But here is one more problem that I am facing is how to populate a field (HTML type) with a table.

Please find the below screenshot for a better understanding :

Upon creation of a new change record , this Input field should have a table with rows and columns in it. So that the values could be populated by the user. 

Thanks again.