Composer
Composer
Changelog
Bugs and feature requests
AppGyver Academy
Home
Changelog
Start Learning Composer Pro
Tutorials
AppGyver x Xano — Building a No-code Books App
Power-up videos
Power-up: Working with Objects
Power-up: Offline Storage
Power-up: Conditional Renderer
Power-up: Custom Fonts
Power-up: Lists & Repeats
Power-up: Debugging Variables
Power-up: Grid/Table layout
Power-up: Sorting and Filtering data
Power-up: Transforming Data
Power-up: Forms and Form Validation
Power-up: Custom Flow Functions
Power-up: Conditional Styling
Power-up: Grouping lists
Power-up: Create a Star Rating Component
Power-up: Editing items in a list
Power-up: Search bar with sugggestions
Tutorial articles
Core Lessons - Complete Guide to Composer Pro
Quick onboarding videos
Academy Articles
Bugs and feature requests
Using Composer Pro
Introduction
The App Builder
User Interface
Creating user interfaces
Components
Navigation
Variable editor
Theme editor
App logic
App logic overview
Variables
Device sensors
Debugging
Events
Custom JavaScript
Data
Configuring data resources
REST API direct integration
Authentication
Messaging
Push notifications
Publishing / Distribution
Build Service & required assets
Distributing your app
Reference
Component gallery
Flow functions reference
Formula functions reference
Page properties reference
Sensor variables reference
System variables reference
Style properties reference
Policies & Guidelines
Issue reporting guidelines
Legacy documentation
AppGyver Cloud Storage
Powered by GitBook

Power-up: Sorting and Filtering data

Learn how to sort, order and filter your data using formula functions with Composer Pro.

The formula functions used in this video

Sorting the list items according to their department property: SORT_BY_KEY(pageVars.Employees, "department")

Creating a dropdown field with the department options, removing duplicate options, and adding a "No selection" option:CONCAT([{label: "No selection", value: ""}], UNIQUE_BY_KEY(MAP(pageVars.Employees, {label: item.department, value: item.department}), "value"))

Toggling the visibility of list items according to the search and filtering options: CONTAINS(LOWERCASE(current.name), LOWERCASE(pageVars.nameFilter)) && CONTAINS(current.department, pageVars.departmentFilter) && CONTAINS(current.city, pageVars.cityFilter)

​

tags: sort, filter, dropdown

Previous
Power-up: Grid/Table layout
Next
Power-up: Transforming Data
Last updated 2 months ago