Collect Forms – Formula Snippets

<< Click to Display Table of Contents >>

Navigation:  Collect > Collect Enterprise > Template Designer Page > Formula Builder >

Collect Forms – Formula Snippets

Building complex formulas can be time-consuming. Users can save a formula to use in another field or on other forms through the “Formula Snippet” feature. The following steps demonstrate how to use this feature.

 

1.On the Template Designer page, click on Custom Field in the Form Setup window to create a new field on the form.

Col-Fml_Snippet_1

2.In the Edit Field window, enter the desired information for the new field. Select Formula from the Type drop-down menu. Click on the Formula button in the Attributes tab to open the Formula Builder window.

Col-Fml_Snippet_2

3.Build the formula in the Formula Editing window. Hit “enter” after finishing the formula. The formula will display in the Formula Structure window.

Col-Fml_Snippet_3

4.Click on the topmost function in the Formula Structure window. The Formula Chooser window will populate in the right pane of the Formula Builder window. Select the Snippets tab.

Col-Fml_Snippet_4

5.Click the Add Snippet button.

Col-Fml_Snippet_Add

6.Enter a name for the snippet in the Snippet Name dialog. Click the OK button.

Col-Fml_Snippet_Name

7.The new snippet will appear on the Snippets tab.

Col-Fml_Snippet_Saved

8.The next time this same formula is needed in another field, repeat Steps 1 and 2 above to open the Formula Builder window.

Col-Fml_Snippet_8

9.Click on the “+” sign under Add Outer Function in the Formula Structure window.

Col-Fml_Snippet_9

10.The Formula Chooser window will populate in the right pane of the Formula Builder window. Select the Snippets tab.

Col-Fml_Snippet_10

11.The previously saved snippet(s) will be shown. Click on the desired snippet title and the formula will appear in both the Formula Editing window and the Formula Structure window.

Col-Fml_Snippet_11

12.Click OK and then Save. The field is ready to be used.