I'm trying to leverage the data of one custom column in another custom column and I cannot seem to figure out how to do that.
Hi @tlawrence 👋 welcome to the forum!
As you observed, there's currently no way to reference a custom column value within another custom column. As an alternative, you could consider using a JS transformer to append these custom columns to the underlying data, then use the JS transformer as the table's data source.
Would something like that suit your use case?
Yes, that's probably the preferred method. Do you have an example?
Absolutely! Here's an example JS transformer where we add the "full_name" key/column to a list of users that were returned from a PostgreSQL query:
Let me know if that helps clear things up a bit!