actualbudget / actualbudget/actual

[Feedback] Formula Card and Formula rules

Open
#5,949 108 comments 13 reactions 0 assignees View on GitHub
experimental feature
Dominant language
TypeScript
Stars
28.7k
Forks
3k
Avg merge
2d 11h
Merged PRs (30d)
65

Description

Added excel-like formulas to a new card and excel formulas to rules:

- Enable the new feature flag:
image

# Formula card:

- On reports, a new dashboard type will show:
image

- Open the new card to show the editor:
image

- Query Definitions is where you are going to define the queries to fetch data. You will use it later in the formula
- Formula uses excel functions (in english)
- Press ctrl+space for suggestions:
image

- You can use dynamic font size (like the summary card), o set a specific font size:
image

- You can create conditional expression to color the number
image

This will paint the number as green for my example:

image

# Formula Rules
- You will see a new icon for fields that support formula (numeric and text fields. ID fields doesn't work)
image

- Clicking on it will enable the formula editor:
image

- The suggestion popover shows some variables related to this context
image

- Create the rule using the formulas and test it using the Apply actions to a single record:
image

- After saving it, you will see it in the rules:
image

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.