Database & formulas

Transform static documents into dynamic resources with embedded databases and calculations. BlueDocs brings structured data and automated formulas directly into your documentation.

Structured data within your documents

BlueDocs database and formula features are designed for organizations that need more than plain text documentation. Embed databases directly into SOPs, knowledge base articles, and training materials. Add calculations, summaries, and structured data that update automatically as information changes.

BlueDocs database and formula features are designed for organizations that need more than plain text documentation. Embed databases directly into SOPs, knowledge base articles, and training materials. Add calculations, summaries, and structured data that update automatically as information changes.

Inline database tables

Create structured databases within any document. Product catalogs, pricing tables, inventory lists, contact directories, or project trackers embedded right where teams need them.

Inline database tables

Create structured databases within any document. Product catalogs, pricing tables, inventory lists, contact directories, or project trackers embedded right where teams need them.

Inline database tables

Create structured databases within any document. Product catalogs, pricing tables, inventory lists, contact directories, or project trackers embedded right where teams need them.

Inline database tables

Create structured databases within any document. Product catalogs, pricing tables, inventory lists, contact directories, or project trackers embedded right where teams need them.

Automated calculations

Build formulas that calculate totals, averages, percentages, and complex computations. Numbers update automatically when underlying data changes.

Automated calculations

Build formulas that calculate totals, averages, percentages, and complex computations. Numbers update automatically when underlying data changes.

Automated calculations

Build formulas that calculate totals, averages, percentages, and complex computations. Numbers update automatically when underlying data changes.

Data summaries and rollups

Aggregate information across database entries. Calculate totals, count entries, find minimums and maximums, or build conditional summaries.

Data summaries and rollups

Aggregate information across database entries. Calculate totals, count entries, find minimums and maximums, or build conditional summaries.

Data summaries and rollups

Aggregate information across database entries. Calculate totals, count entries, find minimums and maximums, or build conditional summaries.

Data summaries and rollups

Aggregate information across database entries. Calculate totals, count entries, find minimums and maximums, or build conditional summaries.

Dynamic documentation

Documents that update themselves based on data changes. Pricing guides that recalculate totals, inventory docs that show current stock levels, or project trackers that compute progress percentages.

Dynamic documentation

Documents that update themselves based on data changes. Pricing guides that recalculate totals, inventory docs that show current stock levels, or project trackers that compute progress percentages.

Dynamic documentation

Documents that update themselves based on data changes. Pricing guides that recalculate totals, inventory docs that show current stock levels, or project trackers that compute progress percentages.

Dynamic documentation

Documents that update themselves based on data changes. Pricing guides that recalculate totals, inventory docs that show current stock levels, or project trackers that compute progress percentages.

Database and formula features

Database & formula control, and comply effortlessly.

Database & formula control, and comply effortlessly.

Inline Database Creation

Data Types and Formatting

Formula and Calculation

Summary and Rollup Capabilities

Database Views and Filtering

Data

Integration with Documentation

Database blocks

Add database tables directly within documents. Databases sit inline with text, images, and other content. No external spreadsheets or separate tools required.

Multiple database types

Create different database structures for different needs. Product databases, employee directories, equipment inventories, project trackers, or custom structures.

Flexible schema design

Define columns with different data types. Text, numbers, dates, checkboxes, select lists, multi-select options, URLs, email addresses, and more.

Unlimited rows

Add as many entries as needed. Small reference tables or comprehensive databases with hundreds of entries.

Column customization

Name columns, set data types, configure formatting, and establish validation rules. Build databases that match your specific needs.

Reorderable columns

Drag columns to rearrange database structure. Prioritize important information without rebuilding tables.

Inline Database Creation

Data Types and Formatting

Formula and Calculation

Summary and Rollup Capabilities

Database Views and Filtering

Data

Integration with Documentation

Database blocks

Add database tables directly within documents. Databases sit inline with text, images, and other content. No external spreadsheets or separate tools required.

Multiple database types

Create different database structures for different needs. Product databases, employee directories, equipment inventories, project trackers, or custom structures.

Flexible schema design

Define columns with different data types. Text, numbers, dates, checkboxes, select lists, multi-select options, URLs, email addresses, and more.

Unlimited rows

Add as many entries as needed. Small reference tables or comprehensive databases with hundreds of entries.

Column customization

Name columns, set data types, configure formatting, and establish validation rules. Build databases that match your specific needs.

Reorderable columns

Drag columns to rearrange database structure. Prioritize important information without rebuilding tables.

