redballoon Posted January 12, 2008 Share Posted January 12, 2008 Ok I have a nice login script now... However I would like to do a seacrch on login to return only those files which are the users own files (unless admin of course). So that the user does not see any "Access Denied" records. this is proving tricky for me. I have a field that is filled with the users user name on record creation and this is a hidden field so I would use that this field is called "creator"... anyway thanks for any help anyone in advance..... Link to comment Share on other sites More sharing options...
AudioFreak Posted January 12, 2008 Share Posted January 12, 2008 Hi Red, Did you try as I suggested in this thread? http://fmforums.com/forum/showtopic.php?tid/192394/post/277522/#277522 If you had problems with it, let me know I will see what I can do to help. If I can't help you then I'm sure someone else here will step in Michael Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted January 12, 2008 Share Posted January 12, 2008 Simply do a search on some value known to be in every record. The result will filter out those records the user [color:red]is not supposed to see while returning all the records the user is allowed to see. Steven Link to comment Share on other sites More sharing options...
redballoon Posted January 18, 2008 Author Share Posted January 18, 2008 If this is the first time someone logs in they will not have any records and and as such will get an error... Could a script be used to create a record and put their user name in the correct field... so >>> the flow of the script would be if count = 0 (count is the count of fields with their name in) Create record .. insert [userName] into field "creator" then do another find>>>> Is that silly or would it work.... Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted January 19, 2008 Share Posted January 19, 2008 Trap for that error--namely 0 found count--and branch your script to do whatever you want to do. Steven Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5965 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now