Syncing data for a Security Filter on a BigQuery table

[Linus_Grupp]

Hello,

I am currently developing an App, where I have two different data sources - Google Sheet and BigQuery.
I am aware of the limits with BigQuery and Appsheet, e.g. 100.000 rows to include in Appsheet.
The tables in BigQuery that are used in the App have several million rows.
In one Form View I need an Enum Column (Column B) to be selected that is a Ref of a Column in a BigQuery table which exceeds the 100.000 row limit. So I made a Security Filter for this BigQuery table, which looks on data in a Google Sheet, where the user can pre-select another Column value (Column A).

In the end the selection for Column B is pre-filtered and all possible values are present.
My problem is, that the Security Filter does not apply right away, if I change the value of Column A. It applies only after the data is synced.
If I set the Delayed Sync option to no, the data syncs after every change.

But I would like to have it only sync for this special Edit, thus if I change Column A. Otherwise the App becomes very slow, if the user has to wait for a sync after every change in any table.

Conclusion of workflow:
User sets value of Column A → Data has to be synced for the Security Filter to be applied right away on the next form view → User can select all possible values for Column B, depending what was set before in Column A

I hope my workflow is clear.
I would appreciate any help, thank you!
Linus

[Linus_Grupp]

I found this post and used the solution in there:

[Sync Action?](https://community.appsheet.com/t/sync-action/18802) Questions

Is it possible access the sync function as an action? My goal is to include the “sync action” in a sequence of actions, only to be executed if a certain condition is true. I know how to do this with actions in general. Essentially I would like my app to sync immediately if a certain condition is met, otherwise, delayed sync is fine. Thanks,