Column with ref to table not filtering correctly

[James_McFarlane]

Hi Guys,

I have a column called time slots that is references to table Horas_TM. The VALID_IF of this column has the following expression:

ORDERBY(SELECT(Horas_TM[ID],[Bloque]= [_THISROW].[BloqueHorario]),"Hora TM")

The column BloqueHorario is a virtual column with this expression:

[Zona_ID].[BloqueHorarioID]

I am getting the following data back that is not filtered.

[James_McFarlane]

Hi @Steve and @Aleksi,

Any pointers? I have ketp try to find a solution, one that did return the correct data was when I change the [_THISROW].[BloqueHorario]) to the corresponding value.

ORDERBY(SELECT(Horas_TM[ID],[Bloque]=2,“Hora TM”)

[Steve]

This:

ORDERBY(SELECT(Horas_TM[ID],[Bloque]= [_THISROW].[BloqueHorario]),"Hora TM")

Should be:

ORDERBY(SELECT(Horas_TM[ID],[Bloque]= [_THISROW].[BloqueHorario]),[Hora TM])

[James_McFarlane]

Hi @Steve

I did the change but it still not working. I took the order by out of the expression and still no luck.

[Steve]

Please provide a screenshot of the configuration of the column that generates this dropdown:

Please also provide a screenshot of the Valid If expression for that column.

[James_McFarlane]

Field

Valid_IF

Virtual column BloqueHorario

[Steve]

What result do you get from the Test button in Expression Assistant for that SELECT() expresion?

[James_McFarlane]

With this expression

ORDERBY(SELECT(Horas_TM[ID],[Bloque]= [_THISROW].[BloqueHorario]),[Hora TM])

[James_McFarlane]

with the following

the test brings back the following data:

[Steve]

What would you infer from that?

[James_McFarlane]

That the [_ThisRow].[BloqueHorario] is not returning the a correct value? but I have placed the following formula in the Display section:

[Steve]

I would guess your data is corrupted somehow. I think someone needs to take a more direct look at your app, so I’m going to refer you to support@appsheet.com for more help. Sorry!

[James_McFarlane]

Thanks for your help!!! Have a great day.

[James_McFarlane]

Thanks @Steve found the culprit it whats an issue in the table duplicate IDs.