Assemble URL from Fields and special character

[Hiperf]

I need to assemble a URL and file name from a series of fields and "_".

https://mydomain.com/portal/interimsubmission/2024_3273_Lease.pdf

[@ISYear]_[ISPropertyID]_[@ISfiletype].pdf

[@field:ISURLFront] Text(255)

[@ISYear]  Number

[ISPropertyID] Integer

[@ISfiletype] Text(255)

[CoopperBackpack]

Hello @Hiperf,

Do you need to generate this URL in the table?

If so, you may use a Formula field with the following formula: 
 

'https://mydomain.com/portal/interimsubmission/' + CAST([@field:ISYear] as nvarchar) + '_' + CAST([@field:ISPropertyID] as nvarchar) + '_' + [@field:ISfiletype] + '.pdf'

Here is the formula result:

If you need to generate the URL on the DataPage, in general, this should work as well. Please provide more details about the use case if this formula doesn`t work. 

[Hiperf]

It worked perfectly! Coopper you're the best my friend, Thank You!

You always come through.