Stacker
Login to StackerStart buildingChangelogFeedbackStacker Classic Docs
  • Getting Started
    • How Stacker Works
    • Introduction to Editing Data
      • Stacker Tables: Paste Data
      • Stacker Tables: Import a CSV
    • Introduction to Designing your app
    • Introduction to Adding Users & Permissions
    • Introduction to Portals
  • Workspace, Portals, and Apps
    • Overview
    • Workspace
      • Workspace Settings
      • Workspace Users
      • Groups
    • Portals
      • Custom Domain
    • Apps
  • AI & Automations
    • AI Agents (Beta)
      • Setting up your AI agent
      • Agent Triggers
      • Operating Instructions
      • Tools
      • Skills
      • Renderer
      • History and Tasks
    • Workflows (Beta)
    • Integrations
      • Zapier Integration
      • Make.com Integration
    • Open API Overview
      • Setup Guide
      • Authentication
      • Additional Headers
      • Field API names
      • Accounts, Stacks, Objects, Fields
      • Record Actions
    • Action buttons
      • Use an Action Button
      • Create a page button on detail layout
      • Action buttons in field widgets
      • Edit an action button
  • Data management
    • Import data to Stacker Tables
      • Stacker Tables: Import a CSV
        • External IDs
      • Stacker Tables: Paste Data
    • Edit your Data in the Data Grid
      • Structuring data/schema
      • Add new fields
      • Formula Field
      • Creating and Editing Data
      • Share data with other apps
      • Linking your data
      • Set field default values from the data grid
    • Edit Data in the Layout
    • Layout Types
    • Data Integrations (Beta)
      • Airtable (Beta)
      • Hubspot (Beta)
      • Intercom (Beta)
      • Gorgias (Beta)
      • Netsuite (Beta)
  • User Access
    • Add Users
      • Roles
    • Log in flow
  • Customize Layouts
    • List Layout
      • Display Types
      • Edit List Layouts
    • Detail Layout
      • Layout options
      • Tabs
        • Feed Tab
      • Page Buttons
      • Widgets
      • Customize fields
        • Field Icons
    • Detail Pages (new! beta)
      • Widgets
      • Headers
      • Style
      • Controls
      • Layout Options
    • Create form
      • Auto-filling values into create forms
    • Custom Pages
    • Navigation
  • Security
    • Roles
    • Add User Permissions
      • Create or edit a permission rule
        • Record Filter
        • Ownership filter
        • Data filter
        • Permission Sharing
        • Field Access
        • Record Deletion
      • Troubleshooting Permissions
    • Data Filters
      • Conditional Visibility Filter
  • Interactivity
    • Feeds
    • Mobile Responsiveness
  • Use Cases
    • Profile views and team directories
    • Create a Ticketing App
    • Create a CRM App
  • Account Information
    • Stacker Support Access
    • Pricing
Powered by GitBook
On this page
  1. Getting Started

Introduction to Editing Data

PreviousHow Stacker WorksNextStacker Tables: Paste Data

Last updated 7 months ago

Stacker apps rely on data to function effectively. With Stacker tables, you can manage and organize your database, enabling the creation of fully operational apps. This process includes uploading data, updating your schema (such as field names and types), and adding records directly to your database.

Data Management Overview

Data management refers to the organization, storage, and retrieval of data in a structured way. This includes:

  • Adding new tables, fields, or records to your database.

  • Organizing and cleaning up unused fields or records in your apps.

How to Access Data in Stacker

To manage your data effectively, explore the various features of the Stacker Data Grid:

Stacker offers flexibility in incorporating your existing data. You can do this through CSV imports, by pasting new tables, or by starting from scratch. When you add a new table, a corresponding layout is created on the front end of your app, powered by your data grid.

Options for Adding New Tables

  1. Import from a CSV Choose existing data from an Excel sheet, Google Sheet, or another data source to export as a CSV file, which can then be imported into Stacker. This allows you to create a user-friendly interface for others to interact with the data, while maintaining control over access to your spreadsheet.

  2. Paste Data Use the copy/paste option to input data without requiring headers or predefined fields. This provides flexibility in how you create your fields.

  3. Start from Scratch If you’re starting a new project, you can add fields as you go, allowing for the flexibility to capture the data you need.

