Expression builder

[katesmith1985]

Hello,

I am working on a customer database and I have a field consisting of a 5 digit reference. I have created a new field which I want to update with just the first 2 characters of the 5 digit reference. Can anyone help me in writing the correct expression to do this?

I am very new to Alpha 5.

Kate

[MoGrace]

Hi Kate - Welcome to the board!
To populate the new field with existing data from the other field try an Update operation. Assign a calculated value to the new field such as
left(fieldA,2)

After the update, you can set a field rule to do the same calculation automatically on data entry.

[Al Buchholz]

Hi Kate - Welcome to the board!
To populate the new field with existing data from the other field try an Update operation. Assign a calculated value to the new field such as
left(fieldA,2)

After the update, you can set a field rule to do the same calculation automatically on data entry.

I'll add a note before Dr. FussBudget does...

A safer way is: (just in case the field is not left justified... unless you want the spaces that might be there....)

left(alltrim(fieldA),2)

or

left(ltrim(fieldA),2)

[MoGrace]

Now who could Mr. Fussbudget possibly be??? Surely you don't mean Ira the function purist?

[Al Buchholz]

Now who could Mr. Fussbudget possibly be??? Surely you don't mean Ira the function purist?

No not at all. I'm thinking of the Murphy's cousin that always attacks my code with the unexpected data variations.

Vaguely related to Dr. Nitpicky

[shivab]

I am new here and have just started using alpha for development.
I am trying to get a value of YES or NO assigned to a field1 on the grid, based on whether field2 value is between field3 and field4. field2, field3 and field4 are numeric.
I used the property "calculated field expression" for field1 as follow:
if( (field2 < field3 or field2 > field4), 'NO','YES')
the client side value for field1 evaluates correcty, but when it is posted to the database, it always whatever evaluates to true condition. I mean the value stored is always NO.
Am I doing something wrong?
Can somebody correct me?

Appreciate any input
Shiva

[Al Buchholz]

Please attach an image of the expression builder that you are using.

Also how is the field1 defined?

[johnkoh]

try

if( (field2 < field3 .or. field2 > field4), 'NO','YES')

[MoGrace]

If(field2 < field3,"no",if(field2 > field4,"no","yes"))

[GGandhi]

fld1=if(fld2 > fld3 .and. fld2 < fld4,"Yes","No")