Column with ref to table not filtering correctly

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.

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”)

This:

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

Should be:

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

Hi @Steve

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

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

image

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

Field

Valid_IF
Screen Shot 2020-07-23 at 5.11.11 PM

Virtual column BloqueHorario
Screen Shot 2020-07-23 at 5.11.49 PM

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

With this expression

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

with the following
Screen Shot 2020-07-23 at 8.58.32 PM

the test brings back the following data:

What would you infer from that?

That the [_ThisRow].[BloqueHorario] is not returning the a correct value? but I have placed the following formula in the Display section:
Screen Shot 2020-07-23 at 9.38.02 PM

Screen Shot 2020-07-23 at 9.38.50 PM

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! :frowning:

3 Likes

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

1 Like

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

3 Likes