Whether you’re starting from scratch or using your own data, you can add new fields to collect additional information about your users or the companies you work with. You can also update existing fields, such as changing the name or the icon associated with them.

How to Manage Your Fields

  • Add New Fields: To add a new field, select the plus icon on the far right of the data grid.

  • Edit a Field: Click the down arrow next to the field in the data grid to rename it, change its icon, or modify the field type. Note: Some field types may not convert correctly.

Types of fields:

Field Type
Description
Display options

Short Text

A single line of text - e.g suggested for names, titles, emails and short details.

Long Text

A longer, multi-line text field - e.g suggested for notes, comments and descriptions.

Rich Text

A longer, multi-line text field with text formatting options - e.g You can add headers, hyperlinks and code blocks. Suggested for notes, comments and descriptions.

Display in a Document Layout

Currency

A value formatted in your chosen currency - e.g prices, revenue and payment details.

Choose the currency label to use.

Number

Any type of numeric value - e.g number of products.

Percentage

A percentage-formatted value - e.g growth stats, churn stats etc.

Display your percentage as a progress bar or ring.

Checkbox

A single checkbox that can be checked or unchecked - e.g allow users to check a box to show they have read and understood the information.

Display Check box fields:

Single Select

Select a single option from predefined dropdown options. Suggested for statuses - e.g. To Do, In Progress, Done.

Assign colors to your different options.

Multiple Select

Select multiple options from predefined dropdown options e.g users can select multiple products.

Assign colors to your different options.

Date

Enter a date or pick one from a calendar - e.g users can select a date for events.

Date and Time

Enter a date and a time, or pick from the calendar - e.g users can include a time for an event.

Link to another record

Link to a record in another table - e.g Link a user to their profile. Use dynamic data filtering to limit what records can be selected in a drop down.

Link to multiple records

Link to records from another table - e.g Link orders to users. Use dynamic data filtering to limit what records can be selected in a drop down.

Lookup related value

Show a specific field from a linked table. Filter records on your lookups using data filters.

Roll-up related records

Display different results of a field based on related records. Filter records on your rollups using data filters.

  • Number of related records

  • Count values...

  • Count unique values...

  • Sum...

  • Average...

  • Min...

  • Max...

Created Date

Field will auto fill with the date the record was created.

Created By

Field will auto fill with the user profile of the person who created the record.

Formula

Calculate a value based on other fields in the same record. Start typing for formula suggestions.

Display your formula as a percentage, number or currency.

Attachments

Add images, documents or other files -e.g Profile images, invoices.

Record ID

Field auto populates with the record ID associated the record.

Autonumber

Create a field that will automatically assign numbers to records.

Last updated Date

Field will update with the date field is last updated.

Last updated by

Field will update with the user profile field of who last updated it.

URL

Display a link.

Display as a button, open in a new tab

Adding or Updating Records in the Data Grid

You can easily add or update records directly within your data grid. This feature is particularly useful when you need to manage multiple records simultaneously or when you want to make bulk updates.

How to Add or Update Records

  1. Adding Records: To add new records, navigate to the data grid and locate the option to add a new entry at the bottom of the data grid. You can input the necessary information for each field individually or paste to input multiple records at once.

  2. Updating Records: To update existing records, simply locate the record you wish to modify within the data grid. Click on the cell you want to change and enter the new information. This allows for quick edits and adjustments to your data without navigating away from the grid.

  3. Bulk Actions: For large-scale updates, consider pasting information in. This allows you to update multiple records at once.

This functionality enhances your ability to manage data efficiently, ensuring that your records are always up to date and accurately reflect your needs.

Effective data management is essential for maximizing the utility of your information. By understanding how to add records, create new fields, and incorporate data from various sources, you can maintain an organized and efficient database. Follow the examples and guidelines provided to enhance your data management skills.

You can add new tables, manage your schema (fields and objects), and input records directly into your Stacker app through the Data Grid.