Psychiatry clinic software with a self-built, auto-scored PHQ-9 / GAD-7 screening tool
Avinya Plus is a generic, configurable clinic platform you shape into a psychiatry workflow. In its template builder you build a PHQ-9, GAD-7, or mental-status form where number fields capture each item, the formula engine totals the score, and conditional-formatting rules colour-band the severity. It ships no psychiatry module; you build it. India-first, in early access.
The total at the bottom of the questionnaire is done by hand, every visit
Psychiatry runs on validated instruments (PHQ-9, GAD-7, a mental-status exam) and most clinics still print them, tick boxes by hand, add the column in their head, and write 'moderate' from memory of the cut-offs. The arithmetic is where errors creep in, and a tired clinician at the end of a long OPD is exactly when a 14 becomes a 12. Tracking whether this visit's score is better or worse than last month means flipping through paper. And the note itself is sensitive: it should not be open at the front desk. You want the questionnaire to add itself up, tell you the severity band on sight, and stay confidential.
Built for how clinics actually work.
Build the PHQ-9 / GAD-7 as a real form: number fields per item
In the block-template builder you add a linked-database table with one number field per questionnaire item (decimalPlaces 0 for a clean 0–3 response), or use select fields whose options carry the scored value. The same builder ships 23 field types and 21 block types, so the mental-status exam, risk flags, and free-text formulation all live on one page. The seeded CBC lab panel already proves this linked-database-plus-conditional-formatting pattern (there its columns are text with a colour-coded Flag) and for a rating scale you simply make the item columns number fields and total them.
The score totals itself: the formula engine
A KPI or summary field runs a formula that adds the items into one total. sum() aggregates a list of item values; sumColumn("PHQ-9 Items", "Score") totals a numeric column across the questionnaire's rows; round() and formatNumber() keep it tidy. The engine is pure and deterministic with money-aware aggregation, so the PHQ-9 total or GAD-7 total is computed the same way every visit, with no mental arithmetic and no transcription slip.
Severity bands itself: conditional formatting, first match wins
Each column carries an ordered list of conditional-formatting rules: a when formula that returns a boolean (e.g. prop("Total") >= 20) paired with a semantic style. The first rule that matches colours the cell, so a PHQ-9 total of 22 lands in the 'severe' band and lights up destructive, 10–14 sits in 'moderate' as warning, and a low score reads as success. The nine semantic styles are normal, muted, emphasis, success, warning, destructive, info, code, and quote. You author the cut-offs once; the band shows on sight.
Re-screen each visit and read the trajectory on one timeline
A patient's records read as a chronological timeline, so each PHQ-9 or GAD-7 you record sits in date order against the same person. Because if() and the comparison operators are short-circuit forms in the engine, you can author a formula that labels this visit's total relative to a target threshold. Note this is your own banding against fixed cut-offs; Avinya Plus draws no percentile or normative growth curve; it totals and bands the numbers you enter.
The psych note stays off the front desk: clinical-records access (secondary)
Viewing or editing clinical records requires the clinical.medicalRecords permission. The seeded Front Desk role is granted patients and appointments but is deliberately not given clinical.medicalRecords, so reception can register patients, schedule, and bill yet cannot open the consultation note or the completed questionnaire. This is role-based confidentiality applied to a sensitive psychiatry note; the broader Row Level Security and branch-isolation story lives on our data-security page; here it simply keeps the assessment off reception's screen.
Honest limit: there is no built-in psychiatry module
Avinya Plus ships no PHQ-9, no GAD-7, no validated mental-health instrument out of the box, and no clinical scoring logic of its own. Psychiatry exists only as a label in the specialty picklist; the single gated specialty clinical feature flag in the product is OB-GYN. Everything above is something you assemble in the generic builder: you define the items, you enter the scoring cut-offs in the formula and formatting rules. We give you a totalling, colour-banding form engine; the clinical instrument and its interpretation are yours. We say this plainly because it is the honest shape of the platform.
At a glance
- Avinya Plus ships no PHQ-9, GAD-7, or any psychiatry clinical module; psychiatry is only a value in a 43-entry specialty picklist, and the sole gated specialty feature flag is OB-GYN.
- The formula engine (~30 functions) totals questionnaire scores with sum() over a list and sumColumn() across a form's rows, plus round() and formatNumber().
- Conditional formatting applies the first matching rule per cell, banding a score into one of nine semantic styles including success, warning, and destructive.
- The template builder offers 23 field types (including number with 0–6 decimal places, select, and multi_select) for capturing rating-scale items.
- Clinical records are gated by the clinical.medicalRecords permission; the seeded Front Desk role is granted patients and appointments but not medical-records access.
- Avinya Plus draws no percentile or normative scoring curve; it totals and bands only the values you enter against cut-offs you author.
See how it stacks up.
| Feature | Paper / Excel | Legacy EMR | Avinya Plus |
|---|---|---|---|
| PHQ-9 / GAD-7 as a structured form | Printed sheet | Fixed if offered | Built in the builder |
| Item scores totalled automatically | By hand | Partial | Formula engine |
| Severity band shown on sight | From memory | No | Conditional formatting |
| Re-screen over visits on one timeline | Flip pages | Partial | Yes |
| Note hidden from front desk | No | Partial | No medical-records grant |
| Built-in psychiatry clinical module | No | Sometimes | no — you build it |
| Percentile / normative scoring curve | No | Rare | No |
Questions, answered.
Does Avinya Plus come with PHQ-9 and GAD-7 built in?
No. Avinya Plus ships no validated mental-health instrument and no scoring logic of its own; psychiatry is only a label in the specialty picklist. You build the PHQ-9, GAD-7, or mental-status form yourself in the template builder using number and select fields, then enter the totalling formula and the severity cut-offs as formatting rules. The engine does the arithmetic and banding; the instrument is yours.
How does the questionnaire add up its own score?
A KPI or summary field runs the formula engine. sum() adds a list of item values and sumColumn("PHQ-9 Items", "Score") totals a numeric column across the form's rows, with round() to keep it clean. The total recomputes every time, so there is no mental arithmetic and no transcription error.
How does it show the severity band: mild, moderate, severe?
Through conditional formatting. Each column holds an ordered list of rules: a when formula returning a boolean paired with one of nine semantic styles. The first matching rule colours the cell, so a high PHQ-9 total lights up destructive (severe) and a mid-range total shows warning (moderate). You set the cut-offs once.
Is Avinya Plus a psychiatry-specialist EMR?
No. It is a generic, configurable clinic platform, not a psychiatry EMR. The only gated specialty clinical module in the product is an OB-GYN one. For psychiatry you configure the generic builder, vitals, prescriptions, and billing into a mental-health workflow. We are upfront about this; the honest shape is a platform you shape, not a pre-built psychiatry product.
Can the front desk see a patient's psychiatric note?
No. Viewing or editing clinical records requires the clinical.medicalRecords permission, and the seeded Front Desk role is granted patients and appointments but not clinical.medicalRecords. Reception can register, schedule, and bill, but cannot open the consultation note or the completed questionnaire. Broader database-level isolation is covered on our clinic data-security page.
Does it plot scores against a normative or percentile curve?
No. Avinya Plus totals the numbers you enter and bands them against the fixed cut-offs you author in the formula and formatting rules. It draws no percentile chart and applies no population norms. Tracking is your own re-screens over visits on the patient timeline, compared against thresholds you set.
Run your clinic on Avinya Plus.
Patient records, billing, and scheduling in one system your team will actually use.