Jump to content

slytle

Members
  • Posts

    22
  • Joined

  • Last visited

Everything posted by slytle

  1. Sorry I didn't explain what I need very well. We are running FileMaker Server 8 I have: 1. Field called "Modified By" Options: Auto-Entered Modification: Account Name (Do not replace... Prohibit Modification...) 2. Field called "TSModified" Options: Auto-Enter Modification: Timestamp (Date and Time) (Do not replace... Prohibit Modification...) These apply to the entire record. What I need is similar fields set up to auto-enter when a due date field is changed. I need to know when and who changes this one field. Does that make more sense? I can post a file if need be. Thanks!
  2. I need to implement a system that will stamp a users name and modification date and time based on one field changing. Currently, these stamps change when anything in a record changes. TIA, .sly
  3. Thanks Mr.Vodka. That got it! .sly
  4. Thanks for the reply. The only problem I have with that is that it returns the date and time. Any way I can set it to return the time only?
  5. I have built a nice server based time clock solution. The only problem is that someone figured out that by changing the time on their computer, they can clock in at any time they want to. Short of locking the System Prefs on everyones computers, or firing someone for forging their timecards, is there a way to fix this? Is there a way I could use the time on a remote computer for my timestamps? I have a computer that I can dedicate to the cause. TIA, .sly
  6. In a webviewer, when clicking a link that is specified to open in a new window, the default browser is opened. Is there a way to force it to open in the same webviewer in FMPro instead? TIA, .sly
  7. O.K. I guess this means my question is so simple, it doesn't deserve an answer or it just can't be done. Anybody? .sly
  8. I'm sure that this has been covered somewhere, but I can't find it for the life of me. I'm running FM 7/8 w/ Server and want a method to allow a user to click a button on an order screen to email just a few fields and a line of text to the designated CSR for the account to let them know an order has been placed. I do not want any interaction with the user other than a possible message letting them know that the email has been sent. I do not want an external email application to be used. All users are on our WAN and are running both OSX and XP. We have an SMTP server that is open with no login required as long as it is to an internal email address. I'd like to be able to do this without the use of plugins, as I have many offsite users and don't want to deal with the extra cost and hassle of keeping the plug-in up to date. TIA, .sly
  9. File sent to Queue, no problem seen on his XP station. Anyone else have any ideas? Appears now to be an OSX problem?
  10. Yes, it's in the line items table. The Orders and Line items tables have the order number in common. Line items shows only info for the item billed: Order Number = 12345 Quantity = 1 Description = Hours of Time Unit Price = $100 Total Price = $100 The Customer information such as customer name, address and phone number are being shown with fields related solely on the order number. I tried the set field command, which I like better, but that doesn't work either. .sly
  11. nope... I installed v.3 and same thing. Any other ideas? .sly
  12. I have set up a simple script to add line items to an invoice. The script is as follows: Copy [select; invoices::order_number] New Record/Request Paste [select; invoices::order_number] Commit Records/Requests[] Refresh Window The record information is being pulled from a related table, but does not show up until you add info ie. quantity_billed and description_billed and then you flip to a previous record and back again. I cannot get this to refresh for anything. It would be ok if it just left the info from the previous record, but it goes blank as soon as you activate the script. HELP! TIA, .sly
  13. Thanks! That did it! Now I just have to add up all the shipping charges for each job and I will know what to bill the customer. .sly
  14. Wow! 40 views and no one has any suggestions?
  15. I hope I can explain this without making it sound more complicated than it really is. I want to set up a set of records with an Airbill number, shipping charges, and the order number that was shipped. My problem is that multiple orders ship in one package and I want to be able to divide the shipping charges by each of those orders. So, I'd like to have these fields: airbill_number order_number total_shipping_charges and some sort of calculation field that divides the total_shipping_charges by the number of order_numbers that share this airbill number. We will also have multiple airbill_numbers for each order_number (each with it's own record) so I'd like to be able to get a summary of the charges for an order. example: Record 1: Airbill: 999991 Shipping Cost: $10 Order Number 12345 Divided Shipping Cost: $5 Record 2: Airbill: 999991 Shipping Cost: $10 Order Number 12346 Divided Shipping Cost: $5 Record 3: Airbill: 999992 Shipping Cost: $30 Order Number 12345 Divided Shipping Cost: $10 Record 4: Airbill: 999992 Shipping Cost: $30 Order Number 12347 Divided Shipping Cost: $10 Record 5: Airbill: 999992 Shipping Cost: $30 Order Number 12348 Divided Shipping Cost: $10 Summary of Shipping Charges for ON 12345 = $15 So, if I haven't confused the heck out of everyone, what would be the best way to go about this? TIA, .sly
  16. Hmmm... Each line item on the invoice as a separate record grouped together by the relationship of an invoice number. That's it! That'll allow the user to add as many line items as they need. I'll be able to use this for the packing slip as well! Thanks for your input! .sly
  17. I am working on the invoicing section of my Order Entry/Scheduling/Estimating/Invoicing system. The way I was setting it up was to have: a quantity_billed field with 20 reps a description_billed field with 20 reps and a value list a unit_price_billed calculation field with 20 reps a price_billed calculation field with 20 reps The unit price field is set up as: If (description_billed = "product1" ; price_list::product1_price ; price_list::product2_price) The price list is in another table with all global fields. My problem is that it will not calculate the unit price beyond the first rep. I have tried putting the unit price fields in the same table and that does not work. If I use a number instead of a separate list, then it does work, ie. If (description_billed = "product1" ; 1 ; 2) It shows the unit price of product1 as $1 and product2 as $2. The price billed calculation works fine. Anyone have any idea what is wrong? Or if there is a better way for me to go about this? Thanks, .sly
  18. Excellent! Worked like a charm! (although FileMaker, Inc. should have made an easier way to do it! ) .sly
  19. I am creating a custom DB solution for my company and wanted to insert buttons with rounded edges. The problem is that when you click the button, the entire rectangular shape of the button image goes grey. Is there anyway to make the mouse down color follow the transparency of my GIF? I noticed that FileMakers standard rounded button behaves this way. TIA, .sly
  20. I would really like to see the DB, because I'm about to do the same thing, but I don't use plug-ins either.... Anyone out there have an example that ANYONE can open? .sly
  21. Here's a discussion of the method I mentioned above: http://www.fmforums.com/threads/postlist.php?Cat=0&Board=separation&page=0 I didn't see that this thread had been spotlighted before I made my post... .sly
  22. I have heard that it may be a good idea to have two DB's. One would contain the data only and the other would contain the interface. This way you could make changes to the interface without affecting the data and an upgrade could be done in minutes with minimal downtime of your DB. Any thoughts on this approach? .sly
×
×
  • Create New...

Important Information

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