How to remove default value when field is empty.

Le Son
Tera Contributor

‎03-21-2024 07:58 PM

Hi everyone,

I have create default value for a field.

When create new record default value is setting for this field. However, When remove value of field (field = empty) and save record, Record still save is default value.

I want when user create new record and remove default value, record will save this field is empty

0 Helpfuls

Harish KM
Kilo Patron

‎03-21-2024 08:17 PM - edited ‎03-21-2024 08:17 PM

Hi @Le Son you can create a before insert business rule on that table

script:

// if not new record clear the field value

    if(!gs.newRecord())
    {
        current.fieldname='';
    }
Regards
Harish
0 Helpfuls

Le Son
Tera Contributor
In response to Harish KM

‎03-21-2024 08:22 PM

Hi Harish KM,

When I create new record ABC field is setting default value. However, Before save record We clear this field (ABC field = empty) and save record. 

However, Value of ABC field still save with value is default value not empty

0 Helpfuls

Harish KM
Kilo Patron
In response to Le Son

‎03-21-2024 08:37 PM

Hi @Le Son in that case create a onload client script like below

function onLoad() {
  setTimer = setTimeout(setTimerDelay, 2000); /*to set the timer for 2 sec*/
    function setTimerDelay() {
        alert('timer waits for 2 sec'); // after click new record wait for 2 secs and clear value
        g_form.setValue('fieldname', '');
    }
   
}
Regards
Harish
0 Helpfuls

Le Son
Tera Contributor
In response to Harish KM

‎03-21-2024 08:59 PM

Hi Harish KM,

Save the record then set value to empty. If user reload page this value will be not saved

 

0 Helpfuls