Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Timeslot Calculation


Ron

Recommended Posts

Hi Guys,

I have a scheduling system which is incrementing time slots of 15 min increments. If I add an event titled "Kids hair cut" and I give it a time span from 1:30PM - 2:15PM.

Every slot in the range is showing the text "Kids hair cut" e.g 1:30, 1:45, 2:00 and 2:15.

 

The field holding the text event is "WeekEvent0"

 

What I am trying to achieve is firstly, only the first slot of the time range show the event name... and secondly if there is in event in the slot, the backround of the portal row will change colour.

 

In advance I sincerely appreciate your help.

 

regards Ron

Link to comment
Share on other sites

[ QUOTE ]

If I add an event titled "Kids hair cut" and I give it a time span from 1:30PM - 2:15PM.

Every slot in the range is showing the text "Kids hair cut" e.g 1:30, 1:45, 2:00 and 2:15.

 

The field holding the text event is "WeekEvent0"

 

 

regards Ron

 

[/ QUOTE ]

 

First lets address the the field issue , then we can fix the color thing later.

 

You are using different fields for each slot right?

 

I.E.

TimeSlot1

TimeSlot2

 

etc

Link to comment
Share on other sites

Instead of all of us guessing, why not post your file? I can think of several ways of doing this, but then they may not have other features that you might require.

Link to comment
Share on other sites

Yeah Sorry, How long is a piece of string.

 

I have included an image of my problem.

As you will see the appointment cover from 1PM - 2.30PM and has filled every slot in that range with details of the appointment. I need a script that will compare those fields and see that there is there is greater than "1" and either change the colour of the text to the background or not show the details for the following 5 slots.

 

Does this make it any easier.

 

Thank you sincerely for your help.

 

Regards RON

Link to comment
Share on other sites

No, it doesn't (make it any easier). As I said, there are several ways to achieve the pictured result. Since I don't know which one you used, I don't know what to suggest. IOW, open up the hood.

Link to comment
Share on other sites

OK - I am sorry, this is much more than I bargained for. It would take me an awful lot of time to try and understand the structure and see how your request might be implemented (if at all).

 

I would advise you (or the board administrator) to remove the attachment ASAP. I haven't realized you were referring to Matt Petrowsky's scheduler. ISO FM Magazine sell this as a tutorial to subscribers, and they might feel their rights are being violated by this publication.

 

Perhaps you should post your question on their own forum:

http://forum.filemakermagazine.com/

Matt makes an appearance there occassionally, and he might provide a solution.

Link to comment
Share on other sites

Thanks for that.. I have requested the attachment be removed with the admins.

I did ask Matt Petrowsky but with his busy schedule he couldnt help me.

regards Ron

Link to comment
Share on other sites

On the subject of Matt Petrowski and Filemaker Magazine,

I think they are both EXCELLENT!! Joining Matt's Filemaker Subscription was truly the best move to fastrack my Filemaker Career.. Thanks sincerely Matt.. See post above for URL and further details.

Link to comment
Share on other sites

If you took the tutorial, then you should know how to fix this. Better put - you should know where to fix this. I can tell you how, I just can't find where in that maze.

 

You need to find the spot where the the event name is being passed for display, and add another TO there. I believe it needs to be another TO of the CalendarItems. I can tell that the event name is NOT being displayed directly from the source, but I can't find when, where and how it is passed (to CalView).

 

Now, the additional TO should be related only when the START time of the event matches the time of the display slot. I presume the current TO is related to ALL the display slots in the event's RANGE, so the name - and the hilite - is passed to all of them. You need to take only the hilite from the existing TO, and the event name from the newly added TO.

 

I am attaching a picture from one of my calendaring prototypes that shows this same principle in a simpler context. Hope this can help.

 

 

---

You can click Edit on your posting and remove the attachment.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...

Important Information

Terms of Use