I think perhaps the answer to this is already within the community posts - but a mixture of a few.
I have a integromat trigger that is bringing in the date of an appointment, the start time (say 9:00am). Then for each appointment type (a connected object) I have the set duration of the appointment - e.g. Physio is 30 mins, Driver Medical is 45 mins). I then have an equation field that works out the finish time for the appointment, say, 9:30am. So from these four fields, I want to produce a date for the calendar view that uses the from and to elements so that on the calendar view, it is showing the correct duration, start time and end time for each of the appointments. But, my question is, how do I get those fields in to a calendar date field? I have tried to use an equation field to combine all of those elements together, and then put that in to a new date field using conditional formatting, but that isn't working.
Any help much appreciated.