Feature: Join arrays together with |

Use the new operator | to join together arrays with other arrays and values.

We have a brand new operator for joining together arrays with other arrays and values: the array concatenation operator |. It does for arrays what the text concatenation operator & does for text.

These formulas all return the array { 1, 2, 3, 4 }{ 1; 2; 3; 4 }:

{ 1, 2 } | { 3, 4 }{ 1; 2 } | { 3; 4 }
{ 1, 2, 3 } | 4{ 1; 2; 3 } | 4
1 | { 2, 3, 4 }1 | { 2; 3; 4 }
1 | { 2, 3 } | 41 | { 2; 3 } | 4

Let’s say that you have an email report button (which sends an email with field values when pressed) and a download report button (which downloads a file containing field values when pressed). You set the IncludedFields property of the email report button to a complicated formula which includes all the fields you want to email your user.

Now, what if you want the download report button to include the same fields, but also include another one, Field50? Do you need to copy the original formula for the email report button and change it for the download report button?

No, you can simply reference the original array from the download report button formula and use the | operator to add Field50:

EmailReportButton1.IncludedFields | Field50EmailReportButton1,IncludedFields | Field50
« Tip: Debug arrays by inspecting their elements Feature: Include array elements conditionally with IF »