Skip to main content
Question

Using GetFieldValues() to create a link

  • October 13, 2023
  • 0 replies
  • 137 views

Hello,

I'm attempting to create a field within my records that shows POTENTIAL duplicates. Some of our records are older and we don't necessarily want to completely merge records, so in order to help combat this, I want a list of the record IDs that share the same Phone Number. We can accomplish this via this formula:
ToText(
    GetFieldValues(
    GetRecords("{'17'.EX.'"&[OFFICE_PHONE_NO]&"'}"),3))

We then want to take the record IDs that generates and create a link to each record ID, and this part has me a bit stumped. Has anyone had any experience with something similar?



------------------------------
Marc Ferro
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • October 13, 2023

    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
    ------------------------------
    Terms & ConditionsAccessibility statement