C
C
Composer
ChangelogBugs and feature requestsAppGyver Academy
Search…
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: 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
SAP AppGyver on Business Technology Platform
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
File Uploads
Configuring data resources
REST API direct integration
Authentication
Google Firebase connector
Migrate AppGyver Cloud Storage to Firebase
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 modified 7mo ago
Export as PDF
Copy link