Skip to content
Content SnareHelp centre

Collect structured data with tables

Quick answer

Add a Table field to a request when you'd otherwise send a client a spreadsheet to fill in. Each row is one entry, like a bank account or a property, and each column is one detail. Columns can be different types, including text, dates, numbers and file uploads.

A table collects a list of entries, with one row for each entry and one column for each detail. Use a table whenever you'd otherwise send a client a spreadsheet to fill in, such as a list of bank accounts, staff, properties or transactions where every entry needs the same details.

You set what each column holds, so each column can be a different type: text, a date, a number or a file upload. Do not use a table for a long written answer. A single text question suits that better.

If each entry needs its own instructions, or the questions change from one entry to the next, a repeatable section fits better than a table. See Let clients repeat a section.

Add a table to a request

  1. Open Requests.
  2. Open the request you're building.
  3. Select Builder.
  4. Click Add a field and choose Table from the list of field types.

Add a column for each detail you want to collect. Each row is one entry your client fills in.

Choose what each column collects

Each column can be a different type, so one table can gather text, numbers, dates, currency, countries, dropdowns and file uploads side by side. New columns start as single line text. To change one:

  1. Click the column's header, then click the dots to open its menu.
  2. Choose Change column type.
  3. Pick the type you want.
  4. For a country, currency or phone column, you can choose a default in Default Country, Default Currency or Default Country Code.
  5. Confirm.
A table column's header selected, with its dots menu open showing Change column type, Require column, Lock column and Delete column

Each cell in the column starts on the default you set, and your client can change it in any cell. A country column gives clients a searchable list of countries with flags.

For the full list of types and what each one collects, see Field types.

Make a column required

Open the column's menu and choose Require column to make clients fill it in. They have to complete every cell in every required column before they can submit the request. To make a column optional again, open the same menu and remove the requirement.

Lock a column so clients can only read it

Lock a column when clients should see a value but not change it, such as a reference number, a fixed rate, or an account name you've already filled in. Open the column's menu and choose Lock column. The column stays visible, with a padlock shown in its header, and clients can't change its cells. Choose Unlock column from the same menu to let them edit it again.

Let clients add their own rows

A new table already lets clients add their own rows, so they can enter as many entries as they have. If you want a fixed set of rows instead, select the table and turn off Allow additional rows in its options panel. Field options covers where those settings live.

Paste from a spreadsheet

Copy the cells from your source, then paste them into the table. To paste everything you copied, click a single starting cell first, and the data fills down and across from there. Select a range of cells before you paste, and only those cells are filled.

If you paste more rows than the table has, the extra rows are added only when the table lets clients add rows. If you paste more columns than it has, Content Snare asks you to confirm before adding them.

Clear a cell, or delete a row or column

To clear what's in some cells, select them and press Delete or Backspace. The cells empty and the row stays in place. To remove an entire row or column, use its menu and pick Delete row or Delete column. Both take out the row or column and everything in it. If you delete something by mistake, press Ctrl+Z right away to undo it.

To change the order of rows or columns, hover over the handle at the left of the row or the top of the column and drag it into place.

Keyboard shortcuts

Tables use the same keyboard shortcuts as a spreadsheet for moving between cells, selecting, copying and pasting. For the full list, see Keyboard shortcuts.