Create a script to modify a url

[beckham]

Hi Does anyone know how I can use the get url script to include a variable field data source.

example.: my url is "fmp://[email protected]/" I have a field with variable numeric data e.g: "20"

I would like the script to end up opening the url "fmp://[email protected]/20"

Any guidance on the best way to do this would be appreciated.

[comment]

The Open URL [] script step allows you to specify the URL as a calculation. Click the Specify… button and enter:

"fmp://[email protected]/" & YourTable::YourField

as the formula.

[beckham]

Thank you comment that is perfect..Happy new year!