FileMaker脚本IF语句示例及权限控制下UK客户过滤实现

Hey there! Let’s break down your two FileMaker questions clearly— I’ve tackled similar access control and scripting scenarios plenty of times, so I’ll give you practical, tested examples.

When you need a script that only displays records where the customer’s country is "UK", you’ll usually combine a loop with conditional checks to omit non-UK records. Here’s a straightforward script example:

# Enable error capture to avoid pop-ups when hitting the last record
Set Error Capture [On]
Go to Record/Request/Page [First]
Loop
    # Check if the current record's Country field isn't UK
    If [ Customers::Country ≠ "UK" ]
        Omit Record [ ] # Hide this non-UK record
    End If
    Go to Record/Request/Page [Next; Exit after last]
End Loop
Show All Records [ ] # Now only the un-omitted (UK) records are visible

If you just need to check a single current record and act accordingly (like showing a dialog or skipping it), use this simpler IF block:

If [ Customers::Country = "UK" ]
    # Add your desired action here—e.g., display details or export
    Show Custom Dialog [ "UK Customer"; "This record belongs to a UK client." ]
Else
    # Skip non-UK records or run alternative logic
    Go to Record/Request/Page [Next; Exit after last]
End If

For record-level security in FileMaker, you’ll set this up in the Privilege Sets under Security. The goal is to let only UK-based users see UK customer records. Using your provided framework, here’s how to build the calculation:

First, assume you have a Users table linked to your Customers table, with a User_Country field that stores the logged-in user’s region. The calculation for record visibility would be:

If(
    Customers::Country = "UK" AND Users::User_Country = "UK";
    True; # Allow access to this record
    False # Block access
)

You can simplify this even more since the visibility calculation just needs to return True or False:

Customers::Country = "UK" AND Users::User_Country = "UK"

If you’re using privilege sets to group UK users (e.g., a "UK_Users" privilege set), you can use Get(PrivilegeSetName) instead of a user table field:

Customers::Country = "UK" AND Get(PrivilegeSetName) = "UK_Users"

This ensures only users in the UK group can see UK customer records—everyone else won’t even see those records in their views.

内容的提问来源于stack exchange，提问作者andrew