Get THIS column name

I need get the column name value (in text) for something like:

SELECT(Opciones[Opcion],[Pregunta]=[THIS_COLUMN_NAME])

Is there any way to do it? I want this because the column name is the same as the value i have stored in the column “Pregunta”. I don’t know if there is another way to do it, i’m very new in AppSheet. Thanks in advance

I’m afraid you can’t read the column name and then use it with your formula. Though it sounds that you trying to use something like…
SELECT(Opciones[Opcion],[Pregunta]=[_THISROW].[ColumnName])

2 Likes

Thanks for the response, Aleksi.
Actually i’m using this: SELECT(Preguntas[Texto],[Pregunta]=“S1-P1”) (where S1-P1 is my column name) and it’s just working fine, but i just wanna know if there is a way to not to hardcode the ColumnName part :frowning:

Sorry for my English, but thanks for the response

1 Like

Try with…
SELECT(Preguntas[Texto],[Pregunta]=[_THISROW].[S1-P1])

3 Likes