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?
Solved! Go to Solution.
Its working! Thanks!
select(Reservas [Booking number], AND([Cliente]=[_THISROW].[Nombre],[Llegada]=Today()))
Does [Check-In]
have a value, or is it blank?
What has this to do with the Show? expression?
I donโt understand this.
In what view isnโt the Show? expression producing the desired results?
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.
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?
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?
Whatever the case, I donโt think you want to use Show? (Show_If). I like this option:
Its working! Thanks!
select(Reservas [Booking number], AND([Cliente]=[_THISROW].[Nombre],[Llegada]=Today()))
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]))
Now youโre just showing offโฆ
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |