Managing AnyDB Types

The Type Management screen provides a centralized place to view, create, edit, import, and maintain all types within a database. It lists every built-in and custom type, along with version history and the number of records using each.

Overview

From the Manage Database section, open the Types tab to:

• View all types used in the database (Custom, Built-in, Misc)
• Track version history (v1, v2, etc.)
• Check record counts per type
• Edit or delete types
• Browse records created from a specific type
• Create or import new types

This unified view gives admins a clear understanding of how data structures evolve across their workspace.

Viewing Existing Types

1. Open the Manage Database dialog for the database.

2. Select the Types tab in the left sidebar.
3. You will see all types grouped under tabs:
   • All - every available type
   • Custom - types created by your team
   • Built-in - system-provided types
   • Misc - utility or imported types

Each type entry displays:

• Type name
• Record count
• Type category
• Version number(s)

If a type has multiple versions, you can expand it to view each one, such as v1 and v2.

Viewing Records for a Type

You can see all records using a specific type directly from this view.

1. In the Types tab, click the record count beside the type name.
2. A popup opens showing every record that uses that type.

3. Within this listing, you can:
   • View or open individual records
   • Refresh the record usage
   • Confirm which types are currently in use

Tip: Review this list before editing or deleting types to understand the scope of impact.

Editing an Existing Type

1. Open Manage Database -> Types.
2. Find the type you want to modify.
3. Click Edit beside the type version.
4. The type opens in the Type Designer, where you can add or rearrange fields, change formulas, or modify layout.
5. When saving, AnyDB may prompt you to migrate existing records if structural changes are detected.

Best practice: Always check how many records are using the type before editing. For large datasets, schedule edits and migrations during off-peak hours.

Deleting a Type

If a type is no longer needed, it can be deleted from the database.

1. Open Manage Database -> Types.
2. Locate the type you want to delete.
3. Click Delete beside the version or main entry.
4. Confirm deletion in the warning dialog.

Warning: Deleting a type also deletes all records created from that type. This action is permanent and cannot be undone.
Export your records first if you may need them later.

Managing Type Versions

AnyDB automatically tracks type versions each time you save changes. This makes it easy to see how a structure has evolved and which version current records belong to.

Every type entry shows its version history. You can expand a type to see all versions.

You can also see the version of each record in the record details.

Tip: Keep earlier versions if you need to preserve historical layouts or compare configuration changes between releases.

Creating a New Type

To create a new record structure from scratch:

1. Open Manage Database -> Types.
2. Click + Create New Type at the top right.
3. Give your type a name and choose whether it is a custom or derived type.
4. The Type Designer opens automatically for field creation and layout design.
5. Once saved, the type becomes available to all users in the database.

Tip: Use clear naming conventions for types, such as Customer Invoice, Asset Log, or Work Order, to make them easier to find later.

Importing an Existing Type

You can reuse types from other databases or import predefined layouts.

1. Open Manage Database -> Types.
2. Click Import at the top of the Types list.
3. Choose a .json type export file.
4. Review imported fields and confirm.
5. The type will appear under the Custom tab.

Tip: Imported types retain their structure but not existing records. They are ideal for standardizing data models across multiple teams or projects.

Summary

The Type Management screen gives administrators full control over how data is structured in AnyDB. From one interface, you can view, edit, delete, import, or create types, track versions, and explore linked records, ensuring your workspace stays organized, consistent, and scalable.