ERASING an existing date field with trigger

Posted by Rollbase User on 07-Sep-2010 18:51

If I am using a trigger to REMOVE the date from an existing fields when it runs what would i put in the formula field to make it remove the existing date?

All Replies

Posted by Admin on 07-Sep-2010 18:54

I tried this but no go - {

var currentTime = null;

}

Posted by Admin on 07-Sep-2010 19:07

Please try trigger of type "Object Script", than use API setField().

Posted by Admin on 08-Sep-2010 13:07

I see how I can use that with API but if I wanted to keep the existing trigger I am using now - "Update Field Value" what code would i use to erase the date currently in a date/time field?

Posted by Admin on 07-Mar-2012 04:22

Hi, any update on this? I need to update a date to nothing/null but it does not work.

Posted by Admin on 07-Mar-2012 11:20

Please see my reply above.

Posted by Admin on 16-Mar-2012 14:21

In a object script trigger, place the following code:



(Replace my_object_name w/ integration name of object and replace my_date_field w/ integration name of date field):





rbv_api.setFieldValue("my_object_name", {!id}, "my_date_field", "");

This thread is closed