When I click on a booking/scheduled event in the month view of the calendar. The day view opens and the title of the booking is shown within a box. To see more detail about the booking you have to click the box to open the full booking.
Is it possible to have more detail show on the card other than just the title?
It would be useful, for example to show the title, name and postcode within this initial view.
Thanks
Could you share where you are capturing the other details such as name and postcode? Meaning are those in the same table as calendar and in other columns dedicated for name and postcode or from some other table? Also is the understanding correct that you would like to show those details in the following view as in the screenshot?
Also presume you are not referring to Google calendar integrated into an AppSheet app but simply a table with necessary columns integrated into AppSheet’s calendar view.
Hi YES, that’s perfectly what I mean. I am not using google calendar.
So under TEST EVENT I am hoping to show a couple more pieces of data, such as the name of the booking holder or the postcode or whatever.
I also have some data, such as the price within the same table as the calendar information. It would be handy to know how to show this too, in case I need to.
Thanks
The name and address of the customer is in a different sheet (a tab in Google sheets called “customers”).
Thank you. For pulling data from the other table in an easier manner, you will in general need a referencing relationship between the two tables.
References between tables - AppSheet Help
Once you have data in a single table, you could use concatenation of data in other virtual column to show it in the calendar event.
For example , if you have price in the same Calendar table as you mentioned, you could use concatenation of price and description column into another virtual column called say [All Description]
Use virtual columns - AppSheet Help
Then use that column in the “Description” setting of the calendar view.
So calendar table looks like below
The [All Description] column has an expression of
CONCATENATE([Description], " Price- $", [Price])
The [All Description] column is configured in the Calendar view settings as shown below
Finally, the calendar entry looks like below
Please note that the width of the event entry field will be different on different devices so you will need to use an optimum expression based on which devices the users will use most.
Wow, ok, I read this twice and I think it will take me a little while until I am able to put this into action as I am still new to this (only started in the last couple of days).
Hopefully I can get this done.
And THANK YOU again.
Thank you again for this, with a little more time spent looking at it and using the system I am starting to understand.
Is it possible to have a line break? So that the second piece of information appears on the next line down? Or am I asking too much? If it’s complicated, don’t worry about it.
Yes, that should be possible in a long text type column. There are many posts in the community on line breaks please search by the key word “line breaks”
Please post back if you need any additional help.
