Hi all,

I'm trying to create a calculated field that could also be displayed in someway to the user,

where he/she can make changes to the calculation itself without needing to fiddle around

with "Define Fields" option.

Is this a possibility ?

Any advice appreciated!

Andreas

The best way is to make the calculation's inputs available for the user to edit, not the calculation logic itself.

If you do have a situation where you need to allow users to write their own formula, you could do it by giving them a text field to edit, and have a calc defined that evaluates that text field using the Evaluate() function.

There are a couple of problems with this, however:

• Users would not have access to the calculation dialog with its fields and functions lists, so the calcs would either need to be pretty simple, or you'd have to reproduce the fields/functions lists so they could choose things.

• There is some security risk by giving access to users to define their own calcs. If the fields are not hidden from view explicitly in the user's privilege set, they could get lucky typing in the name of a field they wouldn't normally have access to through the interface.

• The result type would need to be static, defined in the evaluate calc.

Ender,

This is helpful and I will probably go on with 'calculation inputs' to the user which should be the better way.

Thanks.

:o