Jump to content

scripting a rotating "Up" sales board?


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

Recommended Posts

  • Newbies

I am trying to script a routine that will take a list of "available" salespeople and put them in order "on deck". When with a customer, I want to move the top person "on deck" to an "On the Floor" list. When the person is finished with a sales opportunity, I want to move his/her name to the bottom of the "on deck" list. If you are familiar with furniture sales, you know the routine! Sounds simple, but I've been racking my brain for well over 12 hours trying to figure this out.

I have a database of "Employees" and a database that acts as the interface for my "Up Board"

If anyone can help, please email me with any ideas.

Thanks!

[email protected]

Link to comment
Share on other sites

  • 2 weeks later...

You might be able to use a number field and a global. When someone comes back off the floor, set the global field to global +1 (so its a counter), then set the number field to the value of the global. You can then sort by the number field. When they go back on the floor, remove the number from the number field. Hope this makes sense...

Link to comment
Share on other sites

This topic is 7732 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.