Connect Grist and RO App

Both apps 76Grist 25RO App 51

• Trigger
  New or Updated Record

  Triggered when a row in a Grist table is created or updated.

• Trigger
  New or Updated Record (Instant)

  Triggers when a Record is updated, or a new Record is added.

• Trigger
  New Record

  Triggered when a new row is added to a Grist table.

• Trigger
  New Record (Instant)

  Triggers when a new Record is created

• Action
  Add Column

  Adds a column to a table in a Grist document.

• Action
  Add Table

  Creates a new table in a Grist document, optionally with a starting set of columns.

• Action
  Create Document

  Creates a new document in a Grist workspace and returns its document ID.

• Action
  Create or Update Record

  Adds a row to a Grist table, or updates the existing row when the match column already holds the match value. Returns the row ID.

• Action
  Create Record

  Adds a new row to a Grist table and returns its row ID.

• Action
  Create Workspace

  Creates a new workspace in a Grist organization and returns its ID.

• Action
  Delete Document

  Deletes a Grist document permanently.

• Action
  Delete Records

  Deletes one or more rows from a Grist table by row ID.

• Action
  Delete Workspace

  Deletes a Grist workspace along with every document inside it.

• Action
  Find Record

  Searches a Grist table for a row whose column holds a given value and returns that row's ID and column values.

• Action
  Get Document

  Returns the details of one Grist document — its name, web address, workspace, and organization.

• Action
  Get Org

  Returns the details of one Grist organization (team site) — its name, subdomain, owner, and your access level.

• Action
  Get Workspace

  Returns the details of one Grist workspace, including the documents it contains.

• Action
  List Columns

  Returns the columns of a Grist table, with each column's ID, label, and type.

• Action
  List Orgs

  Returns every Grist organization (team site) this connection can reach.

• Action
  List Tables

  Returns the tables in a Grist document.

• Action
  List Workspaces

  Returns the workspaces in a Grist organization, each with the documents it contains.

• Action
  Run SQL Query

  Runs a read-only SELECT statement against a Grist document and returns the rows.

• Action
  Update Document

  Renames a Grist document or changes whether it is pinned. Anything left blank stays as it is.

• Action
  Update Record

  Changes the column values of one row in a Grist table. Columns left blank keep their current values.

• Action
  Update Workspace

  Renames a Grist workspace.

• Trigger
  Ad Campaigns

  Triggers when a new ad campaign is added in RO App.

• Trigger
  Cash Flow Items

  Triggers when a new cash flow category (income or expense item) is added in RO App.

• Trigger
  Clients List

  Triggers when a new client (person contact) is added in RO App.

• Trigger
  Employees List

  Triggers when a new employee is added to the RO App company account.

• Trigger
  Lead Types

  Triggers when a new inquiry (lead) type is added to your RO App account.

• Trigger
  List of Services

  Triggers when a new service is added to the RO App service catalog.

• Trigger
  List of the Products

  Triggers when a new product is added to the RO App catalog, optionally limited to products matching a name, barcode, SKU, code, MPN or category.

• Trigger
  Locations

  Triggers when a new location is added to your RO App company.

• Trigger
  New Invoice Statuses

  Triggers when a new invoice status is added to your RO App account.

• Trigger
  New Order Items

  Triggers when a new item (product or service) is added to the selected order.

• Trigger
  New Taxes

  Triggers when a new tax rate is added to the company in RO App.

• Trigger
  Order Statuses

  Triggers when a new order status is added to your RO App account.

• Action
  Add Booking Item

  Adds a product or service line item to an existing booking.

• Action
  Add Lead Comment

  Adds a comment to a lead (inquiry) in RO App.

• Action
  Add Order Comment

  Adds a comment to an existing order in RO App, optionally marked private.

• Action
  Add Task Comment

  Adds a comment to a task in RO App.

• Action
  Changing Order Status

  Changes the status of an order, optionally with a comment.

• Action
  Create a Client

  Creates a new client (person) in your RO App contacts.

• Action
  Create a Lead

  Creates a new lead (inquiry) in RO App, optionally linked to a client, location, manager and ad campaign.

• Action
  Create an Order

  Creates a new order in RO App for a client at a chosen location.

• Action
  Create an Order Item

  Adds a product or service line item to an existing order in RO App.

• Action
  Create an Order or Estimate

  Creates a new estimate in RO App for a client at a location.

• Action
  Create a Payment

  Records an income or expense payment in a cashbox in RO App.

• Action
  Create Asset

  Creates a new asset (such as a vehicle or device) in RO App, identified by its serial number.

• Action
  Create Booking

  Creates a new booking for a client at a location with an assigned employee and time slot.

• Action
  Create Product

  Creates a new product in the RO App catalog.

• Action
  Create Service

  Creates a new service in the RO App catalog.

• Action
  Create Task

  Creates a task in RO App with a title, due date and assigned employees, optionally linked to an order, lead, client or invoice.

• Action
  Create Update_booking

  Updates an existing booking's location, status, assignee, client, schedule, resource or comment.

• Action
  Find Product

  Finds products in the RO App catalog by name, barcode, SKU, code, manufacturer part number or category.

• Action
  Find Service

  Finds services in the RO App catalog by name, barcode or category.

• Action
  Get Booking Items

  Returns all the service items on a specific booking.

• Action
  Get Client by ID

  Returns the details of a single client (person) by its ID.

• Action
  Get Estimate by ID

  Returns the full details of a single estimate, including its custom field values.

• Action
  Get Lead by ID

  Returns a single lead (inquiry) by its ID, including its custom fields.

• Action
  Get Order by Id

  Returns the full details of a single order by its ID.

• Action
  Get Prices

  Returns the list of price types (margins) configured for your company.

• Action
  Get Product by Id

  Returns a single product from your RO App catalog by its ID, including its custom fields.

• Action
  Get Product Categories

  Returns the product categories in your RO App catalog, optionally limited to the children of one parent category.

• Action
  Get Service Categories

  Returns the list of service categories in your RO App catalog, optionally under a parent category.

• Action
  Get Task

  Returns a single task by its ID, including all of its details.

• Action
  Get UOMs (Inits of Measure)

  Returns the list of product units of measure (UOMs) defined in the RO App account.

• Action
  Move Asset

  Moves an asset to a different warehouse.

• Action
  Search for Assets

  Searches assets by serial number (VIN, IMEI), optionally narrowed by warehouse, owner or asset ID.

• Action
  Search for Clients

  Searches clients (people) by name, phone, email, manager, tag or date, and returns the matching clients.

• Action
  Search Task

  Searches tasks for ones whose title or description contains the given text, optionally narrowed by author, assignee or deadline.

• Action
  Update an Order Item

  Updates an existing item on an order — its quantity, price, cost, discount, warranty, taxes, assignee or comment.

• Action
  Update an Order or Estimate

  Updates an existing order (or estimate) in RO App — its location, type, people, schedule, notes, due date and custom field values. Fields left blank are not changed.

• Action
  Update_booking_item

  Updates the quantity, price, cost, discount, warranty, taxes or comment of an item on a booking.

• Action
  Update Client

  Updates an existing client (person) in RO App contacts.

• Action
  Update Product

  Updates an existing product in the RO App catalog, such as its title, SKU, category, prices or barcodes.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.