actualbudget / actualbudget/actual

[Feedback] Formula Card and Formula rules

Aperta
#5,949 108 commenti 13 reazioni 0 assegnatari Vedi su GitHub
experimental feature
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:
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

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

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.