Country
A sovereign country identified by its name and ISO alpha-2 code.
Source table: Countries in Core Record Types (schema:Country). A Country is a sovereign state identified by its name and its ISO 3166-1 alpha-2 code.
Rules and relationships
Enter Name and the two-letter Abbreviation. States lists its first-level divisions; Address lists addresses that name the country directly. Compliance Global is a legacy text column whose description still promises links to compliance requirements; compliance now lives in KPIs & OKRs. The primary field is ID, an auto number.
Lifecycle and checks
Active marks a country available for current operations. V3 · Reference status and V3 · Next action give the next fix; V3 · State count counts linked states. There is no Record health or Health check pair.
Source fields
Names, types, options and links are those configured in Core Record Types. The meaning is the first line of each field description in Airtable. Options describe configuration; they do not prove a rule is enforced elsewhere.
Recorded values
| Field | Type | Meaning | Options, link or calculation |
|---|---|---|---|
| Name | Text | Stores the plain-language name of the country. | Entered value. |
| Abbreviation | Text | Stores the country’s two-letter ISO 3166-1 alpha-2 code. | Entered value. |
| Active | Checkbox | Stores whether this country is available for current operations. | Entered value. |
| Compliance Global | Text | Links the compliance requirements whose jurisdiction is this country. | Entered value. |
Links
| Field | Type | Meaning | Options, link or calculation |
|---|---|---|---|
| States | Linked records | Links every state, province, or region in this country. | → State · several records |
| Address | Linked records | Links the addresses that name this country directly. | → Address · several records |
| Tags | Linked records | Links optional labels from the shared Core Tags catalog. | → Tag · several records |
Calculated
| Field | Type | Meaning | Options, link or calculation |
|---|---|---|---|
| V3 · State count | Formula | Counts the states, provinces, and regions linked to this country. | Formula below. |
| V3 · Reference status | Formula | Shows whether this country row is complete enough to be used. | Formula below. |
| V3 · Next action | Formula | Shows the next thing to fix on this country row. | Formula below. |
Generated by Airtable
| Field | Type | Meaning | Options, link or calculation |
|---|---|---|---|
| ID | Auto number | Shows the running number Airtable gave this country when the row was created. | Airtable system value. |
| Created By | Created by | Shows who created this row in Airtable. | Airtable system value. |
| Created | Created time | Shows when this row was created in Airtable. | Airtable system value. |
| Last Modified By | Last modified by | Shows who last changed any value in this row. | Airtable system value. |
| Last Modified | Last modified time | Shows when any value in this row last changed. | Airtable system value. |
Current formulas
Field IDs are rendered as current field names.
V3 · State count
COUNTA({States})V3 · Reference status
IF({Name} = "", "Needs country name", IF({Abbreviation} = "", "Needs abbreviation", IF({Active}, "Ready", "Inactive")))V3 · Next action
IF({Name} = "", "Enter country name", IF({Abbreviation} = "", "Enter abbreviation", IF(NOT({Active}), "Review inactive country", IF({V3 · State count} = 0, "Review state coverage", "Ready"))))Example (fictitious)
United States has Abbreviation US and Active checked; its States include Texas. V3 · Reference status reads Ready.
Use by other systems
No other system mirrors this table.