I'm currently building a FileMaker 12 database for use with FileMaker 12 Server and FileMaker GO where I have 18 users and 18 layouts (1 per user) for remote data entry to a single database. Each user requires a different layout for functionality purposes.

I have permissions set so each user only has access (view only for layout, editing for record) to their own individual layout, but unless I set a gateway layout that has them choose who they are (with buttons that are mapped as "Go to Layout), I can't get them to their specific layout.

I found an old script from FileMaker 2 that was supposed to look at username and then automatically take them to the appropriate layout, but the same script commands aren't available for FileMaker 12.

Has anyone run into this? Is this even possible? It's not a showstopper of an issue, but it would be nice to eliminate the redundancy of having people log in once, just to then choose their name from a list of buttons to go to their individual submission page.

Thanks in advance to anyone that can help. I'm still new to FileMaker so I'm always glad to learn and give things a shot.

Hi lorkaio

You can do that easy just adding a Startup Script to your solution

And you should use in the startup script step the

Set Variable ($$User :Get (Account Name)

If ($$User=User1;

Go to layout one

Else

Go to Layout Master

endif

Something like this

Walter Noia

Hi lorkaio

Well I did a Sample database for you maybe this can help you understand

I created 3 User + Admin

Carlos

Maria

Mike

With no passwords on them,

Then I created a small startup Script when you log with each one will take you to that layout

I hope this helps

Thanks

Walter

layout sample.fp7.zip

IMHO a separate layout for each user is crazy. Each time a new user is added the database INTERFACE needs to be modified and scripts into the database. It'll be cheaper to send new users to a night at the opera than it will to give them access!

At the very least, work out the different ROLES and create an interface for each role. Create a privilege set for each role, with appropriate permissions, and change to the layout based on the privilege set NOT the account name. Associate each user account with the appropriate privilege set.

If you reply that every user is different... then re-think the approach.

Hi there. This is an old post, but maybe someone's listening?

 

I've set up a script trigger to switch to layout based on user - as discussed here, and it works fine - but the default layout flashes on the screen for a moment before switching to the scripted layout. Does anyone have a tip for hiding that behavior? Will I need to make the default layout a blank screen?

 

Side note: I've deselected the file option for default layout and this is still happening. 

 

Thanks!