question Make a field to true by default in Developer forum

Make a field to true by default

kpj — Mon, 21 Mar 2016 14:47:27 GMT

I created an Active field with True/False type. I have given the default Value as true in Dictionary as well. But on the form, I do not see the Active as true i.e., Active check-box is not true.

I really appreciate for your valuable answers

Thanks,

Re: Make a field to true by default

salvadormar — Mon, 21 Mar 2016 14:53:10 GMT

KP,

Either check the Business Rule or Client Script for a start...search the field for that table...there could be an inherit script somewhere,,,please let me know if this helps...Cheers, Dor

Re: Make a field to true by default

rbeeman — Mon, 21 Mar 2016 14:54:48 GMT

If you are setting the default value to a boolean true (no quotes around it) then it should be working. I just verified it in my dev instance. If you just created the field then it won't set it for pre-existing records, only records created after the default was defined.

Re: Make a field to true by default

reedwowens — Mon, 21 Mar 2016 14:55:04 GMT

Jack,

Here are some screenshots on Geneva with this working:

This is a new table I created:

Just setting the default value to true works. Do you have any Business Rules or UI Policies overriding the default value?

Re: Make a field to true by default

Mihir Mohanta — Mon, 21 Mar 2016 14:59:25 GMT

Hi Jack,

The records already present before adding default value of active to true will not reflect their active value as true.

Create new record to this table . All new records will be defaulted to active true.

Thanks,

Mihir

Re: Make a field to true by default

kpj — Mon, 21 Mar 2016 15:00:21 GMT

Thank you All for quick response. I do not have any Business Rules or Client Script running on this form.

Robert - Yes, I have pre-existing records and these records are also need to be set True.

Just to be Specific on my problem: I have pre-existing records on a Table and I want all those records to be set as true

Re: Make a field to true by default

kpj — Mon, 21 Mar 2016 15:01:53 GMT

Hi Mihir,

I have 1000's of pre-existing records. Is it possible to make them true as well.

Thanks,

Re: Make a field to true by default

Mihir Mohanta — Mon, 21 Mar 2016 15:03:43 GMT

Yes Jack,

You need to run a back ground script and set all record active true.

Thanks,

Mihir

Re: Make a field to true by default

rbeeman — Mon, 21 Mar 2016 15:03:54 GMT

You could right click on any column header of a list view of the table and "Update All". If you only check that box, that will be the only change to all of the records.

Re: Make a field to true by default

shristy2 — Mon, 21 Mar 2016 15:35:09 GMT

Hi Jack,

You can write a client script : SNOW - Active True

function onLoad() {

//Type appropriate comment here, and begin script below

g_form.setValue('Active','true');

}

Mark if it is helpful or correct, feedback is appreciated

Thanks