actualbudget / actualbudget/actual
[Feedback] Formula Card and Formula rules
- Lingua principale
- TypeScript
- Stelle
- 28.8k
- Fork
- 3k
- Merge medio
- 2g 11h
- PR unite (30g)
- 65
Descrizione
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:
Guida per i contributori
Apri la guida per i contributori
Direzione di ricerca
Start by reading the latest comments on issue #5949, because the body describes how to try the Formula Card and Formula Rules rather than a specific change to make. The entry points mentioned are the feature flag, Reports dashboard card, formula editor, rules editor, and Apply actions to a single record. Done is not defined in the issue text; wait for a maintainer-scoped task before starting.
Scritto dal modello di indicizzazione a partire dal testo della issue.
Valutazione
- Stack tecnologico
- typescript
- Ambito
- frontend
- Tipo di issue
- Funzionalità
- Difficoltà
- 5/5
- Tempo stimato
- Più di una settimana
- Stato di attività
- Attiva
- Chiarezza
- Da chiarire
- Idoneità per principianti
- 18/100