Query using @getprofileField

Hi guys,

Here is a tricky question that I have come across and would like anyone who has overcome it before to please advice.

I am using @getprofilefield to return field values on a web form. Based on this field value a computed field gets generated.

I would like to know, is there a way to force the first value to be blank and force the user to select a value so that the computed vlaue will be initated.

Something similar to doing “”:@dblooup(bla bla bla).

I dont know if this is a dumb question, but the only way I could think of was placing a blank vlaue in my profile document.

Is there any other work around?

Subject: Query using @getprofileField

What about using something like this, for your choices formula:

“”: @GetProfileField(…)

Subject: RE: Query using @getprofileField

HI,

I have tried that, but unfortunately its not what I am looking for.

I bascially want the values for this field to always be cleared to blank when the value for the field above is changed.

It works on another field where I am using “”:@dblookup, but it doesn’t clear the vlaues when using “”:@getprofilefield.

Do you prehas think that using the OnChange event would help. Is there any sample code out there that i could use?

Subject: RE: Query using @getprofileField

Hi

instead of first field value in the list as blank, why can’t you insert the value as ‘-None-’ so that when user selects ‘None’, check out the field accordingly.

just hv a try !!

regards

ramesh

Subject: RE: Query using @getprofileField

Hi I used this code that I got from experts exchange in the filed above to clear the bottom field

document.forms[0].Perspective.value = “”;

Thanks for your help though.