AppSheet Security Filter and Quick Sync Behavior

AppSheet AppSheet Q&A
1

Hi,

I’m encountering an unexpected behavior with AppSheet’s Security Filter and the Quick Sync feature (Im on Core plan)

I’m using the exact same formula for the Security Filter on three different tables.

  • On Table 1, the Security Filter works as expected and does not disable Quick Sync.

  • On Table 2 and Table 3, applying the identical formula unexpectedly disables Quick Sync.

So,

Is this a known bug, or is there a specific reason why applying a Security Filter to multiple tables might affect Quick Sync differently?

I’m trying to understand if there are any hidden limitations or if my formula is inadvertently causing this behavior on some tables but not others.

Any insights would be greatly appreciated.

Thank you.

Here is the Formula:

IF(
  IN(
    USEREMAIL(),
    LIST(
      "user1@amj-jsc.com",
      "user2@amj-jsc.com",
      "user3@amj-jsc.com",
      "user4@amj-jsc.com",
      "user5@amj-jsc.com"
    )
  ),
  TRUE,

  IF(
    CONTAINS(INDEX(USERSETTINGS("User Dept GeneralGrp MainGrp ListOtherDepts"), 1), "_BPSX"),
    OR(
      [Department ID] = INDEX(USERSETTINGS("User Dept GeneralGrp MainGrp ListOtherDepts"), 1),
      [Department ID] = "0150_BPSX0"
    ),
    [Department ID] = INDEX(USERSETTINGS("User Dept GeneralGrp MainGrp ListOtherDepts"), 1)
  )
)
2

image

USERSETTINGS() is technically a table reference and “outside the scope of the row”.

3

Hi Steve,

Thank you for your response.

I’m writing to follow up on the behavior of the USERSETTINGS() function when used in a security filter.

  • I have looked at the other posts regarding the USERSETTINGS() in Security Filter and it seems not a problem.
  • I’ve also successfully applied a security filter with USERSETTINGS() to several tables

However, after applying this same filter to 4 or 5 tables, the Quick Sync feature becomes disabled for all subsequent tables I attempt to apply it to.

Thats why i want to ask if there is a known or hidden limitation on the number of tables that can use USERSETTINGS() in a security filter before Quick Sync is automatically disabled? Any insight into this specific behavior would be greatly appreciated.