Creating a Calculated Field in Popdock

‍

1. Select Connectors from the left navigation to open the Connectors page.

‍

‍

2. From your list of connectors, click the Edit icon to the right of the connector that you want to create your calculated field in. For this example, the Sample Data connector is being used.

‍

‍

‍

3. Under the Settings menu, select Lists.

‍

‍

4. You will want to select the list that you want to create a Calculated field on. To select that list, click the Edit icon to the right of the list. For this example, the Customers list is being used.

‍

‍

‍

5. From the Settings menu, select Fields.

‍

‍

‍

6. Select Show on the right side of the Calculated fields section.

‍

‍

‍

7. To create a new calculated field, select Click here to add a calculated field.

‍

‍

8. Use the Name field to give your calculated field a name. Then press Tab.

‍

‍

9. Use the available fields to create the formula for your calculated field. For guidance on creating C# formulas, visit the Popdock Guide for a Calculated Field.

• Field type – Use the available dropdown to select the field type for your formula.
• Field language – Use this dropdown to select the language of your formula. You can use Popdock Script, C#, or SQL (where applicable).
• Add field – Use this dropdown to select fields from your list to be used within the formula. The fields will be inserted into the formula in the field language selected.
• Add function – Popdock provides a variety of prebuilt functions. You can use these functions instead of typing all of your formula.
• Formula – This is where you will comprise your calculated field.
• Validate – Once you have created your formula, you can select Validate to confirm it is a valid formula.

‍

In this example, the Field type is Currency and the Field language is Popdock Script. For the formula, Total costs is being subtracted from Total sales to yield a Net Profit.

‍

‍

10. With your formula in place and validated, your calculated field is now available as a field to be used within your list.

‍

‍

Questions on creating a calculated field? Contact support@eonesolutions.com.