Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
6 years ago

Showing child record ID from one table on a child record from another table

Let's assume I have a new project form (Parent).  For that new project we develop policies and procedures (child record 1) and send communications about the new project (child record 2).  Not every project needs both policies and a communication.  How can I show the record ID for child record 1 on the form for child record 2, but only if there is a child record 1 for the parent?

------------------------------
Michael Sargent
------------------------------
Formulas and functions
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    I'm not sure why you would want to show the Record ID#, but you can make a summary field on the Parent for the Maximum Record ID# of the Children where the type of child is "Policy & Procedure".

    Then that will either be a number or null (if there are none).  Then look that up down to all Children and show that value on the Child records and have a  form rule to only show that lookup field when the child record type is Communications.

    More likely what you want to do though is to have a hyperlink on the communications child record to display  the Policy Record.
    You can make a Formula Rich Text hyperlink like this:

    var text Words = "Link to Policy"
    var text URL = urlroot() & dbid() & "?a=dr&rid=" & [Record ID# of the policy record from that lookup];

    IF([Record ID# of the policy record from that lookup]>0,

    "<a href=" & $URL & ">" & $Words & "</a>")

    post back if you have syntax errors or questions


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