github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-03-10 12:12:39 -05:00
Code Issues 250 Packages Projects Releases 53 Wiki Activity

[PR #6432] ✨ Excel formula feedbacks #6519

New Issue
Closed
opened 2026-02-28 21:29:29 -06:00 by GiteaMirror · 0 comments
GiteaMirror commented 2026-02-28 21:29:29 -06:00
Owner
Copy Link

Original Pull Request: https://github.com/actualbudget/actual/pull/6432

State: closed
Merged: Yes

  • Added QUERY_COUNT("queryName") formula function for Formula widgets:
    Returns the number of matching transaction rows for a saved query.

  • QUERY_COUNT is now recognized in function docs/autocomplete/highlighting alongside QUERY.

  • CodeMirror UX: Tab accepts autocomplete
    When the completion popover is open, pressing Tab now accepts the highlighted suggestion (same as Enter).
    Implemented with highest-precedence keymap so it wins over @uiw/react-codemirror/basicSetup bindings like indentWithTab.

  • Fixed query editor date handling (end-month bug)
    Previously, selecting an end month could normalize to the 1st day of the month, making the end month feel “exclusive” vs other reports.
    Now month selections are normalized consistently:
    start month → first day of month
    end month → last day of month

  • Fixed “Last month” query preset to be truly dynamic
    QueryManager “Last month” now uses mode: "lastMonth" (not sliding/static), so it updates over time like other dashboard cards.

  • Fixed sliding-window queries not sliding for Formula widgets

Note

Adds QUERY_COUNT to formulas, makes Tab accept CodeMirror autocompletions, and fixes query timeframe normalization and dynamic ranges (including last-month and sliding-window).

  • Formula execution & functions:
    • Add QUERY_COUNT("name") support alongside QUERY, including parsing, substitution, docs, autocomplete, and highlighting.
    • Refactor query execution with shared builder; add fetchQuerySum and fetchQueryCount.
    • Implement sliding-window as a live range; compute dates dynamically; update “Last month” preset to mode: 'lastMonth'.
  • Query Manager & timeframes:
    • Normalize month picks to days: start → firstDayOfMonth, end → lastDayOfMonth; apply on change and import/export.
  • Editor UX (CodeMirror):
    • Add highest-precedence keymap so Tab accepts active autocomplete suggestion.
  • Utilities:
    • New queryTimeFrame normalizers and getLiveSlidingWindowRange helper.

Written by Cursor Bugbot for commit df432fcbf7. This will update automatically on new commits. Configure here.

**Original Pull Request:** https://github.com/actualbudget/actual/pull/6432 **State:** closed **Merged:** Yes --- - Added QUERY_COUNT("queryName") formula function for Formula widgets: Returns the number of matching transaction rows for a saved query. - QUERY_COUNT is now recognized in function docs/autocomplete/highlighting alongside QUERY. - CodeMirror UX: Tab accepts autocomplete When the completion popover is open, pressing Tab now accepts the highlighted suggestion (same as Enter). Implemented with highest-precedence keymap so it wins over @uiw/react-codemirror/basicSetup bindings like indentWithTab. - Fixed query editor date handling (end-month bug) Previously, selecting an end month could normalize to the 1st day of the month, making the end month feel “exclusive” vs other reports. Now month selections are normalized consistently: start month → first day of month end month → last day of month - Fixed “Last month” query preset to be truly dynamic QueryManager “Last month” now uses mode: "lastMonth" (not sliding/static), so it updates over time like other dashboard cards. - Fixed sliding-window queries not sliding for Formula widgets <!-- CURSOR_SUMMARY --> --- > [!NOTE] > Adds QUERY_COUNT to formulas, makes Tab accept CodeMirror autocompletions, and fixes query timeframe normalization and dynamic ranges (including last-month and sliding-window). > > - **Formula execution & functions**: > - Add `QUERY_COUNT("name")` support alongside `QUERY`, including parsing, substitution, docs, autocomplete, and highlighting. > - Refactor query execution with shared builder; add `fetchQuerySum` and `fetchQueryCount`. > - Implement sliding-window as a live range; compute dates dynamically; update “Last month” preset to `mode: 'lastMonth'`. > - **Query Manager & timeframes**: > - Normalize month picks to days: start → `firstDayOfMonth`, end → `lastDayOfMonth`; apply on change and import/export. > - **Editor UX (CodeMirror)**: > - Add highest-precedence keymap so `Tab` accepts active autocomplete suggestion. > - **Utilities**: > - New `queryTimeFrame` normalizers and `getLiveSlidingWindowRange` helper. > > <sup>Written by [Cursor Bugbot](https://cursor.com/dashboard?tab=bugbot) for commit df432fcbf7b8ba3bbdfe053e89035cce3bd3604d. This will update automatically on new commits. Configure [here](https://cursor.com/dashboard?tab=bugbot).</sup> <!-- /CURSOR_SUMMARY -->
GiteaMirror added the pull-request label 2026-02-28 21:29:29 -06:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#6519
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?