hi amazinggg people,
i need to “connect” data between dasdhboard views…
i sent the image in the post, can you helpme with that?
thanks a lot
This is not possible with the built-in calendar view, but you could build a new table and view to replace the calendar.
I’ve started a sample app that contains a table with the virtual columns already setup.
https://www.appsheet.com/samples/Built-from-your-app-spec-?appGuidString=4fe2fb91-feca-4a6e-bee3-3ab092e96064
This is fairly complex, and not a standard technique for AppSheet.
There’s a lot left to be done, but if you’re willing to put in the work, you could replace the top calendar view with clickable date values in each column, so that those values can be passed between dashboard sections with actions.
Here’s a similar calendar hack I created for 1-hour time slots instead of dates.
[CRAZY CALENDAR HACK: Add Events Directly to a Timeslot, Pre-Fill Date/Time](https://community.appsheet.com/t/crazy-calendar-hack-add-events-directly-to-a-timeslot-pre-fill-date-time/34494) Tips & Tricks ?
Hold on to your apps, this one is gonna get a little weird. The default calendar view doesn’t provide a way to pick a timeslot when opening the form. I came up with a hack using a new table that contains only one sheet column for the hour, and 7 virtual columns for the day of the week. [Screen Shot 2020-11-16 at 3.14.35 PM] From there, I have a table view that shows related events to every Hour, pulling only events from This Week (Slice). Then, I created 7 Edit actions, …
2 Likes
Have you tried to link the tables with an ID COLUMN and then activate the “interactive mode” of the Dashboard view ? Usually it works!
Yes, this will provide some interaction, but only with existing events.
The built-in calendar view does not respond in any way when clicking a date with no events. Only the event itself is an interactive link.
So there would be no way to click a date with no events, and see the filter update (hiding all events). To get this effect, each date on the calendar needs an associated action that passes a value somewhere. That could be writing it back to a table and basing a filter on that, or maybe LINKTOFILTEREDVIEW().
@o_0_Gus
Why do you need to create multiple posts with the same subject?
https://community.appsheet.com/t/communication-between-dashboards-view/36379
1 Like
I deleted the duplicate post.
2 Likes