CALCFIELDS

Kc_Nirvana

Hello
I have a table 50000 that had this fields
1 No.
2 User
3 Post Date
4 UserIDSession
5 ExistsUser

The field 4 and 5 are flowfields. If user = useridsession then existsuser=true

When I create a form and put put on source table view Where existsUser=Const(yes) the form doesn't show any records.
Anyone knows the problem?

matttrax

Search the forum for how to do a flowfield based on another flowfield. It's a little tricky to do it, but I think I remember a post about it.

kapamarou

Kc_Nirvana wrote:

Where existsUser=Const(yes)

What about changing to : where UserIDSession <> 0 or
using flowfield that counts the entries in the session for the user and filtering that to <> 0?

Do you really need a flowfield based on another flowfield?

Kc_Nirvana

Imagine that i need a form to show only the documents that the user created.
I don't want to the user see another document that is not them.
So i create a flowfield that calculates the user that entered and a flowfield that returns true if the document belonged to the user entered

matttrax

Why not just store the user that created it on the record itself and filter on that field? Seems a lot easier.

Kc_Nirvana

matttrax wrote:

Why not just store the user that created it on the record itself and filter on that field? Seems a lot easier.

But that's want i want.
The document has a field that is the user that created the document.
But i want that only that user can see that document

Belias

in the onopenform

FILTERGROUP(10);
rec.setrange("created by user",USERID);
FILTERGROUP(0);

or am i missing something in the post? :-k

Kc_Nirvana

So simple......
That worked...... =D>
Thanks

matttrax

You'll probably want to add some sort of permissions to it. I'd imagine that some people should be allowed to see every document.