Inline Database Creation

Data Types and Formatting

Formula and Calculation

Summary and Rollup Capabilities

Database Views and Filtering

Data

Integration with Documentation

Database blocks

Add database tables directly within documents. Databases sit inline with text, images, and other content. No external spreadsheets or separate tools required.

Multiple database types

Create different database structures for different needs. Product databases, employee directories, equipment inventories, project trackers, or custom structures.

Flexible schema design

Define columns with different data types. Text, numbers, dates, checkboxes, select lists, multi-select options, URLs, email addresses, and more.

Unlimited rows

Add as many entries as needed. Small reference tables or comprehensive databases with hundreds of entries.

Column customization

Name columns, set data types, configure formatting, and establish validation rules. Build databases that match your specific needs.

Reorderable columns

Drag columns to rearrange database structure. Prioritize important information without rebuilding tables.

Database and formula solutions by use case

Icon
Product documentation and catalogs

Build product catalogs with specifications, pricing, and availability inline with product descriptions. Feature comparison matrices showing capabilities across product tiers. Pricing tables with automatic discount calculations. SKU databases with current inventory levels. Compatibility charts showing which products work together.

key topics:

Product specifications

Product specifications

Feature matrices

Feature matrices

Pricing tables

Pricing tables

SKU databases

SKU databases

Compatibility Charts

Compatibility Charts

Version Comparisons

Version Comparisons

Feature Image
Icon
Standard operating procedures

Embed equipment databases in maintenance SOPs showing specifications and maintenance schedules. Material requirement lists with quantity calculations. Time estimate tables summing total procedure duration. Resource allocation databases tracking who does what. Checklist databases with completion percentages calculated automatically.

key topics:

Equipment lists

Equipment lists

Material requirements

Material requirements

Time estimates

Time estimates

Resource allocation

Resource allocation

Checklist tracking

Checklist tracking

Process metrics

Process metrics

Feature Image
Icon
Inventory and asset management

Create inventory databases within asset management documentation. Track stock levels, calculate reorder points, and monitor inventory value. Equipment registries with purchase dates, depreciation calculations, and maintenance due dates. Location databases showing where assets are deployed across facilities.

key topics:

Stock tracking

Stock tracking

Equipment registries

Equipment registries

Location databases

Location databases

Purchase records

Purchase records

Depreciation calculations

Depreciation calculations

Maintenance schedules

Maintenance schedules

Feature Image
Icon
Financial documentation

Embed budget databases in financial procedures showing allocations by department. Expense tracking with automatic totals and percentage of budget calculations. Cost calculation tables within pricing policies. Revenue projection databases with growth rate formulas. Variance tables comparing actual versus planned spending.

key topics:

Budget tracking

Budget tracking

Expense categories

Expense categories

Cost calculations

Cost calculations

Revenue projections

Revenue projections

Allocation tables

Allocation tables

Variance analysis

Variance analysis

Feature Image
Icon
Project management documentation

Project documentation with task databases tracking status, owners, and due dates. Resource allocation tables calculating hours and costs. Timeline databases with date calculations showing project duration. Budget tracking with actual versus planned comparisons. Milestone databases with completion percentage rollups.

key topics:

Task lists

Task lists

Resource assignments

Resource assignments

Timeline tracking

Timeline tracking

Budget management

Budget management

Milestone databases

Milestone databases

Deliverable checklists

Deliverable checklists

Feature Image
Icon
Contact and directory management

Build employee directories within HR documentation with contact information, departments, and roles. Vendor databases in procurement procedures showing contact details and contract information. Customer lists in sales documentation with account details and status. Emergency contact databases in safety procedures.

key topics:

Employee directories

Employee directories

Vendor lists

Vendor lists

Customer databases

Customer databases

Partner contacts

Partner contacts

Emergency contacts

Emergency contacts

Department rosters

Department rosters

Feature Image
Icon
Training and certification tracking

Training documentation with course catalogs showing prerequisites, duration, and availability. Certification requirement databases calculating expiration dates. Skill matrices tracking team capabilities with formulas showing coverage percentages. Training schedule databases with date calculations for upcoming sessions.

key topics:

Course catalogs

Course catalogs

Certification requirements

Certification requirements

Skill matrices

Skill matrices

Training schedules

Training schedules

Completion tracking

Completion tracking

Competency databases

Competency databases

Feature Image
Icon
Compliance and policy management

