Hi,

I came a cross a situation where by the particular field. Let say FIELD A.

FIELD A = NUMBER

User A = Access from range 0 to 10000

User B = Access from range 0 to 20000

User C = Unlimited.

How do I set for each users can see their own range that we preset for them ? Thanks.

For field A create script like:

If (Get(UserName)="A" and A<10000) Go To Field A

If (Get(UserName)="B" and A<20000) Go To Field B

If (Get(UserName)="C") Go To Field C

Join this script to field A in layout.

Thanks for your reply aaa!

What I want is that it validate single field only. All the above 3 users can access to the same field which is FIELD A. It is just that they can access a different value range. Like lower position staff can only view records from $0 to $10000.

Instead A in layout put Calculated field as

A_Calc=Case(

(Get(UserName)="A" and A<10000)),A,"",

(Get(UserName)="B" and A<20000)),A,"",

(Get(UserName)="C"),A,"")

Thanks. I'll try it out.

I still can't get it to work.

Attached is the file on what I am working on.

field.zip

Your attachment has password!

Your attachment has password!

Checkout the User Login.txt for the password.

Or the default login is Admin with no password set.

You have very usable idea and it can be realized.

Accsess.zip

Thanks for your compliment. Let's workout together to beat our FM solutions competitor.

Your solution works. But let say I want it to be within the single field without using the Viewing value. Can it be done ?

I am not sure, may be not! But why? If you want oportunity to change value i can say you how to do it.

I need it to be able to change the value due to this field is my selling price. It change every month due to market fluctuation.

Now i finished my work. I will answer tomorrow.

See attachment!

Accsess.zip

Your smiles is intersting!

I can see that you seldom check your mail.

I responded you today. You dont get?

Post deleted by Fei Long

From the above solution, we can control the value field base on what max value they can see.

Let say base on the max value set for them, we don't even want them to see the record at all. Not just blank out the field. Can it be done ?

Checkout my latest attachment.

Accsess.zip

Problem solved by aaa.

Accsess.zip