In this lesson, we'll dive into an exciting example that demonstrates the use of text-based parameters. We'll create a text-based parameter that allows users to input an address and generates a Google Maps link based on the entered address.

Creating a text-based parameter is simple and follows a similar process as other parameters. In this example, we'll create a parameter called address. The configuration for this parameter is as follows:

The data type for the address parameter is text, and we've set it to accept any value. You could also set the text parameter to have a list of values, such as countries, cities, departments, or sales managers. You can then assign this list to a dropdown control.

When the user enters an address, we can use the entered text value to generate a Google Maps link. Keep in mind that you can enter any text that Google Maps can interpret, such as a famous landmark or a specific street address.

Note: The entered address will not be finalized until you click outside of the input box.

To create a link, you can use the HYPERLINK() function along with the CONCAT() function. In this example, we use the following formula:

This formula concatenates "https://maps.google.com?q=" with the user-provided address and sets the title as "Google Maps Link."

Example use case: Some users may want to create links to specific marketing campaigns by entering the campaign name. If you know your URL structure for the tool you use to manage campaigns, you can construct a link like the one demonstrated in this lesson.