How to show column headers in 1 column based on the values in those columns for each record?

Hi all,

We have a table with records per customer, with multiple variables and their scores coming from typeform (auto-sync).

The goal is to get out the 3 highest scoring variables and send the label of those variables to the customer. I can’t seem to find a way to get inside 3 fields the 3 column-names with the highest value of that record.

Another solution I was thinking of, was when the auto-sync worked, to store the variables in different rows in another table but also with this I see no reason than to get the max 3 variables out of this table linked to the original one.

Help would be much appreciated, thanks!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.