Forum Discussion

BrianBrown's avatar
BrianBrown
Qrew Trainee
5 years ago

Multiple Form

Forgive me if this doesn't make sense, I'm taking over from someone else and have no idea what I'm doing.

We have multiple forms. Most go to the Main "Entry" form. On the Override role settings by report, I have our "Templatized" form opening the correct "Templatized" report.

However when I send an email notification to link to the report, I'm using. %recLink% But that takes me to the Main "Entry" Report. I noticed if I stick &rl=kjd at the end of the URL, it pulls up the correct "Templatized" report.

So my question is how to I create a link to goto the "Templatized" report.

Thank you very much!

------------------------------
Brian Brown
------------------------------
Forms
NotificationsEmail
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    The parameter &dfid=10 in a URL will force the link to use form ID 10, for example.

    So you can make you own URL formula link in the format

    URLRoot() & "db/" & dbid() & "?a=dr&dfid=10&rid=" & [Record ID#]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • BrianBrown's avatar
      BrianBrown
      Qrew Trainee
      5 years ago
      Do I add it to my email custom message just like that or do I need to create <a href>?

      ------------------------------
      Brian Brown
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        If it's for internal use and you don't care much about the appearance, then you can just use the URL field.

        Else use an <a href syntax.

        If you are sending and you Really care about the look and need it to render as a button to click as opposed to just a hyperlink, there is a bunch of code for that.


        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I should have also mentioned there is an option to specify a form to use on the email Notification setup.  Did you try setting that?  I did not test if it works for the %recLink%,  only when the form is embedded in the record in the email.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • BrianBrown's avatar
      BrianBrown
      Qrew Trainee
      5 years ago
      Yes I had it pointed at the correct form in the email notification setup.

      ------------------------------
      Brian Brown
      ------------------------------
      • BrianBrown's avatar
        BrianBrown
        Qrew Trainee
        5 years ago
        Clearly I did this is wrong. <a href="URLRoot() & 'db/' & dbid() & '?a=dr&dfid=19&rid=' & [Record ID#]">New Link</a>

        ------------------------------
        Brian Brown
        ------------------------------