Field Access Base On Value Range Set

[Fei Long]

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.

[aaa]

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.

[Fei Long]

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.

[aaa]

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,"")

[Fei Long]

Thanks. I'll try it out.

[Fei Long]

I still can't get it to work.

Attached is the file on what I am working on.

field.zip

[aaa]

Your attachment has password!

[Fei Long]

Your attachment has password!

Checkout the User Login.txt for the password.

Or the default login is Admin with no password set.

[aaa]

You have very usable idea and it can be realized.

Accsess.zip

[Fei Long]

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

[Fei Long]

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

[aaa]

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

[Fei Long]

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.

[aaa]

Now i finished my work. I will answer tomorrow.

[aaa]

See attachment!

Accsess.zip

[Fei Long]

[aaa]

Your smiles is intersting!

[Fei Long]

I can see that you seldom check your mail.

[aaa]

I responded you today. You dont get?

[Fei Long]

Post deleted by Fei Long

[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

[Fei Long]

Problem solved by aaa.

Accsess.zip