Generating question link in custom column

Hi all!

I've been working on creating some links that are used in our support ticketing system that help make viewing data about customers easier. Essentially, my process has been to create a Question in metabase, copy the resulting query hash, decode it, and replace the filter with a placeholder variable. Then, when the URL is generated, it puts the appropriate filter in place and re-encodes the query. This works great.

What I'd like to do now is have a custom column in this Question that links to another question. Conceptually, this isn't hard. The second question filters based on an ID that is a column of the first question. In theory, I could de-encode the query hash, drop the column reference into the appropriate place in the query and then re-encode it again. However, I don't see any kind of functions to encode/decode. I also didn't see any way to accomplish this outside of the low-level method I'm describing.

Is there a way to accomplish this? Or is there another approach that's easier?


Hi @joel-doppler
I think you're looking for Click Behaviors:
There's currently no way of controlling encoding: - upvote by clicking :+1: on the first post

1 Like

Ah, okay! I created a new Dashboard, added the initial question to it with a starting filter and then changed the click behavior to load a new question. That accomplishes what I was after! Thanks for the help!