Copy a row into another table.

The network action copies values from a row into a table that you choose. The action can add a new row there, or update a row that matches. The action makes no calls outside Morphcloud.

Get started

How actions work

Example 1

Flag large orders

An order over 500 is copied into Large Orders.

Example 1 · Flag Large Order

Send large orders for a check.

Two conditions make the action run only for an order over 500 that has no Large Order Row yet. Of five new orders, only SO-10449 was over 500. The action added the order to Large Orders as row 4, and wrote 4 back into the order.

Demo: the page of the network action Flag Large Order. It runs on Orders and writes to Large Orders, which has 2 rows. A pointer clicks Orders. Five new orders, rows 17 to 21, arrive with their customer and total. Only row 19, SO-10449, Owen Price, 615.6, is over 500: its Large Order Row becomes 4. The pointer opens Large Orders, where row 4 is the new copy of SO-10449.

What you set on a network action.

These settings belong to the network action. Inputs, outputs, columns and conditions work the same as on every action: see Actions.

One table to write

Choose the table once. Its columns become the action’s inputs. To write a different table, make a new action.

How the action writes rows

Always add a new row. Or add one only if no row matches, update only a row that matches, or update a match and else add a row.

Columns to match

A row matches when it has an equal value in every match column. Every mode except Always add needs a match column.

The row the action wrote

The Row ID of the new or updated row can come back into a column, as Large Order Row does here.

Good to know.

The action makes no outside calls.