Can I assemble a link's URL based on other fields' value?

S

Scott L. Heim [MSFT]

Hi Alan,

Here are the steps I followed in a sample:

- Create a new, blank InfoPath form
- Add 3 text boxes: field1, field2 and field3
- Right-click on field3 and choose Properties
- Click the Insert Formula button next to Default Value
- Click Insert Function
- Select "concat" and click OK
- Remove all options after concat so you are left with just: concat(
- Add the following after the parenthesis: "http://www."
- Enter a comma (,)
- Click the Insert Field or Group button and select field1
- Enter a comma (,)
- Add the following text: ".com/"
- Enter a comma (,)
- Click the Insert Field or Group button and select field2
- Add a closing parenthesis
- The formula should now appear as: concat("http://www.", field1, ".com/",
field2)
- Click OK twice to get you back to Design View
- Right-click on field3 and choose "Change To" and then select Hyperlink
- Preview the form and enter: microsoft in field1 and enter: infopath in
field2 - the Hyperlink (field3) should now display:
http://www.microsoft.com/infopath

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top