Script Trigger off a calc field =1

[sicSRT8]

I am drawing a blank and know Bcooney has shown me this but was going thru old posts and cant for the life of me find it.

When I have a check box and have another calc field If ( field1 ; 1 )

How can I set it to trigger the script if it is 1 in the calc field?

Sorry BCooney I forgot how.

[bcooney]

Well, I don't remember this. Couldn't you make the checkbox a button that runs a script that has a IF ELSE ENDIF construct?

-Barbara

[Lee Smith]

Hi sicSRT8,

Did you know that you can find your own posts, by Using the ACTIVITY menu drop down list. If it is your Thread, click on 'My Threads", if it was a reply to one, then click on "My Posts".

You can also find these options in your profile by clicking on your name in the profile found on the left side

HTH

Lee

Edited June 28, 2009 by Guest

[sicSRT8]

BC-If you convert the box to a button don't you lose the check box function? Also maybe this was from another post but going deeper I am setting the check box as a rule to eliminate editing any further by users. Once checked it is saved.

Lee- I did look thru my activity but wasn't able to find it. I am starting to think I saw it in another post which I used as an example and could be the reason why I think it was one of my posts. I tried a search but wasn't able to find where I saw it. Note to self- start adding things to fav's.

[bcooney]

Yes, the user cannot click the checkbox to set its value.Instead, they click the checkbox button and the script runs. The script sets the checkbox to "1" or if it's "1", clears it.

[sicSRT8]

Hmmm. Not the effect I was hoping for... Curious if you had someone fill in a record and when complete by user or when new record started what would be your preferred method to save record from random or accidental editing.

Is it possible to have a popup asking if your sure you want to edit the record?

My issue is I have 16 guys that will be creating records during daily production and dont want someone to accidentally edit a field which is crucial info for me.

[bcooney]

"when complete by user" is a key phrase. You could have a checkbox that the user selects to mark the record "complete." Then, in record level access, create a rule that a user cannot edit a record that is marked complete.

I also have two layouts, one that is read/write and one read only (the "locked" layout). I write a little script that navigates to the correct layout based on whether or not the checkbox=1.

On the read only layout I put an Edit button. It shows a dialog, "Do you want to unlock this record for editing?" Sometimes I only let a user of Admin priv set unlock a record.

If the entire record doesn't need to be locked, you could simply apply this type of setup to one field or a group. Then I have an edit button that pops up a window in which these fields are edited. That extra step of having to click a button to access an editable field is sometimes enough to safeguard the field.

[sicSRT8]

Yes I just need the single check box which is already set up. Record level access is referring to what exactly? Would I set anything in user privileges? I apologize for my lack of FM terminology but understand what your saying if that's any consolation.

About your dual layouts for each layout I have seen posts referring about this but with tabs seems to have bugs. But i assume since they are the same one just being editable it may not affect me as much as trying to hide text from normal users.

If you have an example I would love to see it.

[bcooney]

It's best to read this first. FM Help RLA

Basically, you define a calculation for limited access to a table. When the calc=1 (true) the user is allowed to edit the records in the table.

Concerning layouts: I am not referring to using a tab panel. Two entirely different layouts. Both are based on the same TO. However, in the locked layout, all fields are set to NOT allow edit in Browse.

[sicSRT8]

I think you link is broken.

The reason I mentioned tabs was certain layouts of my db contain tabs and was trying to think how to go about the diff layouts method.

[Lee Smith]

try putting this directly into the URl of a blank browser window.

New link:

http://fmhelp.filemaker.com/fmphelp_10/en/html/passwords.13.20.html#1028797

Edited July 2, 2009 by Guest
edited link

[sicSRT8]

Im getting nothing on any browser window. Firefox, IE, and Search...?

[Ocean West]

Try This: http://fmhelp.filemaker.com/fmphelp_10/en/html/passwords.13.20.html#1028797

[sicSRT8]

That works...

[sicSRT8]

Ok I have the Boolean set for the check box but where do I enter the code for user access privileges?

I have changed my mind and using one of their examples as it makes more sense to allow editing of todays entered records but not yesterdays...

Record_creation_date = Get(currentDate)

I understand whats going on with this but foggy on where to input this code to be used for a user set.

Update: Im stupid I didnt scroll up when I got to the link. Dont quote me either. :

Edited July 2, 2009 by Guest