I have a survey database and 10 persons are working in the field to collect data. they enter the data every evening into the database through IWP.

I want to

1) monitor the each user and get their data seperatly. Can anyone suggest function/script?

2) is it possible to limit a user viewing the data entered by him only?

any kind of help would be appreciated

Edited June 24, 200619 yr by Guest

you can write the user name by "Get" functions. And password privilege will help you to limit users to view thair own data (record).

Could you please explain?

Edited June 29, 200619 yr by Guest

Hi, Sherif!

I think that will be easy to show records in the portal for each user.

Have one global field Curent_User and one field UserName. Create self relation on fields Curent_User and User_Name. Show portal for it.

Each user must put his UserName in global field and look only his records and work with it. If user know only his username he can't see other records.

I attached example.

UserRecords.zip

Hi Andranic,

I am thrilled by your response.

Extremly great!

Exactly what I wanted.

Once again it proves you are a FM GURU,

thank you

HI friends,

I fetched the half part,here is how this go.

I have an open scipt:

If[get(Accountname)= "John")

go to layout"one"

Else Go to layout "two"

Endif

But, I have no idea about how to limit the user viewing the data entered by him only?

Edited July 12, 200619 yr by Guest