Filter syntex

PHOTO

Sat Aug 10 2024 09:44:31 GMT+0000 (Coordinated Universal Time)

Saved by @Wittinunt

and(
    if(isnotblank(any(Filters[JetSkis])), [Boat Name] = any(Filters[JetSkis]), true),
    if(isnotblank(any(Filters[Date from])), [Date] >= any(Filters[Date from]), true),
    if(isnotblank(any(Filters[Date to])), [Date] <= any(Filters[Date to]), true)
)

https://www.appsheet.com/template/AppDef?appName

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

AppSheet

@Wittinunt

Grant access rights to user email Force go to some view then sync Filter syntex Find unique then put each sigle one to each row Find uniques Select the last row value SUM multiple conditions OrderBy from different tables Add a new line in between list items Filtering with specific email AppSheet Select All Find uniques for a slice Filter syntax with specific user

Browse more snippets >>