Jump to content
Sign in to follow this  
appletag

Account created by existing field?

Recommended Posts

I have a job tracking database that has 2 types of users. The first is the employees who have rights to view and edit all records. The second would be clients (via web access on server 7 advanced) that should only be able to view records (jobs) pertaining to them.

The database has 3 tables. They are Jobs, Clients, and Employees. Each record in the Jobs table has a field marking possesion to a client.

So...I have a great table of Clients, I could add a field with username and password. Can I get Filemaker to authenticate from records in this table? Does it require the scripting solutions I hear some speaking of? Thanks!

Share this post


Link to post
Share on other sites

You could script this so that depending on the client account name, they would be directed to their particular record after logging in. Go to Record/Request/Page by calculation.

Share this post


Link to post
Share on other sites

Thanks for replying.

I figured it would be a calc/script. Would the script look at a global field used to hold the "username"? If so, would another connected user share the value of the global field, or does each user connected have a value for the global field.

Share this post


Link to post
Share on other sites

No, you could just use Get ( AccountName ).

Share this post


Link to post
Share on other sites

Right, I could but I don't want to enter several hundred account names that already exist as a field of the DB into FMP Accounts @ Priveleges.

Share this post


Link to post
Share on other sites

OK, I see. You could then just use If name_field = ...., Go to This Record by Calculation, etc., in the script, for as many different names as you have. You would, of course, have to hide the Status Area and supply your own navigation buttons so the users would be unable to go to other records.

Share this post


Link to post
Share on other sites

Right, I could but I don't want to enter several hundred account names that already exist as a field of the DB into FMP Accounts @ Priveleges.

This probably will take about 60 to 90 seconds for 200 Accounts if you would like to do it.

Share this post


Link to post
Share on other sites

You mean as an import in to Accounts and Privs?

I'm starting to think I could create a layout for the employees to add client accounts. It seems there are script and calc pieces to interface the Accounts and Privs from within the DB. Is this correct?

I must thank all so far. This is the first DB I've developed for someone other than in-house. All the In-house DB's I control. Now I must consider my customers needs for admin w/o teaching them the parts I want to lock out. I still want then dependent on me for some things wink.gif

Thanks!

Share this post


Link to post
Share on other sites

wow - that's the exact solution I need! May I intergrate those scripts freely?

Basically all I'd need to do now is create the sort scripts mentioned earlier by transpower.

Share this post


Link to post
Share on other sites

Certainly. Just don't call me in the middle of the night :-)

Remember you still have to create the correct Privilege Sets in every file, create the Table Occurrence for the central "account creation" file in each of the others, import the scripts into each file (for the files, not the ones in the central file). Check that the relationships in the scripts line up. Target the scripts in the central file toward the scripts in the other files. Add new File References (in the central file), and new script lines for new files.

So there's some setup to be done. But it beats creating multiple accounts manually. Plus, once set up correctly, someone else can manage the accounts.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.