Compute Editable Field?

HCL Domino Domino Forum
1

I have 2 fields 1 dialog list and 1 editable field. Based on the selection in dialog list, at “field exiting”, i have lotus script code to populate the editable text field. But for this the users have to hit the Tab key or hit the mouse some where else on the screen for the “field exiting” code to work.

  Unfortunately users are using a Tablet PC and they feel its tough for them to do this(without a keyboard).

I tried putting formula in the editable field and it didn’t work as that works only on a computed field.

I need an editable field which changes values based on dialog list selection. Please help.

2

Subject: Compute Editable Field ?

Open Dialog Field in Designer. Go to Second Tab, tick on “Refresh fields on keyword changes”, it would compute formula for you once they make selection.

3

Subject: and if you still need the derived field as editable

then you can try putting the formual in the “Input Translation” field not the “Default”

FYI, on an editable field

the “Default” is triggered once when the document is created

it sets the current content at the start

“Translation” is triggered everytime the document is refreshed or saved

it can modify the current content

However you need to think carefully,

do you really want to change what the user has entered in all cases?

4

Subject: RE: and if you still need the derived field as editable

Thanks Alan. All these years i never knew Input Translation calculated for every refresh. Regarding loosing what users entered, the formula calculates only if there is no value in the editable field or the current dialoglist value is not equal to the old dialoglist value(I have to save what the old dialoglist value was).

Thanks again.

Raj

5

Subject: You are welcome…

as my mother often said

any day you learn something new is a good day!

BTW you can always use @IsDocbeingSaved to restrict when a formula has any effect

Hope that makes TODAY a good day as well :slight_smile:

6

Subject: RE: Compute Editable Field ?

jo ka, Thanks. That will not work on the editable field. I already tried it.