Form url in notification email
When I send certain email notifications I want to include a link to a specific form. How do I create the proper URL?
Forum Discussion
- If you include &dfid=12 in the string, then it will use form ID 12
- 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#])- Actually you never need to convert the [Record ID#] to text using ToText() or to numeric using ToNumber().
- 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
