Forum Discussion

DanMcLaughlin's avatar
DanMcLaughlin
Qrew Trainee
5 years ago

Using a button to filter related records in a table

I'm trying to setup a button that will show that status change history for a particular project. I have the log files in a child table.


If( [Status]="Not Started",
"<a class=\"Vibrant Snowy\" style=\"width:150px; text-align: center;\"href=" &URLRoot()&"db/"&[_DBID_STATUS_LOGS]&"?a=td"
&"&_fid_7="&[Record ID#]
&">"&"NOT STARTED"
&"</a>",

The resulting  url looks like this:  https://scenicsolutionsllc.quickbase.com/db/bqz7i8a5b?a=td&_fid_7=1932



The bold statement is where I run into trouble. I just get the unfiltered table

Any help on syntax here?


------------------------------
Dan McLaughlin
------------------------------
APIs and custom code
Buttons
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Ok, so "a=td" will give you the default Table Display for the given DBID and you can't really add any filters to that URL. Instead of directing the user to another table though, is there a reason you don't want to do an embedded report directly on the parent record? If you don't want to show them all the time, you can always add a Tab to your form and have them on the tab.


    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------