Use custom column in another custom column

App Building
1

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.

2

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?

3

Yes, that's probably the preferred method. Do you have an example?

4

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:

963×531 48.6 KB

Let me know if that helps clear things up a bit!