Search code examples
formulalotus-noteslotusscript

ibm notes how to make computed field editable


In ibm Notes i have a document in which there is a field (for example price) when someone opens up the document, the field will be prefilled with data from somewhere else. So I made this field a 'computed field for display' but I want users to also let them edit the field, but this is not possible. So how can I make a computed field editable for users?


Solution

  • You could solve this a couple of ways.

    First you have to think of the user experience. The same field will be both computed by default and editable when needed.

    One way to make that happen is keep the field always computed and provide an edit button that launches a dialog popup to let you edit the value. Your computed formula would look for that overridden value and if it doesn't exist it would just do the calculation.

    Another solution is to have it always editable and set the value when other fields change. The code for that would be placed on the fields used in the calculation.

    There may be other ways to solve the problem and it is helpful to start with the user in mind.