Forum Discussion

ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago

Need Formula Field to always navigate to report of child records

See attached Excel file for explanation of what I am looking for but in short, I am looking to replace a report link field with a formula field that will always take me to the report of child records ...
Formulas and functions
ChrisSwirtz2's avatar
ChrisSwirtz2
Qrew Cadet
6 years ago
so if the DBID of the child record is bp9s6xp7v how would that get entered into this formula? Every way I add it I get a syntax error, but I'm sure I'm doing it wrong.


------------------------------
Chris Swirtz
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
look at the advance properties tab for the child table.  ASt the bottom it will give the table alias like

_DBID_CHILDREN

so you just put that in the square brackets like below including the leading underscore

[_DBID_CHILDREN]

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • ChrisSwirtz2's avatar
    ChrisSwirtz2
    Qrew Cadet
    6 years ago
    This worked perfectly, thank you!

    ------------------------------
    Chris Swirtz
    ------------------------------
    • ChrisSwirtz2's avatar
      ChrisSwirtz2
      Qrew Cadet
      6 years ago
      Mark,

      Is it safe to assume that this same style formula could be utilized to take a user to a specific form instead of a report?

      For instance, if a user is in the Workstation table and clicks  "Add Peripheral" it takes them to one form, but if they are in the Assessments table and click "Add Peripheral" it takes them to a different form?

      ------------------------------
      Chris Swirtz
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        OK, different question,  but there is a parameter in the API_GenAddRecordForm API to specify a form.

        you add &dfid=99 

        to specify say form # 99

        But let me go on record, that I really try to avoid having multiple forms as it always gets confusing on how when a user visits a record to have the system know what form to use.  I prefer form rules whenever possible. 


        ​

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