Jump to content

VL of time slots


LaRetta

This topic is 7212 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need a popup menu with times. I want them displayed every half hour from 7am to 10pm. I could create custom VL of course, but I want the result to be a real time field (will be triggered to notify User via plugin). Is there a calculation I can use? Or, if I need to enter them all manually, how can I be sure it will be appropriate for a time field. I just have never worked with time fields before. crazy.gif

LaRetta

Link to comment
Share on other sites

My trials aren't working. I want them to line up properly in the popup something like:

07:30 A.M.

08:00 A.M.

or even 07:30 AM

If I don't enter the leading zero, they line up terribly. Right-justify doesn't apply to popups (or can it?). And when I test a calculation adding a standard time field and this 'time' field, I get a ?

Do I need to use a regular text field and convert it to time in some way? crazy.gif

Link to comment
Share on other sites

Oh. You can enter your values manually as a Custom Value List, or you could make them a conditional value list using a related table. This might be used if the value list should be different under different conditions.

Link to comment
Share on other sites

I swear that's what I had and it didn't work! I swear it! I knew it should work as AM because that's how one can display it - but it wouldn't work. Thanks Mike. blush.gif

Must be time to back off of work for a bit ... do some ... cheers.gif and BirthdayPartyGuy.gif and then some Zzzz.gif to clear my head again. Okay ... I'm refusing to work for at least 3 hours!! I don't know what I'll do with that much free time away from FM, but I'll force myself. smile.gif

L

Link to comment
Share on other sites

Sounds like you're working waaaay to hard...

I've become a fan of using a table of value lists for the more complex lists (I still use directly entered lists for simpler cases). You could create a table (FM6 read "file") with two fields, a "display time" for the user to see in a drop down list (a format of your choice) and a looked up time field for the actual nuts and bolts of the function you are performing. This would allow you to divorce the format the user sees in making a selection from the time or number you use in calculations. Just an idea.

-bd

Link to comment
Share on other sites

Hi Brent! I just haven't worked at all with time-based solutions, such as appointment calendars and such. But I will follow your suggestions and start it right ... in a table; because I'm sure it will grow on me. smile.gif

Hey Ugo! "...additional parameters keys for some conditional displays." I have no idea what some additional parameters for time might be!!? The only time I've ever worked with is straight creation and modification time fields! crazy.gif But I trust all of you and will use a table - then when I find out what other things I'll need, I'll be able to expand properly! wink.gif

LaRetta

Link to comment
Share on other sites

Hi there,

What I meant, in my usual gibberish, is that having them stored in a Table/File, you can apply different keys to them from which to base a relationship upon, so that you can even have multiple sub lists displayed.

It's not actually a v7 feature, but with such "parameters", you may have multiple TO's of the Time Table too, and branch a Table to one TO or to another, according to your needs.

For example, you may have hours tied to Days, so that for example, no appointment could be taken on Saturday afternoon, or to Users.

Well you got the idea.

Link to comment
Share on other sites

This topic is 7212 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.