Jump to content
Sign in to follow this  
new comer

auto-enter calculation field

Recommended Posts

I have a FM7 db import records from a txt file. in the DB file, there is an auto-enter calculation field (field_B)defined as:

Case(not IsEmpty(field_A); "postive"; "negative")

where "field_A" is a simple imported text field

but even if field_A is not empty, field_B still show "negative".

Anybody know why is that? Thanks in advance!

Share this post


Link to post
Share on other sites

Got the answer form a Queue's old post! I need uncheck the 'Do not replace existing value for field (if any)' option. Thanks Queue!

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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