Discussions

 View Only
  • 1.  Form url in notification email

     
    Posted 03-24-2017 14:13
    When I send certain email notifications I want to include a link to a specific form. How do I create the proper URL?


  • 2.  RE: Form url in notification email

    Posted 03-24-2017 14:19
    If you include &dfid=12 in the string, then it will use form ID 12


  • 3.  RE: Form url in notification email

     
    Posted 03-24-2017 14:23
    Thanks! I am new to URL creation in QB. What string do I start with?


  • 4.  RE: Form url in notification email

    Posted 03-24-2017 14:33
    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.


  • 5.  RE: Form url in notification email

    Posted 03-24-2017 14:49
    Correction. For missing [

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


  • 6.  RE: Form url in notification email

    Posted 03-24-2017 14:51
    Actually you never need to convert the [Record ID#] to text using ToText() or to numeric using ToNumber().


  • 7.  RE: Form url in notification email

     
    Posted 03-24-2017 14:52
    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 : )



  • 8.  RE: Form url in notification email

    Posted 03-24-2017 15:03
    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


  • 9.  RE: Form url in notification email

    Posted 03-24-2017 15:57
    This works for me in a Formula URL field.

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