Ok, can I do this

[DrugBust]

Thanks for the help on the previous topic but a lot of it went right over my head. I wanna make this question and answer in the simplest of terms:

I have 5 Layouts on one database. A teacher layout, a LMC layout, a principal layout, a manager layout, and a tech layout. Under the default view, everyone can see and edit everything. I want to have an on-line password for each layout, so that for example, when an elementary school principal wants access to his layout in the database, they go to a layout where they can see all the other records, but they're only able to edit the fields I want them to because they're on their own layout.

Can I use 5 different layouts somehow on-line using 5 different passwords? This is really the problem I've having problems with. The database seems to work fine offline, the groups and passwords work just how I want them to. It's when I put it on-line that it never gives me the same option to enter a password to view and edit records.

I hope this post makes more sense to you wonderful experts than my last one! But thanks for the hlep you've given so far. I just wish I was resourful enough with this program so I could follow it.

[ May 30, 2001: Message edited by: DrugBust ]

[Anatoli]

Layout protection is not for web.

You must design something between Custom Web Publishing and Web Security db.

[scratchmalogicalwax]

To publish databases on the web you generally have to approach things slightly differently than you would serving accross a LAN to FMPro Client.

proton's way of restricting access would serve you best if you are not the webserver administrator or don't have direct access to the setup.

The idea behind his solution is really quite simple. I assume you are using

WC and CDML I use Lasso but as far as I know the tags are fairly similar and I will try to remember the CDML tags where I can!

Firstly add the users to the Web Security Database. One username and password for each group.

Then when the user enters the active pages of the site they will be prompted for the username and password for the database. They will enter their groups' username and password and they will be given access to the records.

The browser will then hold the username and password information until it is closed.

In every web page you should have

[FMP-If: (FMP-Client_Username)=='group1']

(i'm not sure about this tag the LDML tag is (Client_Username) and I am assuming as with most CDML tags you just add the FMP- however I may be wrong)

Show the HTML / CDML that I want group1 username holders to see.

[FMP-Else]

Show the HTML / CDML that I want the other group(s) to see

[/FMP-If]

You can nest as many If statements as you want and make it as complex or as simple as you want.

Someone with more recent use of CDML should be able to say if I've got the CDML tags correct.

[DrugBust]

Thanks scratch, that does help me.

[proton]

quote:

---

Originally posted by DrugBust:

Thanks for the help on the previous topic but a lot of it went right over my head.

I wanna make this question and answer in the simplest of terms:

I have 5 Layouts on one database. A teacher layout, a LMC layout, a principal layout, a manager layout, and a tech layout. Under the default view, everyone can see and edit everything. I want to have an on-line password for each layout, so that for example, when an elementary school principal wants access to his layout in the database, they go to a layout where they can see all the other records, but they're only able to edit the fields I want them to because they're on their own layout.

Can I use 5 different layouts somehow on-line using 5 different passwords? This is really the problem I've having problems with. The database seems to work fine offline, the groups and passwords work just how I want them to. It's when I put it on-line that it never gives me the same option to enter a password to view and edit records.

I hope this post makes more sense to you wonderful experts than my last one!

But thanks for the hlep you've given so far. I just wish I was resourful enough with this program so I could follow it.

[ May 30, 2001: Message edited by: DrugBust ]

---

Whew! Drugbust, this is getting complicated. But never fear!! Hmm...well you say that over your LAN you use Layout security.

You can use layout security as well in combination/or as a variation to what I posted in your other topic. Remember, when you set up the forms, one of the first tags you put at the top of the form is the layout tag. This tells WC/Filemaker what layout you are using. When this is done, WC/Filemaker only allows the user access to fields on that layout.

Using the same IF tags you can determine what group the user belongs to and tell it to use the appropriate layout AND then specify what fields to display or whatever.

So it would be like:

IF group X

layout is a

and so on..you understand? If you need it, we can post the CDML for you. Hope this helps.

[scratchmalogicalwax]

Logical functions in CDML (and Lasso) are a very powerful tool for the web developer......as proton said you can incorporate your existing layout security although in a slightly different way to the way you do it on your LAN.

By putting the <form infomation between the If statements as well as other HTML / CDML

eg

[FMP-If: .......==group1]

<form etc..............<input type=hidden" name="-layout" value="Group1_Layout"></form>

[FMP-Else]

<form etc..............<input type=hidden" name="-layout" value="Group2_Layout"></form

[/FMP-If]

[ May 31, 2001: Message edited by: scratchmalogicalwax ]

[ May 31, 2001: Message edited by: scratchmalogicalwax ]