Need URL formula link that displays a report from Table #1 while viewing records in Table #2

Yes, absolutely possible.  If you can describe your actual tables and if they are related or how the URL button would know what report  and how to filter the results.  It may also be possible to simply embed a table of results on the Table 2 record using a "Report Link field".

The tables in question are not related.  As long as it can display the proper report, I don't need it to be further filtered.  In other words, the report itself is already filtered.  The report I want to link to is called "Expenses for Burn Rate" in the Expense table and is report ID # 26 in that table.   Do you need any other info?

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)

worked perfectly.  Thanks.  By the way, what "language" is the URL formula? Is that Javascript?

No, that is not Javascript.  You don't need to be a real programmer to do some simple URL formula buttons.  I have an example in the "Exchange" which gives some example of how to do URL formula buttons. Try searching on "Dummies" and it should come up   "URL formuals for Dummies".  Its meant to explain them in easy to understand terms.

Ok.  Thanks.  I'll look into that.

Hi Mark, thank you for the guidance. With your advice I managed to display a link to a report, but is there a way to display a prefiltered report? I have two tables: Project and Projects tasks. On the Project side I would like to have a link to all currents tasks for this project. I need to make sure that Project code from the Project table is equal to the Related project code from Tasks table.

Update: I'm using the formula URL
URLRoot() & "db/" & [_DBID_RISK_MITIGATION_STEPS] & "?a=q&qid=10" & "&query={'28'.TV.'[Project Code]'}"

And the URL I get is
https://mycompany.quickbase.com/db/bj6z1bijy?a=q&qid=10&query={%2728%27.TV.%27[Project%20Code]%27}

This link leads to the report I need, but instead of searching for the project code value, it thinks that [Project Code] is the needed value. It doesn't recognize it as a field, just as symbols. Hope that make sense...

Thank you in advance,
Polina

Remove the %20 and leave it as just a space

Mark thanks for your great community support.  How can the URL specific report link above be adjusted to show a report in another related child table filtered to the Related Project.  Projects is the mother table and Sites is the child table w/ Project ID as the key text field in Projects and Related Project in the Sites child table = to Project ID of course

Robert,
Are you looking to create a report link field to display an embedded report on a form?