Jump to content
Sign in to follow this  
Jair Garcia

how to give access to a layout to a user at a time.

Recommended Posts


Hi everyone, I have a layout that I want to enter only one user at a time, i try a field where a script trigger on open layout makes a set field "1" and when closing the layout deletes it, so when another user enter the layout if the field is "1"  denies the access, but if filemaker crash or the connection is lost, that field stays in 1 and nobody can enter the layout, how can this be solved? 

Thank you in advance for your help.

 

Share this post


Link to post
Share on other sites

Am curious to the purpose? Why would only one need unique access to a layout?

 

Share this post


Link to post
Share on other sites

Layouts are merely vehicles for displaying record data. Are you more concerned with one user at a time editing a record? Seems to me you might think that is necessary to handle. Filemaker handles record locking for you.

Share this post


Link to post
Share on other sites
Posted (edited)

Hi, because i have a layout which its a report with a group of numeric field to show a monthly cash flow of a business, on the lay out i have a script for calculate the months (36)  from a specific date and the script set those fields on the layout from a calculated fields i have on the table, doing that we reduce the time of generate the report and the navigation on it. but if another user access the layout and trigger the script modify the data on the report for the 2 users, that's why we want to block the access. 

Screen Shot 2019-06-20 at 5.56.15 PM.png

Edited by Jair Garcia

Share this post


Link to post
Share on other sites

I would, take a complete different approach.

Create the structure of the report so only values are Number fields (no calcs) and write a script that will be either run as PSOS - or actually scheduled on the server in the wee hours of the morning  - that would aggregate the date to this report. 

Users visiting the report would not trigger the update, as all they would need is to sort view.

You could better control who has access to the "UPDATE" button by permissions and or hiding the button from user access while the server is processing the records. 

 

Share this post


Link to post
Share on other sites
7 hours ago, Jair Garcia said:

i have a script for calculate the months (36)  from a specific date and the script set those fields on the layout from a calculated fields i have on the table, doing that we reduce the time of generate the report and the navigation on it. but if another user access the layout and trigger the script modify the data on the report for the 2 users, t

I can't say I understand this fully, but if you want fields to have a value that is specific to each user, why don't you use global fields?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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