Jump to content

charisse

Members
  • Content Count

    41
  • Joined

  • Last visited

Community Reputation

0 Neutral

About charisse

  • Rank
    member
  1. charisse

    Rounding a summary field

    I think that this would work well for me, but I am not clear as to what the "breakField" refers.
  2. Can belong to multiple events, but only sold once.
  3. Yes, I only need to track actual sales. And yes I agree that I don't need the join table. My issue is that the price field originates in the event databases, (and there are 24+ events with approx. 4 new event databases created annually), not in the products/inventory table. If I put a field for the actual selling price on the record in the products/inventory table, the data will need to be "delivered" to it somehow. If via the relationships then I would need to put a price field for the "actual selling price" on the product record in the products/inventory table for every event, something like: Event 1::Price Event 2::Price but this seems a bit of a waste of space as the product will only be sold once and all of the price fields on the record will be empty save one. or I can put a price field for the "actual selling price" on the product record in the products/inventory table and have that field "go get" the price by calculation. Not sure if one or the other would be "better," or if this approach even makes sense. I apologize if this is difficult to follow. With my limited expertise in Filemaker I am not always aware of the proper syntax etc.
  4. The selling price comes from the event. Each event is it's own db. Each item/product is unique and can only be sold one time. The 15,000 records in the inventory/product table are 15,000 unique items. There are no list prices (not that this really matters). I will study the demo and see if I can apply the principle. Thank you.
  5. Yes, I understand the whole affair is quite complicated an convoluted. I am trying to make the best of what I have been given to work with. I import only the needed records (products) to the specific event (600-880 per event). I guess I am not understanding how to get the selling prices into the join table other than by calculation.
  6. Let me try to clarify... I have a database of products each of which are unique and have a quantity of one. A group of these products may be offered in a sales event. Each sales event is it's own database. If a product sells I need to retrieve the price for which it sells and show that amount on the corresponding record in the products database. I thought about the join table approach but it seemed somewhat pointless as all the record are related by the same id-field and I was still needing to "fetch" the actual selling prices with a calculation.
  7. I have written a calculation to display sales prices (from multiple tables) on my main product table. Each product is unique and has only one selling price, but it may have been offered in multiple sales events. The calculation works, but I am wondering if this is the best way to approach the task. Case ( not IsEmpty (Auction 16_04::Hammer) ; Auction 16_04::Hammer for Inventory ; (Auction 16_02::Hammer) ; Auction 16_02::Hammer for Inventory ; (Auction 15_11::Hammer) ; Auction 15_11::Hammer for Inventory ; (Auction 15_09::Hammer) ; Auction 15_09::Hammer for Inventory ; (Auction 15_07::Hammer) ; Auction 15_07::Hammer for Inventory ; (Auction 15_05::Hammer) ; Auction 15_05::Hammer for Inventory ; (Auction 15_03::Hammer) ; Auction 15_03::Hammer for Inventory ; (Auction 15_02::Hammer) ; Auction 15_02::Hammer for Inventory ; "" ) We work in a peer to peer environment. Approximately 15,000 records in the main table and about 600-800 in the event tables. Any input would be most appreciated. Thanks!
  8. Good to know. I will give that a try. Thank you both.
  9. The first time I run the script it seems to take the time to create the pdfs/invoices. The second time I run the script in completes in a fraction of the time generating email with no pdf. I am not too familiar with the debugger. I think I have the toolbars showing, but I am not sure how to see the record count, total records, pdfs generated etc. I stepped through the script and as I did so, the pdfs (should be one per email) were created on the emails. I am thinking that the script is running too fast to generate the pdf the second time around? I put in a 1 second pause after the Send Mail step and that seems to have "fixed" the issue, but I am left with a curious error message in the debugger. 101 record cannot be found? I don't know what to make of that.
  10. Yes, the script runs (very quickly BTW) and shows no errors, but there are no pdfs attached to the emails generated (except for the last email which has the pdf for the last record attached).
  11. I have written two scripts to email invoices to customers. The first time I run the script everything works fine, but if I need to run the script again the emails are created, but only the final email has a pdf attached. If I close both of the databases involved the script runs properly again (one time). Any ideas? Thanks!
  12. charisse

    Print invoice only if marked paid.

    I will give that a try. Thanks! P.S. I agree about the invoice status. Unfortunately, that is just a small part of a much larger problem. We have one solution for inventory management and a separate (independent) solution for each "sales event." They do not seem to communicate with each other very well. The invoices live with the event. The invoice status lives with the inventory, I am assuming because the inventory would not know where to go to get the status because of the many "events." I am sure this is all very confusing, I find it quite overwhelming at times myself. I inherited this solution, I did not design it.
  13. charisse

    Print invoice only if marked paid.

    Yes, I mean the current invoice.
  14. charisse

    Print invoice only if marked paid.

    I have a layout in which invoices can be marked via a radio button selection "Paid" or "Unpaid." I am trying to write a script that will only print the invoice if it has been marked as paid, if unpaid send a message to the user (custom dialog box) that the invoice is not yet paid, but I do not know the correct syntax. I have been trying to use an "if" statement, but that is not working for me. Any help would be appreciated. Thanks!
  15. charisse

    Convert Number to Text

    Thanks comment! & "-" & MiddleWords ( Lower(D1); O; 1 ) worked perfectly.
×

Important Information

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