Compliance documentation with regulatory requirement databases tracking status and responsible parties. Policy version databases showing effective dates and review schedules. Compliance checklist databases with completion percentage calculations. Audit finding trackers with remediation status. Risk assessment matrices with severity calculations.

key topics:

Regulatory requirements

Regulatory requirements

Policy versions

Policy versions

Compliance checklists

Compliance checklists

Audit findings

Audit findings

Risk assessments

Risk assessments

Control matrices

Control matrices

Feature Image
Icon
Sales and pricing documentation

Sales documentation with pricing databases showing base prices, volume discounts, and net pricing calculations. Product package databases with bundled offerings and total value calculations. Commission structure tables with percentage calculations. Deal calculator databases helping sales reps compute custom quotes.

key topics:

Pricing tables

Pricing tables

Discount schedules

Discount schedules

Product packages

Product packages

Commission structures

Commission structures

Deal calculators

Deal calculators

Territory assignments

Territory assignments

Feature Image
Icon
Equipment and maintenance documentation

Maintenance documentation with equipment databases showing specifications, maintenance intervals, and last service dates. Part number databases for replacement components. Service history tracking with cost calculations. Warranty databases calculating expiration dates. Replacement cycle planning with age calculations.

key topics:

Equipment specifications

Equipment specifications

Maintenance schedules

Maintenance schedules

Part numbers

Part numbers

Service history

Service history

Warranty information

Warranty information

Replacement cycles

Replacement cycles

Feature Image
Icon
Recipe and formula documentation

Food service or manufacturing documentation with recipe databases showing ingredients and quantities. Formulas that scale recipes based on batch size. Nutritional information with automatic totals. Cost calculations showing total recipe cost and per-unit pricing. Yield calculations with waste factors.

key topics:

Ingredient lists

Ingredient lists

Quantity calculations

Quantity calculations

Batch scaling

Batch scaling

Nutritional information

Nutritional information

Cost per unit

Cost per unit

Yield calculations

Yield calculations

Feature Image
Icon
Vendor and supplier management

Procurement documentation with vendor databases showing capabilities, contact information, and contract details. Pricing agreement tables with volume discounts and terms. Performance metric databases tracking on-time delivery and quality scores. Delivery schedule databases with lead time calculations.

key topics:

Vendor catalogs

Vendor catalogs

Contract terms

Contract terms

Pricing agreements

Pricing agreements

Performance metrics

Performance metrics

Contact information

Contact information

Delivery schedules

Delivery schedules

Feature Image

Advanced formula capabilities

Calculations

Calculations

Nested formulas

Build complex calculations using formulas within formulas. Multi-step computations that reference other calculated values.

Build complex calculations using formulas within formulas. Multi-step computations that reference other calculated values.

Database

Database

Cross-database references

Reference values from other databases in the same document. Build relationships between different data sets.

Reference values from other databases in the same document. Build relationships between different data sets.

Flag

Flag

Conditional formatting

Apply formatting rules based on values. Highlight overdue items, flag low inventory, or color-code status indicators.

Apply formatting rules based on values. Highlight overdue items, flag low inventory, or color-code status indicators.

Template

Template

Template formulas

Save commonly used formulas for reuse. Apply standard calculations across different databases without rebuilding formulas.

Save commonly used formulas for reuse. Apply standard calculations across different databases without rebuilding formulas.

Error

Error

Formula error dandling

Graceful error handling when formulas encounter invalid data. Prevent calculation errors from breaking documentation.

Graceful error handling when formulas encounter invalid data. Prevent calculation errors from breaking documentation.

Note

Note

Formula documentation

Add notes explaining complex formulas. Help others understand calculation logic and assumptions.

Add notes explaining complex formulas. Help others understand calculation logic and assumptions.

Why organizations choose BlueDocs databases

Why organizations choose BlueDocs databases

BlueDocs helps organizations turn scattered information into a connected, searchable source of truth for every team.

BlueDocs helps organizations turn scattered information into a connected, searchable source of truth for every team.

Eliminate external spreadsheets

Stop maintaining separate Excel files that become disconnected from documentation. Data lives with context.

Eliminate external spreadsheets

Stop maintaining separate Excel files that become disconnected from documentation. Data lives with context.

Eliminate external spreadsheets

Stop maintaining separate Excel files that become disconnected from documentation. Data lives with context.

Always current information

Calculations update automatically when data changes. No manual recalculation or version control issues.

Always current information

Calculations update automatically when data changes. No manual recalculation or version control issues.

Always current information

