Jump to content

1 script - lots of fields - multi relationships


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

Recommended Posts

Hi guys,

here is a good one for you.

Can anyone think of a way of writing one script to do the following.

Diary system.

7 relationships, 1 for each day. Within each day are time slots 8am-8pm.

These are stored in an appointments db, 1 record for each day, with the time slots as fields.

Who can think of a way to script this using the minimal amount of scripts.

I know I can do it by writing a script for each time slot. Not keen

I know I can do it by clicking into the field and then clicking a button.

Would prefer the time slot to act as the button.

I use this to pick a day from a mini calendar on the side. (you've got to love the new features of 5.5)

but who can think of a way of doing this by just clicking on the field, returning that time slot with the relevant day.

I know I will need to write the script for each relationship, but at least that is only 7 scripts, not 140 of the darn things.

[ February 27, 2002, 07:06 AM: Message edited by: Andy Gaunt ]

Link to comment
Share on other sites

Script what? Get the name of a field when you click it? Status(CurrentFieldName) should do it, but you would have to do one for each field, because Status(...) needs to go to a specified field to return the proper result.

Link to comment
Share on other sites

Fitch,

oops. I forgot to put that bit in.

In the diary I want to be able to click on any appointment and have it show that related appointment.

I know I can do this easily if I write one script for each time slot. And I know I can do (Status(CurrentFieldName)if I click in the time slot and then click a button (two steps).

But this means 7 buttons for each of the relationships on the screen.

This leaves it too open for user error.

But can anyone think of a way of doing this with one script for each of the relationships.

Basically, have a script that when you click on the time slot, it picks up that time (Status(CurrentFieldName), goes to the relevant appointment and displays it in a pop-up window.

Link to comment
Share on other sites

This topic is 7177 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
 Share

×
×
  • Create New...

Important Information

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