Forum Discussion
There a couple options, I would try the following:
var text urlRoot = URLRoot() & "db/" & target dbid & "?a=dr&rid=";
If( Part(query response, 1, ";") != "", <a href='" & $urlRoot & Trim(Part(query,1,";")) & "'>" & Trim(Part(query,1,";")) & "</a>
If( Part(query response, 2, ";") != "", <a href='" & $urlRoot & Trim(Part(query,2,";")) & "'>" & Trim(Part(query,2,";")) & "</a>
If( Part(query response, 3, ";") != "", <a href='" & $urlRoot & Trim(Part(query,3,";")) & "'>" & Trim(Part(query,3,";")) & "</a>
If( Part(query response, 4, ";") != "", <a href='" & $urlRoot & Trim(Part(query,4,";")) & "'>" & Trim(Part(query,4,";")) & "</a>
It's not perfect but the part allows you to index each response and then make a hyperlink to each one if its there.
------------------------------
Chayce Duncan
------------------------------
- ChayceDuncan2 years agoQrew Captain
You could also create a link field in table you're querying and then return that value in the getFieldValues. This would mean making a formula-text field in the phone numbers table and formatting it how you want, and then returning that field instead of '3' like you're currently doing.
------------------------------
Chayce Duncan
------------------------------