Form url in notification email

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
When I send certain email notifications I want to include a link to a specific form. How do I create the proper URL?
Photo of Val

Val

  • 40 Points

Posted 2 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
If you include &dfid=12 in the string, then it will use form ID 12
Photo of Val

Val

  • 40 Points
Thanks! I am new to URL creation in QB. What string do I start with?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
Correction. For missing [

Urlroot() & "db" &dbid() & "a=dr&dfid=12&rid=" & totext([Record ID#])
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,884 Points 20k badge 2x thumb
Actually you never need to convert the [Record ID#] to text using ToText() or to numeric using ToNumber().
Photo of Val

Val

  • 40 Points
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 : )

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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"
(Edited)