Rowy Documentation

website·Indexed 35 days ago

https://docs.rowy.io/

A low-code UI for Firebase that allows developers to manage Firestore collections as spreadsheets. Features include support for over 30 field types, derivative fields for JS-based automations, webhook integration for services like Stripe and Webflow, and tools for importing data from CSV, JSON, Airtable, and PostgreSQL.

Tokens
40K
Snippets
115
Records
322
Agent score
66%

What's inside Rowy

  1. Overview of Rowy Derivative fields

    Derivative fields allow you to build product automations based on data CRUD operations. They derive their value from other fields in the same row and are automatically re-evaluated whenever those dependent fields are updated. The logic is written as a JavaScript function body in the Column Settings and executes within a Node.js cloud function environment.

    Prerequisites:

    • Proficiency in basic JavaScript.
    • Rowy Cloud Functions must be set up via the Rowy Run one-click deploy.
  2. Overview of Rowy low-code platform capabilities

    Rowy is an open-source low-code platform designed for building product backends on Firebase and Google Cloud Platform. It allows developers to manage databases and create backend functionality through a browser-based spreadsheet interface. Key capabilities include:

    • Database CMS: Manage Firestore databases using a spreadsheet-like UI.
    • Low-code Cloud Functions: Create backend automations with or without code directly in the browser.
    • Templates: Use ready-made database and code templates to accelerate development.
    • Extensibility: Customize functionality using JavaScript/TypeScript with support for any NPM package or API.
    • Third-party Integration: Connect to external platforms via APIs and Webhooks.
  3. Overview of Rowy Connector columns

    Connector columns enable the execution of backend code to return a list of options to the user. These options can be sourced from a static list, documents within a Firestore collection, or results from a third-party API query.
  4. Overview of Rowy Audit Fields

    Rowy Audit Fields allow teams to track changes made to data by recording specific metadata for every record. The available audit fields are:

    • Created By: The user who created the record.
    • Created At: The date and time when the record was created.
    • Updated By: The user who last updated the record.
    • Updated At: The date and time when the record was last updated.

    These fields are updated in real-time and are stored directly in the connected Firestore collection documents.

  5. Overview of BuildShip integration for Rowy

    BuildShip is a low-code, AI-based visual backend and workflow builder that integrates with Rowy. The BuildShip Extension allows developers to connect Firebase data on Rowy to APIs and trigger complex backend workflows (such as sending emails, newsletter subscriptions, or Discord/Slack notifications) based on Create, Update, and Delete events within a Rowy Table.
  6. Overview of Rowy Run

    Rowy Run is a group of Cloud Run services that provide essential backend functionality for Rowy, including derivatives, action scripts, webhooks, user management, and Cloud Function deployment. It operates exclusively within your own Google Cloud Platform (GCP) project, ensuring that your data remains private. Rowy Run is open source and available on GitHub.
  7. Manage Rowy backend with Rowy Run

    Rowy Run is a Cloud Run instance that provides the necessary backend functionality for Rowy, including the execution of backend logic and system operations.
  8. Resolve Rowy sign-in issues in Firefox Private Browsing

    To use Rowy in Firefox private mode, navigate to the cookies settings page at about:preferences#privacy. Use the "custom" option and ensure the "cookies" option is deselected to allow the necessary authentication cookies.
  9. Configure Rowy Extensions

    Rowy Extensions provide additional functionality and are managed via a dedicated Extensions UI within the platform.
  10. Use File and Image field types in Rowy

    File and Image fields upload content to Firebase Storage. Both store an array of objects containing metadata about the uploaded file.
    // Data structure for Image and File fields
    Array<{ 
      downloadURL: string; 
      lastModifiedTS: number; 
      name: string; 
      ref: string; 
      type: string; 
    }>
  11. Sync data between Firestore documents using DocSync Extension

    The DocSync Extension synchronizes specific data fields from a source document to a target document in Firebase Firestore. It operates by listening for changes on a source document and applying those changes to a destination specified by a target path.
  12. Rowy Frontend Architecture Overview

    Rowy's frontend is built using MUI (Material UI) with a custom theme and Jotai for global state management. When building new UI, developers should use standard MUI components without setting variants (like dense) unless specifically required for emphasis (e.g., Button with variant="contained" color="primary").