text input in calculation field
In a calculation field i like to evaluate value's of an another field. So far not a problem. The result can be data comming out of another datafield or a possibillity to type the data in.
Which function do i need to aid to the If function to make it possible to type in data?
You can use two options:
Have the calculation field a text field, set to have auto-entry of the calculation that you would have put into it. Then you can edit the data if you want.
Have another field TextFieldOverride, set to be a text field. Set the calculated field to be:
Case ( TextFieldOverride = "" ; <the calculated result you want to use> ; TextFieldOverride )