Jump to content

? is result


This topic is 5768 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I can't get anything but a ? to appear in a text field called "Status" with this simple autocalc lookup:

Evaluate("Updated";triggerfield)

When I enter something into triggerfield a "?" appears in the field called "Status". When I change the calculation to say 1+1 I get a 2. Status is definitely a text field expecting a text result. What am I doing wrong? Thanks in advance

Edited by Guest
Link to comment
Share on other sites

Evaluate("updated";triggerfield)

Is "updated" not merely a text constant?. What if I wanted it to calculate as this:

Evaluate(field1&field2;triggerfield)

Shouldn't it just calculate the concatenation? It doesn't. It puts a ? mark in the Status field.

Remember this is in the "Auto Enter" "Specify Calculation" area of the Options of a text field called status.

I want the word "Updated" to show in the status field if the triggerfield has any change made to it.

Link to comment
Share on other sites

Is "updated" not merely a text constant?

Yes, it is. And so is "2+2". That's what Evaluate() is all about: it evaluates its input as calculation.

Evaluate(field1&field2;triggerfield)

Shouldn't it just calculate the concatenation?

No. If you want the concatenation, then use plain

field1&field2

Putting the concatenation inside Evaluate() means you want the result of the concatention to be the expression parameter. And again, Evaluate () evaluates expression as a calculation.

If field1 contains "2+", and field2 contains "2", the result will be 4 again.

Link to comment
Share on other sites

as always, comment is right !

Try this calc too

Evaluate ( Quote ( "Updated " & Get ( CurrentTimeStamp )) ; [ triggerfield])

BTW I'm learning just now that, if the trigger field is only one, the function doesn't need square brackets !

This is from FM help on line:

Evaluate(TextField;[Amount]) returns .80 when TextField contains .08 * Amount and the Amount field contains 10.00.

Link to comment
Share on other sites

This topic is 5768 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.