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.

3 tables · 10 views · 1 form · 7 automations · sample rows included, so it opens looking like a working app

Use this template

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

Forms

Automations

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.

More Public sector templates

All templates