Note: In order to follow this tutorial you will need the Essentials add on

You might want to get values from the URL for example you might have a URL like this:

HTTP://www.example.com?myparameter=hello

And you might want to fill a field using the value of myparameter (in this case it would be “hello”)

To do so follow these steps:

1.- Select the field that you want to fill with this value and open the formula editor

2.- Click on “Add function”

3.- Select the function “GetParameter”

4.- Configure the function, this function just needs the name of the parameter that you want to use, in my previous example (HTTP://www.example.com?myparameter=hello) my parameter is called “myparameter” so I will use that

That’s it! Now the field that I selected will be automatically filled using the parameter from my URL.

Sometimes you will want to add conditions to your formulas, for example you might want to use different calculations depending on what options in your form are selected.

if(Condition)
  operation
else
  operation

Example:

The condition above will check the value of the dropdown, if the “Option 1” is selected the formula value will be 1, otherwise it will be 2.

The else section is optional, if you want you can create many conditions like this:

In the example above the formula value will be 1 if option 2 is selected, 2 if option 2 is selected or 3 if option 3 is selected.

You can also do arithmetical operations inside the conditions for more complex calculations: