Re class a field typer after script. (Web Location)

You can’t make a script field clickable (would be nice, it’s on my wish list*) however as a workaround what you can do is use the script field to set the value of a web site field using record.setFieldValue(field_id, value). Then when the script is run, it’ll update the web site field to be the new value which means you can then click on that field to open the link.

* I’d actually like a way of being able to define a custom icon for a script field and an action handler distinct from value. I think it’d be cool to have the ability to have the script field display one value but when you click it, it opens up a link or perhaps even runs a form script with a field context set. Doing all of that and getting it right is a lot of work and perhaps a little too powerful.

You’ll need to create a new web site field to put the data into. Then your script just needs to know what that field ID is and then set it:

form.runScriptNamed('vlookup');

var trello_cards_id = 'fld-a6346935a6af40d1833fad4f49958bca';
var tsm_rfs_id = 'fld-b0c9111f87064a23bde75c965374e97c';
var short_url_id = 'fld-7888517ad8204f5aa7a4bf926c92be15';
var website_id = 'fld-yourfieldhere';

var rfs = record.getFieldValue('fld-e13aa1493c6f4b919f30b27cd8bc8ae9');

var website = vlookup(rfs, trello_cards_id, tsm_rfs_id, short_url_id);
record.setFieldValue(website_id, website);
website;

Something like that should work, hopefully it makes sense. website_id is the new field you add to store the URL and make clickable, I put website into a variable so that I can use it to set and then use it as the return value for the script (kinda redundant but not harmful). You could probably hide the script field once it’s all working.

EDIT: Updated to remove smart quotes. If you have smart quotes, things won’t work the way you expect and you’ll get errors from JavaScript. If you’re working on iOS, make sure you use the quote button above the keyboard to ensure you don’t put in smart quotes accidentally. On the Mac, it usually doesn’t input smart quotes so you’re safe there.