actualbudget / actualbudget/actual
[Feedback] Formula Card and Formula rules
- 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:
# Formula card:
- On reports, a new dashboard type will show:
- Open the new card to show the editor:
- 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:
- You can use dynamic font size (like the summary card), o set a specific font size:
- You can create conditional expression to color the number
This will paint the number as green for my example:
# Formula Rules
- You will see a new icon for fields that support formula (numeric and text fields. ID fields doesn't work)
- Clicking on it will enable the formula editor:
- The suggestion popover shows some variables related to this context
- Create the rule using the formulas and test it using the Apply actions to a single record:
- After saving it, you will see it in the rules:
Contributor guide
Assessment
This issue has not been assessed yet.