set / reset a field's value to blank

[dervaish]

hello...

i have 3 fields [type [listbox], date1, date2]...

i want to set/reset date-field-1 and date-field-2 to blank [if not already blank] if a user changes the value of drop-down-list-box.

for example

initial value selected...

Value selected = 1

date 1 = 12/12/2007

date 2 = 12/12/2006

and then when the user selects

value selected = 2

date 1 = "" [changes/reset to blank]

date 2 = "" [changes/reset to blank]

also i want to keep date 1 and date 2 fields active to receive input from user.

so how can i accomplish this?

thanx in advance for ur help and input.

[mr_vodka]

http://fmforums.com/forum/showpost.php?post/291180/

Edited May 20, 2008 by Guest
Took out reference to Comment

[comment]

That's not my file - I only fixed the relationships in that one, and didn't even look at the field definitions. The calculations in that file are a bit convoluted and they use Evaluate() to trigger the change, which IMHO is not good practice.

The original demo of conditional value list with self-clearing field is posted here:

http://www.fmforums.com/forum/showpost.php?post/195641/

[mr_vodka]

Ah sorry I should have been more precise. :

[comment]

No, it's me that should have been more clear. I have added a similar clarification to the referenced thread.

[dervaish]

thanx for the replies and help guys. this will still not solve my problem bcos the fields i want to set/reset to are in the same table [same row infact] and are date-format. 3rd field is a dropdown listbox [again same table, same row] and based on its selection i want to set/reset the other two date-fields to blank.

once again thanx for the help.

[comment]

Same principle, only easier to implement:

ClearFieldOnTrigger.fp7.zip

[dervaish]

ur a life-saver comment. that last solution worked perfectly. i no longer need the script i was using to clear the fields. also now i don't have to worry about the extra line my script was adding to the log file which is keeping track of all the changes as they happen. now with you 1 line solution, everything is in place.

thank you so very much for your help. B)