Show_if for EnumList not working

[Nicolas_Feldman]

Hi everyone,
Im trying to apply the next Show_if expression: [Check-In] = TODAY()

to an EnumList column with a SELECT formula for autopopulate.

The problem is when the show if expression is: [Check-In] = TODAY() It doesnt show the row, even though there is data for TODAY() in the origin table.

Any other combination with “<” or">", will show up all results, not just those that comply with Show_if.

Any ideas of what could I be doing wrong?

[Steve]

Does [Check-In] have a value, or is it blank?

Nicolas_Feldman:

even though there is data for TODAY() in the origin table

What has this to do with the Show? expression?

Nicolas_Feldman:

Any other combination with “<” or">", will show up all results, not just those that comply with Show_if.

I don’t understand this.

In what view isn’t the Show? expression producing the desired results?

[Nicolas_Feldman]

Hi Steve,

Im sorry, im working on my english.

[Check-in] is one of the columns in the “form view”, that is auto-populated when users types their name.

The auto-populated data for the row [ID Reserva] , which is the one that I´m trying to apply the Show_if comes from the next formula:
select(Reservas [Booking number], ([Cliente]=[_THISROW].[Nombre]))

So basically what Im trying to do here, is to ONLY show their “ID Reserva” IF their reservation check-in date is today. Otherwise users would be able to check-in in a different date than their reservation.

Screenshot of column to which I am trying to apply Show_if:

Screenshot of check-in column in the form view:

Thanks again for you all your help.

[Steve]

The Show? (Show_If) expressions affects the display of the column value in views, but it sounds to me like you want to hide it in a dropdown menu. Is that correct?

[Nicolas_Feldman]

Thanks Steve,
It could work both ways. I could hide completely the dropdown menu, if their checkin date is not today. Which I think is the option im trying to do.

Or What you just mentioned in your previous comment would also work. Refining the Select formula so that it only shows in the dropdown menu those with TODAY() Check-in using the AND() expression. Maybe that sound more logical…

What do you think?

[Steve]

Whatever the case, I don’t think you want to use Show? (Show_If). I like this option:

Nicolas_Feldman:

Refining the Select formula so that it only shows in the dropdown menu those with TODAY() Check-in using the AND() expression.

[Nicolas_Feldman · Accepted solution]

Its working! Thanks!

select(Reservas [Booking number], AND([Cliente]=[_THISROW].[Nombre],[Llegada]=Today()))

[Nicolas_Feldman]

I took it a bit further, so now it only shows the date range between Check-In and Check-out, users are able to check in any time in between those two dates.

select(Reservas [concatenate], and([_THISROW].[Nombre]=[Cliente],[Llegada]>=Today(),Today()<=[Salida]))

[Steve]

Now you’re just showing off…