Virtual fields

Share and reuse fields

Show a field on every table in a workspace or everywhere, limit it to one Data Model entity, and copy fields from one table to another.

A field starts on the table you created it on and computes on every item. You can show it on more tables, narrow it to one kind of item, or copy a set of fields to another table.

Show a field on more tables

  1. Open the field dialog for a new field, or choose Edit field from the field’s column header.
  2. Set Show on to one of these.
    • This table, the table the dialog was opened on. The option names it, such as This table (OrbitPasses).
    • This workspace, every table in the workspace.
    • All workspaces, every table.
  3. Click Save.

A table shows one field for each name, and the narrowest scope wins. A table field hides a workspace or global field of the same name on that table, and a workspace field hides a global one. The dialog says when your field hides another, as in Hides the workspace field “status” on this table., or when another hides yours. A hidden field still shows on its other tables.

A related or collection column shows only on its link’s table.

Compute a field on one entity only

When the table has a Data Model, Applies to offers All items or One entity.

  1. In the field dialog, set Applies to to the entity, such as student.
  2. Click Save.

The field computes only on that entity’s items. Every other row shows a dimmed dash for “does not apply”, and the expression never runs on it. The grid, the item view, compare, export, the loaded-rows filter and agents all use the same rule to decide which items belong.

Applies to needs the Data Model gate, which comes with a paid plan. On a table with no Data Model, it shows All items with the reason beside it.

When an entity leaves the table’s Data Model, a field scoped to it is not changed. The Virtual fields menu lists it under Needs attention, such as Order is no longer in the Data Model, with Edit field.

Copy fields to another table

  1. On the source table, click Virtual fields, then Copy fields as JSON. The clipboard holds the fields the table shows, in column order, up to 100.
  2. Open the destination table.
  3. Click Virtual fields, then Paste fields.
  4. Read the list. Each field says Adds, Skipped or Not pasted, and a summary line counts them, such as 2 to add, 1 skipped, 3 not pasted.
  5. For a name the table already uses, choose Rename to “name (2)”, the default, Replace the existing field, or Skip.
  6. Click Paste N fields, which counts the fields it will save.

Paste checks each expression before it lists the field, and does not paste one that is empty or does not compile. The copy holds no workspace id and no item data.

A related or collection field pastes only as a table field onto the table whose link it reads, such as back onto the table it came from. On any other table, the list says why it is not pasted.

Last updated on