Node Types

Everything on a FlowFrame canvas is a node. Frames query data, linked frames build on them, charts and parameters make the results interactive, and text, shapes and images explain them.

Query Nodes (Frames)

Frames are the core building blocks of FlowFrame. Each frame holds one SQL query and shows its result as a table, so a frame is a single step in your analysis.

Creating a Frame

Drag a table from the data panel onto the canvas. The frame is named a1 (then a2, a3 and so on) and starts with a default query:

SELECT * FROM table_name

The frame header shows the frame name, the connection it queries, a Nocode / SQL toggle and an expand button. The query editor sits above the result table.

A query frame named a1 with its connection chip, SQL editor and result table

A frame with its name, connection, Nocode / SQL toggle, query editor and result table

The Frame Toolbar

Click a frame to show its toolbar above it:

  • Refresh runs the query again.

  • Analyze data opens the query in a larger editor where you can switch between Nocode steps (Summarize, Filter, Sort and more) and SQL, preview the result, then Save & Run.

  • + Add creates a Visualization or a Frame from result linked to this frame.

Frame Settings

With a frame selected, click the menu button at the top right of the canvas to open its settings panel. Click the pencil next to the frame name to rename it.

  • Style: show or hide the query editor (hide it to use the frame as a plain table), background and text colour, and the border.

  • Actions: run the query, add a visualization, format the query, get a code breakdown, or add a linked frame.

  • Export: download the frame as an image or the result as CSV.

  • Arrange: bring the frame forward or send it back when nodes overlap.

The frame settings panel with Style and Actions sections

The settings panel for a selected frame

Linked Frames

A linked frame queries the result of another frame, so you can build an analysis in small steps instead of one long query. An arrow on the canvas shows which frame feeds which.

Creating a Linked Frame

Select a frame, click + Add in its toolbar and choose Frame from result. You can also use Add linking frame in the frame settings panel. The new frame starts by selecting everything from its parent:

SELECT * FROM a1
The frame toolbar with the Add menu open, showing Visualization and Frame from result

Add a visualization or a linked frame from the frame toolbar

Edit the query to reshape the parent's result, for example to aggregate it:

SELECT region, ROUND(SUM(sales)) AS sales
FROM a1
GROUP BY region
ORDER BY sales DESC
Frame a1 linked by an arrow to frame a2, which aggregates a1 by region

Frame a2 reads from a1 by name

Dependency Rules

Important
Changes flow downstream only. Editing a frame updates that frame and every frame and chart built on it, never the frames it reads from.

Visualization Nodes

Visualization nodes chart a frame's result. They are connected to their source frame by an arrow and update whenever that frame runs.

1

Add a chart

Select a frame, click + Add and choose Visualization, or use Add visualization in the frame settings panel. FlowFrame adds a chart with a first guess at the axes.
2

Pick the columns

Click a chart to show the chips below it. Use X-axis and Y-axis to choose columns and the aggregation (such as Sum), and Color by to split the chart by a column.
3

Change the chart type and style

Use the chart type dropdown in the chart toolbar to switch types, and the settings button next to it for titles, colours and axes. See Chart Customization for every option.
A bar chart titled Sales by Region with its toolbar and X-axis and Y-axis chips

A selected chart with its toolbar and axis chips

Available Chart Types

  • Line

  • Vertical Bar

  • Horizontal Bar

  • Stacked Bar

  • Area

  • Pie

  • Scatter

  • Bubble

  • Histogram

  • Card

Parameter Nodes

A parameter node holds one value that any number of frames can use. Change the value and every frame that references it, plus the charts built on those frames, update together. This is how you build interactive dashboards.

1

Create a parameter

Click the (x) Add Parameter Node button in the top toolbar.
2

Configure it

  • Double-click the name to rename it

  • Choose a type: String, Number, Date, Boolean or List (comma-separated values)

  • Enter a value

A String parameter named region with the value West and the reference {{region}}

The footer shows the reference to use in SQL

3

Reference it in SQL

Use the reference shown in the node's footer, for example:
SELECT order_id, order_date, category, sales
FROM a1
WHERE region = {{region}}
Run the frame. An arrow now connects the parameter to the frame.
4

Change the value

Edit the value and run the parameter with its play button. Every connected frame and chart reruns with the new value.
Warning
Don't wrap the reference in quotes. String values are quoted for you, so '{{region}}' fails with a syntax error.
Frame a3 filtered with WHERE region = {{region}}, connected by an arrow to the region parameter

A frame filtered by a parameter

Tip
Collapse a parameter node with the chevron in its header to keep the canvas tidy. It keeps working while collapsed.

Text, Shape & Image Nodes

Text, shape and image nodes let you label and explain your canvas. Add them from the top toolbar.

The canvas toolbar with the Add Text, Add Shapes and Add an Image buttons highlighted

Add Text, Add Shapes and Add an Image in the top toolbar

Text Nodes

Click Add Text, then click the canvas where the text should go. Double-click the node to type. While editing, a toolbar lets you set bold, italic, underline, text colour and background fill.

A text node being edited, with its formatting toolbar above it

A text node and its formatting toolbar

Shape Nodes

Click Add Shapes and pick a shape: Rectangle, Circle, Triangle, Pentagon, Hexagon, Octagon, Parallelogram, Trapezium, Line. Double-click a shape to open its settings, where you can set rotation (0° to 360°), corner radius, border colour and width, and fill colour.

The Add Shapes menu listing the available shapes

The shapes you can add to the canvas

Image Nodes

Click Add an Image, then paste an image URL or choose a file from your computer and click Submit. You can resize and move image nodes like any other node.

The Add Image dialog with an image URL field and a file picker

Add an image from a URL or a local file

Ready to build with FlowFrame?
Create your free account and start building visual data workflows today.
Start Free