Fifteen seconds into the future...

[Ian Murphy]

FM6 user with 'extensive limited' experience. I.e. I don't know much but I'm fast at the simple stuff.

So here's two things: What I want to do, and how I think I want to do it. I'm open to being told that in my approach, I'm barking up the wrong tree.

DESIRED EFFECT: I regularly send out a bunch of freelancers' contact information to clients who are looking to hire labor, so in my new phone book, I want to be able to grab as many phone numbers as I feel like, then paste them to an email or word processing document. So, one from Column A... two from Column B ... there, there's a list of 6 guys and their phone numbers. Plop.

WHAT I'VE GOT SO FAR: I've done the scripting so I can copy out data with a single click. I.e. click on Bob Smith, get text that says "Bob Smith (Cell) 917 555 1212." And I've set up a global container [FM6, remember] that will keep adding data, formatted correctly, until I stop clicking. What I want is, each time I click, to start a clock that, when it gets to fifteen seconds, clears the contents of that global container [so that they aren't there when I come back an hour later to do this again].

I'm a Calculating novice, but I have set up three fields: a CurrentTime that drops in the [you guessed it] current time when my request is triggered, let's say 11:15:22; a calc that reinterprets that as seconds [00:00:22]; and a calc that adds 15 to that last [00:00:37]. How do I tell the database to 'watch the clock' and clear that field when the contents of that last field match up with the current time? Or am I turning in circles when I could be stanidng still?

[Howard LeCanard]

Ian,

I've attached a zip file showing how I'd do it.

I hope this helps.

fifteen.zip

[Ian Murphy]

Howard,

Brilliant!

I do find that a lot of my learning curve is intuition stuff like this - just trying to figure out how the machine will think.

Thanks for your time.