Discussions

Expand all | Collapse all

Copy rich text formula (url) to another table

  • 1.  Copy rich text formula (url) to another table

    Posted 16 days ago
    Hi all,

    on my referee checking table, I have formula rich-text field that links to the attachment field

    "<a href='"& URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e90/v0' target='_blank' >" & [Referee checking form] & "</a>"

    I need to include this field to another table, what is the best practice to achieve this?. Can you please give step by step instruction for the solution?

    Many thanks

    ------------------------------
    Syaeful Bahri
    ------------------------------


  • 2.  RE: Copy rich text formula (url) to another table

    Posted 16 days ago
    If he other table is a child, then just look it up as a lookup field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Copy rich text formula (url) to another table

    Posted 16 days ago
    Hi Mark, thank you for your answer

    How about to have the link to another table?, it is possible to achieve this with the formula?

    Thanks Mark

    ------------------------------
    Syaeful Bahri
    ------------------------------



  • 4.  RE: Copy rich text formula (url) to another table

    Posted 16 days ago
    Do you mean as a static link to a particular file?  How would the other record know which file you want?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Copy rich text formula (url) to another table

    Posted 13 days ago
    Edited by Syaeful Bahri 13 days ago
    Hi Mark,

    Thank you for your response, it's lead me to another trial and error. Apparently, I found your old discussion and adjust the formula. Rather than rich text formula, I'm changing it to formula URL

    URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e138/v0'>" & [referee checking]

    Then I create URL field on destination table and using automation with some certain conditions to copy the field record from original table to destination table (url field)

    It's good to go through old discussion and found some interesting discussion that can be the answer

    Kind regards

    ------------------------------
    Syaeful Bahri
    ------------------------------