Instructions: Create an online form with simple calculations

AFS forms make it possible to use field values in definable formulas and display the calculated results in the form again. In the example shown, predefined cost centers can be added together.

This tutorial describes in a few steps how you can integrate calculations into a form using AFORMSOLUTION 

Step by step instructions:

Step 1: Log in to the aforms designer:

Abbildung 1: Loginfenster WebAdmin

Figure 1: Login window aforms designer

Step 2: Select form:

 

Abbildung 2: Voransicht des Formulars öffnen

Figure 2: Opening the form preview

Abbildung 4: Klicken Sie unter „Extender“ auf „das Hinzufügen-Icon um eine Berechnung zu erstellen

Figure 3: Preview of the form without calculation

Now click on the "Calculation_travel_expenses_empty" form in the "Form name" column to edit it.

Step 3: Add calculation:

Under the "Extender" item, click on the add icon to add a calculation extender to the form.

Abbildung 4: Klicken Sie unter „Extender“ auf „das Hinzufügen-Icon um eine Berechnung zu erstellen

Figure 4: Under "Extender", click on "the Add icon to create a calculation

Step 4: Add formula:

 

Abbildung 5: Im Feld „Extender“ den entsprechenden Extender auswählen und unter „Variable“ diese hinzufügen

Figure 5: Select the corresponding extender in the "Extender" field and add it under "Variable"

Abbildung 6: Über den Formularbaum können einfach die richtigen Variablen gewählt werden

Figure 6: The right variables can be easily selected via the form tree

Now enter "=#V1+#V2+#V3" under "Formula" to add all three variables.

Abbildung 7: Im Feld „Formel“ wird die Formel hinterlegt und unter „Zielfeld“ das Ausgabefeld definiert

Figure 7: The formula is stored in the "Formula" field and the output field is defined under "Target field"

Now enter the output field under "Target field", also using the symbol to the right of the "Select from form tree" field. Now enter the "Total (sum)" field

.

Abbildung 8: Über den Formularbaum kann nun das Ausgabefeld der Berechnung gewählt werden

Figure 8: The output field of the calculation can now be selected via the form tree

 

Abbildung 9: Geben Sie hier die gewünschte Anzahl an Nachkommastellen an

Figure 9: Enter the desired number of decimal places here

Step 5: Apply/save changes:

Click on the Apply icon at the top until you are in the form view and then click on the Save icon to go to the form collection view.

Step 6: Synchronize changes on the server:

In the list of forms, click on the synchronization icon to apply the changes to the form.

Abbildung 10: Über „Abgleich“ werden Ihre Änderungen wirksam

Figure 10: Your changes take effect via "Adjust"

Step 7: Call up the finished form:

After this, you can call up the form that has now been saved with a calculation again via the preview icon and test the calculation you have just inserted.

Get AFS demo access now!

Request AFS access data without obligation and test it yourself.

Request access