Passing values to different urls on drilldown

[jaimerader]

I have a table that i want to pass values to a url on drilldown. Problem i'm encountering is that the values need to link out to different URLs. Table column contains:

PP12345
AA12345
AA87654
PP87654
AA00098
PP00098

When passing the value the url would need to go to either http://blah/product/PP12345 or http://blah/application/AA12345 depending on the which type it is. Is there a way to make the url dynamic based on the column value??

[martin_mueller · Accepted solution]

Use eval to produce a hidden field called _type with either application or product in it and use http://blah/$row._type$/$row.foo$ in your drilldown.