In calendar view - How to link time with follow-up time.
How are you setting up your “follow-up time” and where do you want it to be shown?
We have a column as Follow-up time in Google Sheet and we want that time to be shown at place where 12:00 pm is showing in the image.
I don’t think that would work as intended as that “12:00 pm” component is taken directly from the original timestamp of the event.
Instead, you can concatenate your follow up time with your event name and display it as:
“Event name - Follow up time”
E.g: Guruji solar - Follow up at Monday, June 2, 2020
It’s not beautiful, but I don’t think there’s a workaround.
You could do this by building a new column in your sheet and using a formula to join the date and time together. Take a look at the BookingResponses sheet here: https://docs.google.com/spreadsheets/d/191-c-NXW38hq9h7i7Fe5FlB8pP3e_mfeQHLUGsgwMYU/edit?usp=sharing
This is the sheet for my concepts app. The BookingResponses sheet contains formulas to take a text date and a text time and build a true date/time value that can be used for the calendar layout.
Just a note too that the calendar layout is pretty forgiving at recognizing dates and times from text. your column doesn’t necessarily have to be in a format that glide will recognize as a date, but the calendar will. You might be able to just create a simpler formula that does a simple join of the date and time, but if you want more flexibility, I would look at the formula’s in my sheet.
2 Likes
solved thanks.
Only problem is time is showing in reverse order, Ideally it should show from 10 am to 6 pm for a day. Its showing from 6 pm to 10 am .
Agreed, that is a little confusing. I think it’s a side affect of having your calendar in reverse order, which includes the date in reverse order as well as the time. I don’t think there is a way to show the dates from newest to oldest while also showing the times for oldest to newest. In you case I would think you would want to reverse the order of your calendar assuming that you would want to see the dates and times that you want to follow up with first.
Thanks. We will manage.
1 Like