Lucy
  • Introduction to Lucy
  • Getting Started
  • Key Components
  • Gallery (Dashboards)
    • Creating a Canvas
    • Editing Properties of a Canvas
    • Searching and Viewing Your Canvases
    • Adding Widgets onto Your Canvas
    • Customising User-created Widgets on a Canvas
    • Adjusting Widget Settings
    • Moving a Widget around a Canvas
    • Resizing a Widget on a Canvas
    • Filtering Data in a Widget
    • Deleting a Widget from Your Canvas
    • Building a Widget from Your Canvas
    • Customising a Canvas
  • My Work (Folders)
    • Creating a New Folder
    • Searching and Viewing Your Folders
    • Adding Notes related to a Folder
    • Databases
      • Understanding Databases
      • Creating and Editing Databases
        • Creating a Database Manually
        • Creating a Database by Importing Data from an External Source
        • Using an External Source as a Database
        • Editing Fields in a Database
      • Editing Data in a Database
      • Using the Database Collection Viewer
      • Searching, Filtering, and Sorting Data in a Database
      • Exporting Data from a Database
      • Utilising Content-aware Autofill to Automatically Fill in Fields in Your Database
      • Entering a Question about Databases within a Folder to Build Your Own Widget
      • Adding Data into a Database
    • User Interfaces
      • Designing a User Interface
        • Designing a User Interface to Visualise Information
        • Designing a User Interface to Capture User Feedback
        • Designing a User Interface from Scratch
      • Working with the Widget Designer
      • Selecting a Widget Template
        • Item List Widget Template
      • Viewing Your User Interfaces
      • Sharing a User Interface
      • Saving a Widget as a Template
      • Exporting a User Interface
      • Enabling Anonymous Access to a User Interface
    • Workflows and Integrations
      • Using the Workflow Editor
      • Creating Workflows
      • Creating a Workflow to Run When New Data is Added to a Database
      • Creating a Workflow to Run When an Email is Received
      • Creating a Workflow to Run When a Message from a Chatbot is Received
      • Creating a Workflow that Runs at Specified Intervals
      • Viewing and Editing Your Workflows
      • Automating Form Submission with Email Notification
      • Automating Form Submission with Slack Message
  • Add-ons
    • Installing a New Add-on in Lucy
    • Visitor Management
    • Monitoring Internal Air Quality (IAQ) at Your Workplace
    • Setting up Occupancy Analytics at Your Workplace
    • Energy Budgeting
    • Water Budgeting
    • Gas Budgeting
    • Carbon Footprint Calculation
    • Weather
  • Mobile App
    • Getting Started
    • Designing Your Mobile App
      • Working with the Mobile App Designer
      • Handling Button Click Events
      • Designing the Login Page
      • Designing the Homepage
      • Designing the Settings Page
      • Choosing a Page Type
      • Adding a New Tab to the Bottom Navigation Bar
      • Launching a Widget on Tab Click
  • Users
    • Registering a User
    • Creating a User Group
    • Searching and Viewing Users
    • Editing User Details
    • Your Profile
  • News Feeds
    • Creating a News Feed
    • Searching and Viewing News Feeds
    • Editing a News Feed
Powered by GitBook
On this page
  • Ways to Create Databases
  • 1. Creating a Database Manually
  • 2. Importing Data from an External Source
  • 3. Using an External Source as a Database
  • Adding New Data to a Database
  • Editing Databases
  • Editing Information in a Database
  • Editing Fields in a Database
  1. My Work (Folders)
  2. Databases

Creating and Editing Databases

PreviousUnderstanding DatabasesNextCreating a Database Manually

Last updated 8 months ago

Lucy allows you to create databases, store data, and query arbitrary data at any time. These databases are flexible, document-based storage spaces that don't require a strict schema, making them adaptable to various data types and structures.

This article explains how to create new databases and edit them. There are three ways to create a database:

Ways to Create Databases

Here are the three methods to create a new database in Lucy.

1. Creating a Database Manually

Databases can be created from scratch or by selecting an built-in template.

For more insights, find the article here.

2. Importing Data from an External Source

You can form databases by importing data from external sources such as data from csv/xlsx files.

For more insights, find the article here.

3. Using an External Source as a Database

Lucy allows you to create databases using online data sources such as Google sheets or Excel, eliminating the need for data importing.

For more insights, find the article here.

Adding New Data to a Database

Upon creating a database, you can add new data to it.

To gain more knowledge on adding new data to a database, find the article here:

Editing Databases

Editing Information in a Database

Editing Information in a Database refers to updating existing records, inserting new data records, removing unnecessary records from it. In Lucy, tweaking information stored in a database is pretty straightforward and achievable in few simple steps.

For more insights, find the article here.

Editing Fields in a Database

Modifying, adding, or deleting fields in a database is a straightforward process that can be accomplished in a few simple steps.

For more insights, find the article here.

Using an External Source as a Database
Adding Data into a Database
Editing Data in a Database
Editing Fields in a Database
Creating a Database Manually
Creating a Database by Importing Data from an External Source
Creating a Database Manually
Importing Data from an External Source
Using an External Source as a Database