This article provides you with an example of how to add a calculated field to your list. It uses a scenario where you are taking donations for a charity event that benefits the Girl Scouts of America and the Boy Scouts of America. All proceeds will be divided evenly between the two organizations. The event ran for the month of February, all transactions were processed in Stripe, and they were given the description of “50/50 Charity Donation”.
How to add calculated fields to a list
1. Select Connectors from the left navigation to open the Connectors page.
2. Select the Edit icon next to the connector that contains the list you want to add the calculated field to.
3. Under Settings, select Lists.
4. Select the Edit icon next to the list that you want to add the calculated field to. In this example, you will be using the Payments list.
5. Select Fields from the left navigation.
6. Here you will want to hide the fields section and show the calculated fields section. Select Add calculated field.
7. The Edit calculated field page will appear. Here you will want to enter a Name, select the Field type, and enter the Formula for the calculation. Here is a Guide for help creating your formula.
For this example, you will set the Field type to Currency. The Formula is taking the Amount field and dividing it by 2 for the calculation. The correct syntax for identifying a column in a list is to surround the column name with braces, like so: {Amount}.
You can also use the Add field dropdown to choose a field from the list. When using C# operators, you will add the divided by 2 which is “/2”. All together it is {Amount}/2.
8. With your calculated field created, you can select Go back to List to return to the previous page.
9. Repeat steps 6 and 7 if you have more than one calculated field you would like to add. For this example, a second calculation is added which is identical, but named different.
10. After adding your calculated field(s), you can select which fields you would like to show by default or add them manually on the list later. In this example, only these fields will show by default: Created Date, Description, Amount, Status, and then the 2 calculated fields that were named Girl Scouts of America and Boy Scouts of America.
11. After you have selected your default fields, you can add the list to a tab. Select Add new tab and then complete the dropdowns for the list you added the calculated fields to. Then select Add.
If your data from your list and the formula for the calculated field are correct and working, then you should see the new calculated field(s) with the correct data showing.
Questions on adding a calculated field to your lists? Email support at support@eonesolutions.com