Use a parameter in a forumala field to created unique URL for profile page

[Corpcatalog]

I want to create a unique profile page for each of my users 

Like

https://www.certlink.org/grower-profile.html?GrowerNumber=VOCI168

I created a forumale field to add the URL to the GrowerNumber field "VOCI168" 

 

My forumla looks like 

Formula:Edit

'https://www.certlink.org/grower-profile.html?GrowerNumber=[@InsertRecordGrowerNumber]'

 

This comes back as invalid formula, what am I doing wrong.

 

 

 

[ChrisCarlson]

Corpcatalog,

I am assuming that the GrowerNumber field is numeric. If so, you cannot intermix a text value and numeric value without first casting the numeric value as varchar. Casting as varchar converts the numeric value to text so that you do not receive invalid formula message.

This revised formula should work:

'https://www.certlink.org/grower-profile.html?GrowerNumber=' + Cast([@field:InsertRecordGrowerNumber] as varchar)

If your field is not numeric, you do not need to cast as varchar. Also make sure to place ' + at the correct position right after the equals sign.

'https://www.certlink.org/grower-profile.html?GrowerNumber=' + [@field:InsertRecordGrowerNumber]

You can find a list of functions for use in formulas here: https://howto.caspio.com/function-reference/

[Corpcatalog]

Thanks so much - life saver

The following code worked

 

'https://www.certlink.org/grower-profile.html?GrowerNumber=' + Cast([@field:GrowerNumber] as varchar)