This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- AppSheet
- AppSheet Forum
- Feature Ideas
- WEEKDAY column type for common use cases
Topic Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
LinkedIn
Twitter
Idea Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The addition of a WEEKDAY column type would be immensely valuable, especially for sorting and grouping records by chronological weekday order (e.g., Sunday, Monday, Tuesday, etc.). Currently, AppSheet does not provide a straightforward way to achieve this.
Creating a virtual column to return weekday values as text is manageable, but problems arise when attempting to sort or group the column in chronological order. Since the virtual column returns a text string, the result is alphabetical sorting (e.g., Friday, Monday, Saturday, Sunday, Thursday, Tuesday, Wednesday), which does not align with the natural sequence of weekdays.
AppSheet does not recognize the sequential order of weekdays unless users explicitly define it. To address this limitation, users must resort to cumbersome workarounds, such as:
- Additional virtual columns with numeric prefixes.
- Child tables with predefined weekday sequences.
- Advanced expressions.
These workarounds add unnecessary complexity in common use cases like timesheets, scheduling, and reports. A dedicated WEEKDAY column type would be an intuitive and streamlined solution to enable chronological weekday sorting without the need for extra setup.