Jump to content

Clearing Fields on date entered

Recommended Posts

I need help please

I have three fields

Due Date, Days Till Due and Issued date.

I am having a problem on working out a script that when the Issued date as been populated

I need the Due Date and Days Till Due for the fields to be cleared but I cant figure out how to do this.

Thank You


Link to post
Share on other sites

Easiest would be a script trigger when you exit the 'issued date' field, to just set the other two fields to "" .  But it could have unintended consequences.

For example, what happens if you accidentally populate the issue date or populate in the wrong record?

I guess your script could first ask if you want to clear the other 2 fields.

Edited by Steve Martino
Link to post
Share on other sites

If you really want the DueDate field to be cleared when IssuedDate is populated, you could define it to auto-enter a calculated value (replacing existing value) =

If ( not IssuedDate ; Self )

However the downside of this (or any other method that does what you asked for) is that you will lose the original due date value - even if you enter an issued date value accidentally. So perhaps it might be smarter to hide the field or format it conditionally.

I presume the  DaysTillDue is an unstored calculation field? If so, you could simply add a condition to the calculation - for example:

If ( not IssuedDate ; DueDate - Get ( CurrentDate ) )


Link to post
Share on other sites

Thank you Comment

I went with the hide field as then I will still have the record I didn't think of that

Thank You


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.