Calculations update automatically when data changes. No manual recalculation or version control issues.

Always current information

Calculations update automatically when data changes. No manual recalculation or version control issues.

Structured data in context

Databases appear exactly where teams need them within procedures and documentation. No switching between tools.

Structured data in context

Databases appear exactly where teams need them within procedures and documentation. No switching between tools.

Structured data in context

Databases appear exactly where teams need them within procedures and documentation. No switching between tools.

Better decision support

Formulas provide instant calculations helping teams make informed decisions without external tools.

Better decision support

Formulas provide instant calculations helping teams make informed decisions without external tools.

Better decision support

Formulas provide instant calculations helping teams make informed decisions without external tools.

Single source of truth

Data and documentation in one place. No discrepancies between procedures and reference materials.

Single source of truth

Data and documentation in one place. No discrepancies between procedures and reference materials.

Single source of truth

Data and documentation in one place. No discrepancies between procedures and reference materials.

Improved documentation quality

Structured data makes documentation more comprehensive and useful. Numbers, specifications, and calculations inline with instructions.

Improved documentation quality

Structured data makes documentation more comprehensive and useful. Numbers, specifications, and calculations inline with instructions.

Improved documentation quality

Structured data makes documentation more comprehensive and useful. Numbers, specifications, and calculations inline with instructions.

Reduced documentation maintenance

Update data once and calculations adjust automatically. Reduce time spent maintaining accurate documentation.

Reduced documentation maintenance

Update data once and calculations adjust automatically. Reduce time spent maintaining accurate documentation.

Reduced documentation maintenance

Update data once and calculations adjust automatically. Reduce time spent maintaining accurate documentation.

Customer success story

Customer success story

Hear how businesses like yours accelerated growth, optimized workflows, and delivered measurable outcomes through our custom AI solutions.

Hear how businesses like yours accelerated growth, optimized workflows, and delivered measurable outcomes through our custom AI solutions.

A 200-person manufacturing company documented production procedures in static PDFs. Each procedure included equipment specifications, material requirements, and time estimates, but this information was scattered across multiple documents and often outdated. When equipment specifications changed or material costs shifted, they had to update dozens of procedures manually. Production planners spent hours calculating total material requirements across multiple procedures for production runs.

A 200-person manufacturing company documented production procedures in static PDFs. Each procedure included equipment specifications, material requirements, and time estimates, but this information was scattered across multiple documents and often outdated. When equipment specifications changed or material costs shifted, they had to update dozens of procedures manually. Production planners spent hours calculating total material requirements across multiple procedures for production runs.

They migrated procedures to BlueDocs and embedded databases directly into SOPs. Each production procedure included an equipment database with specifications, a materials database with current costs and automatic total calculations, and a time estimate database with step duration formulas calculating total procedure time. When equipment specifications changed, they updated one database entry and all procedures referencing that equipment automatically reflected current information. Material cost databases calculated total procedure cost and allowed production planners to see material requirements at a glance.

They migrated procedures to BlueDocs and embedded databases directly into SOPs. Each production procedure included an equipment database with specifications, a materials database with current costs and automatic total calculations, and a time estimate database with step duration formulas calculating total procedure time. When equipment specifications changed, they updated one database entry and all procedures referencing that equipment automatically reflected current information. Material cost databases calculated total procedure cost and allowed production planners to see material requirements at a glance.

Documentation maintenance time decreased by 70% because data updates propagated automatically. Production planners saved 5 hours per week previously spent manually calculating material requirements. Procedures became more accurate because calculations eliminated manual math errors. Quality team used time estimate databases to identify process improvement opportunities by comparing estimated versus actual durations.

Documentation maintenance time decreased by 70% because data updates propagated automatically. Production planners saved 5 hours per week previously spent manually calculating material requirements. Procedures became more accurate because calculations eliminated manual math errors. Quality team used time estimate databases to identify process improvement opportunities by comparing estimated versus actual durations.

“ Their Director of Operations said the transformation came from turning static reference information into dynamic, calculated data that stayed current automatically. “

“ Their Director of Operations said the transformation came from turning static reference information into dynamic, calculated data that stayed current automatically. “

Sarah Chen

Head of Customer Success

Get started with BlueDocs databases and formulas

Transform document chaos into organized, engaging knowledge experiences.

Free 7-day trial

No credit card required. Full access to all training and onboarding features.

See it in action

Book a personalized demo focused on your onboarding and training needs.

Questions?

Talk to our team about automating your employee training and onboarding.