Skip to main content
Question

Form url in notification email

  • March 24, 2017
  • 0 replies
  • 60 views
When I send certain email notifications I want to include a link to a specific form. How do I create the proper URL?
      This topic has been closed for replies.

      If you include &dfid=12 in the string, then it will use form ID 12
      • ValVal
      • Author
      • Registered
      • March 24, 2017
      Thanks! I am new to URL creation in QB. What string do I start with?
      The low tech solution is to create a field called link to form with the formula

      Urlroot() & "db" &dbid() & "a=dr&dfid=12&rid=" & totext(Record ID#])

      And include that field in your notification.
      Correction. For missing [

      Urlroot() & "db" &dbid() & "a=dr&dfid=12&rid=" & totext([Record ID#])
      • ValVal
      • Author
      • Registered
      • March 24, 2017
      I really appreciate the help! A couple things I need to admit:

      1. I'd like to write a URL to include in a notification that gets the user to the correct form -- I've done this in the past (when I used QB at a previous employer) but I don't recall how to write the URL. I found a bunch of existing questions in this knowlege base, but sad to say that part of my problem is that I don't understand what to do with & and () and " " in the example formulas...insert something, use exactly as stated, etc.

      2. Is there an online user guide for Quickbase? I was a super user of sorts but it's been 5 years since that time and I am terribly rusty. I keep wishing for a reference guide that I could use to look up this stuff myself rather than ask questions in the forum : )

      Other than the 12, my formula should work as is.

      There is an app I put in the exchange called. URL formulas buttons for Dummies. Search on Dummies. That's one place to start
      This works for me in a Formula URL field.

      URLRoot() & "db/" & Dbid() & "?a=dr&rid="&[Record ID#] & "&dfid=12
      Terms & ConditionsAccessibility statement