Skip to main content
Question

Using a button to filter related records in a table

  • November 25, 2020
  • 0 replies
  • 17 views
Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Registered
  • November 25, 2020
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/
------------------------------
Terms & ConditionsAccessibility statement