Skip to main content

Make a file

Choose the fields and format your receiving system expects.

Start a new file

Open the flow, go to the We send step, and select Make another file (or Make a file when the flow has none yet). It opens ready: a CSV file with every value we read.

The Make another file panel opens, with a Name, a File type and every value we read, ticked.

Name it, choose the file type and the values

The Name starts as the flow's name with CSV after it; change it if you like, up to 120 characters. Then choose the File type: CSV, Excel, JSON, XML, PDF, Text or Fixed-width text. See Files we make.

Untick any value you don't need. The count beside In the file says how many stay ticked. Values from the flow's first table become the file's table columns.

The panel shows what goes in the file.

Create it

Select Create. The new file opens on We send, set to Download only. Its columns are one press away, under Change the columns.

The file is saved, and you can edit its rows.

If this fails

If the panel says "Give this file a name." or "Tick at least one value.", do that and select Create again. Other messages say what the server refused.

Choose where it goes and the other options

Under Send to, press Change to choose a destination you made before, or New destination… to make one now. See Send files to a destination.

Under More options: file type, when to send, separator, lookups:

  • CSV has a Separator: comma, semicolon or tab.
  • PDF and Text have a Title, Text at the top and Text at the bottom. For PDF you can add a logo.
  • To send only some documents, set Send when to Only when, then choose a field, a condition and a value.

The file knows where it goes and when.

Shape the rows

On We send, press Change the columns to open the column editor, and Done to close it. To rename the file, press the pencil beside its name (Rename this file). Each row has these parts:

  • Column name. The column heading or the name the receiving system expects.
  • Value. A field of the document, or Fixed value with the text you type.
  • Lookups, under More options: file type, when to send, separator, lookups. Optional. Replaces the value through a lookup. Then choose whether to keep the value or leave it blank if it is not in the lookup. See Lookups.
  • Width. Only for fixed-width text.

Use Up and Down to change the order, Remove to drop a row and Add a column for a new one. Changes save as you make them; select Use these changes to put them in use.

The file holds exactly the rows your receiving system expects, in the order it expects.

Preview it

If the flow has a document, What the file looks like shows the file made from the latest document, with your changes.

You see the file your receiving system would get. Values that a lookup did not find are listed under it.

Then use your changes

Files take part in the flow's versions. Once the setup is saved, a change to a file reaches new sends after you use your changes. See Use changes and restore earlier versions.