Need URL formula link that displays a report from Table #1 while viewing records in Table #2
Is this possible?
Forum Discussion
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
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