Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About onestopbusiness

  • Rank
  1. good lord....I was hoping for something simple like..if user is member of privilege set X set field (location) to X etc..etc..was thinking it would be as easy as adding some if thens to a startup script?
  2. uh...I don't have anything quite so complex. I have no users table or locations table The users are setup using Filemaker's default Manage Security. And the locations are in a simple value list at the moment.
  3. Hmm...not sure I understand that. sorry to be so obtuse. I have a field in my Db called Location that uses a value list. Denver, New York etc... I'd like to make it so that when a user logs in that is part of say the Denver privilege set...the Location field automatically gets set to Denver when they create a new record...if they're part of the New York set it gets set to New York. is get(privilegesetname) a valid function parameter? I'm not familiar with it.
  4. probably a simple question... but what I'd like to know is how to set a field's value based on the Privilege Set that a user is a member of... For instance, user A is a Member of Privilege Set A..so upon logging in...any new records created automatically set the Location field to A...etc..etc.. Thhnx in advance
  5. well that would certainly be more efficient...my only question becomes how to find a particular serial number for a client when only ranges are stored?
  6. well I offered the interface to illustrate my ideas regarding the processes. I've written a FMP solution for a client that uses the Amazon ECS based on the ISBN or Barcode scan and parses the returning XML. It's pretty straightforward in that you scan a book and Amazon gives you all it's data related to the ISBN. No brainer...this one however has me a little befuddled. In that system, my customer pushes a button, a window pops up with the scan/isbn barcode field waiting to accept input. They scan the book, window closes and of course the amazon scriptruns...tada! Done. I'm thinking
  7. ok, don't want to sound too stupid..but how do you "scan into a portal" never tried that before...
  8. ok, so that kind of leads me back to my way of original thinking and what I put in my posts...for every "set" of cards...I should create a new record in the "orders" table for that client? My only concern with that method is that with my client literally selling hundreds of thousands of these cards...how long before my Db becomes too bloated to manage?
  9. hmmm..I had originally envisioned a screen where they pulled up "pending orders" and clicked on a client who's order needed to be filled. At that point it would show how many cards had been purchased. They would grab boxes and scan the first barcode and the last barcode number on each box...then a "handful of cards" to finish up the last amount needed and scan in the first and last of that "handful". Meanwhile in the window, a counter would show how many more was needed to complete the order. Does that make sense?
  10. could you be a little more specific? Sorry I'm just not catching how the table/field structure would resolve my problem.
  11. Agreed, the Search isn't the part that I'm stumbling over. It's how to enter in those different sets of cards and assigning them to the client. Should I create a new record for each set for the client or is there a way to store each set in an array..etc..etc.
  12. I should probably explain it a little better. My client buys these cards by the hundreds of thousands and then resells them. He actually "repacks" each order for the customer. So if a customer calls in and orders 241, his fulfillment people pull 241 cards out of the "bulk" boxes and repack them for the client to be shipped.
  13. The way their process works is that a salesman sells the cards and the back of the house is responsible for filling the order and shipping it. So let's say a client calls in and orders 275 cards. The fulfillment people run over and pick up a box of 250, they scan in the the two barcodes on the box...no problem. Now they have to run over and open up another box and take out 25 to complete the order. They can type in the first serial and the last serial of those 25 into the system. Now the client ends up with two different sets of serial numbered cards. Say #1-250 and another set #750-775.
  14. I appreciate the speedy reply and the very nice example file. The problem that I am having is A) How to assign the cards to a particular client when the order requires more than one box. ie. client orders 1000 so 4 four boxes must be scanned one after the other to complete the order. Do I have my system create a new record in my orders table for that client after each scan? And then B.) what to do when a client orders say 1001 cards. Now I have a leftover box with 249 cards in it and the barcodes on the outside of the box become worthless. I should have specified that the cards won
  15. I have a client who needs an inventory tracking and CRM system. The CRM part is a no brainer, however his inventory is a bit of an issue. He sells cards that all have individual serial numbers on them. The cards come in blocks of 250 in the boxes with the beginning and ending serial number printed on the outside of the box. Typically, the process is this, a client will call in and order say 1000 cards. They create the invoice, charge the client's credit card and send the "pick ticket" to the back of the house for fulfillment. Problem is the back of the house will grab 5 random boxes
  • Create New...

Important Information

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