Notification

AppSheet will be conducting service maintenance starting Sunday, May 19th, 2024 at 12:00 PM (7:00 PM UTC) and completing no later than 4:00 PM PDT (11:00 PM UTC). Learn more

您请求访问的页面目前没有您的语言版本。您可以从页面底部选择其他语言,或使用 Google Chrome 的内置翻译功能将网页内容即时翻译成您选择的语言。

Slice row filter conditions

Row filters are a way to filter the rows in a slice. The following provides an example of a Row filter condition. This expression defines the Yes/No filter condition used by the slice. Rows that satisfy the condition are part of the slice; those that fail the condition are excluded.

Row filter condition when configuring a slice

When you click in the Row filter condition field, Expression Assistant is launched. Use Expression Assistant to construct an appropriate filter condition. 

Filter rows by user

You can choose to filter data based on the user currently using the app. In order to do this, you first need to make sure your app requires sign-in, so AppSheet can recognize who is signed in to the app and render the corresponding data.

You'll also need to make sure that your spreadsheet contains a qualifying column that can uniquely identify the user based on the row. The contents of that column should identify the user. Email is always best, but you could use Name, Student, User, and so on; anything that will require the user to type in the qualifying detail. The row filter condition [Student Email] = USEREMAIL() will ensure that only the appropriate rows are included.

Note: Avoid USERNAME() because it is unreliable. Providers like Google only return the user's name if that user has enabled Google+ on their account. Instead, use an Email column and compare it with USEREMAIL(), rather than comparing a Name column to USERNAME().

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Main menu
14856178226480877094
true
Search Help Center
true
true
true
false
false