The census places each appliance in a room: kitchen, patio, bathroom. Ventilation is evaluated per room in another table.
If one table says “Patio” and the other doesn’t list it, that room’s ventilation goes unevaluated, and the report doesn’t make it obvious.
The rule
- Checks
- The room column of the appliances table and that of the ventilation table.
- Blocks when
- A room in the appliances table doesn’t exist in the ventilation table, or a ventilation room has no appliance. It doesn’t apply on a main line.
- Message to the inspector
- “Room Patio in the appliances table doesn’t exist in the ventilation table.”
- Applies to
- Forms with an appliances table and a ventilation table.
Test cases
This is how it’s simulated before saving: if a case doesn’t give the expected result, nothing is saved.
| Situation | Result |
|---|---|
| Appliances in Kitchen · Kitchen ventilation | Passes |
| Appliance in Patio · no Patio ventilation | Blocks |
| Bathroom ventilation · no appliance in Bathroom | Blocks |
Ask your assistant for it
With the RETGAS connector in Claude, all you have to write is:
«Every room in the appliances table has to be in the ventilation table, and vice versa. It doesn’t apply on a main line. Prepare it and test it with a missing room.»
Why it matters
-
It checks both ways
No appliances in rooms without ventilation, and no ventilation rooms without appliances.
-
The exact room name
The message says which room doesn’t match. It’s almost always a different name chosen in each table.
The engine flags and the person decides. Rules only run when they’re active and linked to the form. How they’re configured
The census and the ventilation describe the same home. The rule makes sure they describe the same rooms.
Other examples
- Times The start time comes before the end time
- Times The visit lasts at least the minimum time
- Photos The photos were taken on the day of the visit
- Result consistency A compliant report can’t have failed items
- Distributors The meter serial on the bill matches the actual meter
- Tables Exposed piping has length, diameter and type
- Calculations The appliances’ power adds up
- Distributors The inspection fee is the one agreed with each distributor
- Appliance census The census code follows each distributor’s format
- Appliance census The census type matches the flue (D.E.P.C.) column
- Appliance census Planned points in the census are marked as planned
