General

Re: Creating formula from fields

richlane — Wed, 28 May 2008 08:00:15 GMT

Hi Clay,

I will look at doing that. I was just trying to save myself some time ;)

Thanks for the quick response.

Re: Creating formula from fields

Clay Fox — Sat, 24 May 2008 04:35:51 GMT

Interesting...

I would think you would need to create a rule for each operator case. So you have static operator comparisons but make one for each possible choice.

Hope that helps.

Creating formula from fields

richlane — Fri, 23 May 2008 15:31:10 GMT

I have been struggling with this and am not sure if there is a no-code solution, but I am hoping someone can help.

I am trying to create a Data Validation rule that uses an expression with an operator inserted from a user defined field. So for example a user enters 2 values into fields 1 and 2, selects the operator > in a 3rd field. If field1 is > field2, then the validation is activated.

Creating an expression with a static operator is simple enough, but I need this be able to be dynamic based on the users selection.

Is this possible? Any help is greatly appreciated.

Rich