Need URL formula link that displays a report from Table #1 while viewing records in Table #2
Is this possible?
Forum Discussion
Well then, thats pretty easy.
Low tech:
1. Run the report and copy the URL to your clipboard
2. Create a URL formula field called "Expenses for Burn Rate" and paste in the URL in quotes.
e.g. "https://mycompany.quickbase.com/db/xxxxxxx?a=q&qid=23";
but the "right way" is to do it like this.
urlroot() & "db/" & [_DBID_EXPENSES] & "?a=q&qid=23"
The stuff in the [ ] comes from the Advanced Properties of your Expenses table. Doing it the right way will keep it from breaking if you ever make a copy of the app.
Once its working Give the URL formula field a label (half way down the field properties)
Low tech:
1. Run the report and copy the URL to your clipboard
2. Create a URL formula field called "Expenses for Burn Rate" and paste in the URL in quotes.
e.g. "https://mycompany.quickbase.com/db/xxxxxxx?a=q&qid=23";
but the "right way" is to do it like this.
urlroot() & "db/" & [_DBID_EXPENSES] & "?a=q&qid=23"
The stuff in the [ ] comes from the Advanced Properties of your Expenses table. Doing it the right way will keep it from breaking if you ever make a copy of the app.
Once its working Give the URL formula field a label (half way down the field properties)