Need to create new field with default value

[navdeep_singh]

I want to create a new field (integer) with a value"0" on Incident table.   I want this value to be applied on new as well as existing records.

Will the "Default Value" work? if not please suggest any other option.

Thank you,

Navdeep

[Anurag Tripathi]

aha...cool

[telmo]

Chuck,

I've also checked that before replying, and:

Telmo

[Chuck Tomasi]

Interesting. I wonder what we did differently. To compare notes here's what I did:

1. Went to the incident list
2. Used Configure table
3. Added new field called Count (u_count) with a default value 0
4. Clicked Update
5. Ran the script above.

Any difference?

[telmo · Accepted solution]

And they weren't updated:

Yes, we did it differently.

I went through the dictionary

1. went to System Definition -> Dictionary. Clicked on new

2. Choose the incident table, Integer type, and added 0 as default value:

3. Clicked on Submit

4. Run the script to confirm:

Telmo

[navdeep_singh]

Hi Telmo,

I just checked, it is working for me also. Is there any particular condition when the default value will affect the existing records.

Scenario 1)   -I have created new field using Form Layout then set the default value by configure dictionary .

          Result - did not work for existing records.

Scenario 2) I have created new field from Tables >> Incident >> Table Colums >> using Embeded List

                  Result -did not work for existing records.

Scenario 3) I have created new field from Tables >> Incident >> Table Colums >> New

                  Result -   Worked

Issue - If a new field is created by using two methods   Scenario 1), Scenario 2),   how can i set the value for existing records?