Clear the date field value based on the another field value change

[siva58]

HI All.

i  am using 2 fild in a table, 1. Approval,

2.Approval date.

If i am changing Approval  field value Requested  to Approve that should be populated in the Approval date  Field.it was working fine.

my requiremnt is:

if i am changing the Approval field value Approved to Requested or Not yet requested, the date field need to clear the value. but still it was showing the date .

[Aman Kumar S]

How did you achieve the first part, can you share the approach that you took?

[Ahmmed Ali · Accepted solution]

Hello @siva58 

You can create a before update business rule on your table with condition as "Approval changes AND Approval is Requested", and in script tab, write script as below to clear the approval date field.

current.approval_date = ""; //Validate the back end name of the field.

Note: you can do the same with on change client script as well on the approval field, but that would work only if someone updates approval in form view. it would not work for updates done in list view. 

Thank you,

Ali

[Pratik Malviya]

Hi @siva58 ,

From where you are setting approval date, if from BR then you can add else part and set

gr.setValue("u_approval_date","");

or if you are doing it from client side by using client script, then you can add else part and add

g_form.setValue("u_approval_date","");