Hello, I have two tables: rooms and reservations.
I have created a calendar view from the reservations table and an action in the rooms table that shows me the calendar view, but it shows me the reservations of all the rooms in the calendar.
I would need to create an action from the rooms table that only shows me, on the calendar, the reservations for that room.
Thanks for your help.
You could use LINKTOFILTEREDVIEWS() action in the Rooms table with an expression something like
LINKTOFILTEREDVIEW(“Calendar View”, [Room Number Column in Calendar Table]=[_THISROW].[Room Number in Room Table])
https://help.appsheet.com/en/articles/1023058-app-column-type-deep-link
The suggested approach is tested for normal Calendar view and not calendar created from Google calendar.
Please try with removing Ocupado from Ocupado[Casa]
something like
[Casa]=[_THISROW].[vivid]
Many thanks.
Thanks boys,
I read it and understand but not find where to implement this filter. Could you @Gambeta send and image how to use it and where?
Thanks Sara, I’m really interested in Calendars, I’m Working so much with that.
Hello Sara, I am going to explain it to you simplified.
I have two tables: ‘Viviendas’ (homes) and ‘Ocupado’ (reservations)
The ‘Ocupado’ table has a calendar view and shows all reservations for all houses.
But I wanted to create an action button in the detail view of ‘Viviendas’ that would show me the calendar but only with the reservations for that home.
What did I do? Create a new action call ‘Calendario’ on the ‘Viviendas’ table that calls the calendar view of the ‘Ocupado’ table:
App: go to another view within this app
and for that, the Target is:
LINKTOFILTEREDVIEW(“Reservado”,[Casa]=[_THISROW].[vivId])
where ‘Reservado’ is the ‘Ocupado’ calendar view, ‘Casa’ is the reference to ‘Vivienda’ table and vivID the key in the ‘Vivienda’ table.
I hope I’ve helped. All the best.
Yes thanks so much