Mission & Consular Services template
Diplomatic posts on a map with a validated ISO 3166-1 alpha-3 accreditation country and a staff establishment; postings that end on a date the personnel department has to act on, computed into days remaining; and consular casework — visas, passports, civil status, notarial acts — measured against the service standard the applicant was quoted.
Tables
Posts
Post, Name, Type, Host country (ISO 3166-1 alpha-3), City, Position, Opened, Staff establishment, Postings, People posted, Vacancies, Consular cases, Cases handled, Consular fees and 1 more
Postings
Staff number, Name, Post, Post record, Host country, Role, Posted from, Posted to, Locally engaged, Days left on tour, Rotation status, Notes
Consular cases
Case reference, Post, Post record, Post type, Service, State, Applicant nationality (alpha-3), Lodged, Service standard (days), Decided, Consular officer, Consular fee, Promised by, Days taken and 2 more
Views
- Consular board (kanban)
- All cases (grid)
- Case calendar (calendar)
- Cases by service (chart)
- Open casework (grid)
- Network map (map)
- Post register (grid)
- By post type (kanban)
- Postings (grid)
- Rotation calendar (calendar)
Forms
- Request a consular service
Automations
- Acknowledge a lodged application
- Email the applicant on a decision
- Daily rotation check
- “Consular cases” reached “Withdrawn”
- Daily sweep — still open in “Consular cases”
- “Locally engaged” was ticked in “Postings”
- Large value in “Service standard (days)”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.