Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About cruijff

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Thank you Wim Decorte. I have abandoned the idea of using global fields for this issue and effectively implemented doughemi method. Thank you all.
  2. Thank you very much. That's the way I did it in my file, except it's working. Nothing I was just joking. The thing I didn't understand was about how global fields (in a shared db) work, reverting to their existing value when its content is changed from a client. How can one effectively change the content of a global field without accessing from the host? In a shared solution with FMS it would be quite annoying to "close" the db and open it just to change global fields. Edit: It seem you can't from the Notes first line http://www.filemaker.com/12help/html/add_view_data.4.48.html
  3. Ok doughemi, I tried your method and it's not working. When I create a record on my greentable which has fields who lookup to gConstants fields none of them gets filled in. There's surely something I'm doing wrong, I'll try to figure it out myself.
  4. Thank you for this advice, I guess this is the route I'll be taking. I have created three number fields in gConstants table: EUR_to_USD EUR_to_CHF CHF_to_USD and three Number fields on the greenTable EUR_to_USD_Current - Lookup to gConstants::EUR_to_USD EUR_to_CHF_Current - Lookup to gConstants::EUR_to_CHF CHF_to_USD_Current - Lookup to gConstants::CHF_to_USD And I linked them with Cartesian Product as you suggested in this way: Then I'll have a script on the greenTable using the values of EUR_to_USD_Current field. Is this what you meant? I don't understand why I should have Cartesian Product Relationship "X" instead of "=" relationship. Shall I create a parent key on gConstants (const_ID) and use it as foreign key (const_ID) on the greenTable and relate them with Cartesian Product instead of relating the single fields to each other as I did in the picture? Thank you for your help.
  5. ....aaaaand now it works. what. I'll recap everything I did so that maybe you can help me avoiding mistakes. Table name: gConstants Fields: EUR_to_USD_Main (type: NUMBER) EUR_to_USD (type:CALCULATION) Calculation Result: EUR_to_USD = gConstants::EUR_to_USD_Main / Storage Options: Global /Indexing: unticked do not store, recalculate when needed / unticked Do not Evaluate when all reference fields are empty. I created the first (and only) record on gConstants table, I filled in the field gConstants::EUR_to_USD_Main with a numeric value. Closed and reopened db and BAM! the field EUR_to_USD is still showing its value. But I'm worried.
  6. Hi guys I have a problem with constant values. The constants I deal with are currency exchange rates, I have to set these constants once per year (maybe). Upon reading the topic http://fmforums.com/forum/topic/64043-best-way-to-store-access-constants/ I set up a table named gConstants and 1 calculation field named gConstants::EUR_to_USD, calculation result EUR_to_USD = 1,300 and I set it to global storage (options->storage->global). If I create a new record on this table (first record) the calculation field gets set to 1,3 and everything works fine: there's a script which uses the calc field value and sets another field accordingly on an unrelated table. The problem is that if I close the database and open it up again the table gConstants shows 1 record and no values for the field gConstants::EUR_to_USD. So I tried to set up another field on gConstants named gConstants::EUR_to_USD_Main, fieldtype: Number and I set gConstants::EUR_to_USD fieldtype:Calculation and Calculation result: EUR_to_USD = EUR_to_USD_Main (I guess this is what user LaRetta means by " mirroring the fields in it as global calculations" in the topic previously linked). Again, everything works fine if I create a new (single) record in table gConstants, but after closing and opening the database there's 1 record on table gConstants with the field gConstants::EUR_to_USD_Main displaying the value 1,3 I previously entered but no value on the global calculation field gConstants::EUR_to_USD. I guess I'm making some sort of STUPID mistake but can't understand where. Can you please help me? Thank you very much!
  7. Thank you all guys. As comment pointed out the correct relationship is Manufacturing::man_prev = Manufacturing 2::manID I created a field named linked_qty and set it as related record showing the field Manufacturing2::warehouse_qty and all seems fine. (edit: is there another way to do so? I experienced problems in the past displaying a related record on other related tables). With "manual" insertion I did not mean that the FK is entered actually manually , I meant to say it is not an automated act, I have set it as pop-up from a value list, no worries!
  8. Thank you LaRetta, I'll give it a try! I don't know why I didn't think about this..
  9. Hi guys, I have a problem I'm struggling with: I have a table named Manufacturings (parent key field = Manufacturings::manID) which has a field named Manufacturings::man_prev, which displays the unique other manID (entered manually) with whom the Manufacturing is linked to for warehouse reasons. For example: Table: Manufacturings field1 = manID (manuf_012) - parent key field2 = man_prev (manuf_010) - entered manually field3 = warehouse_qty (1200) I would like to create on the table Manufacturings (e.g. manID = manuf_012) a field which shows the warehouse_qty of manuf_010, i.e. field 4 = linked_qty I know I could make a long script along the lines of: set variable $var = manufacturings::man_prev go to layout (manufacturings) performs a find on field manufacturings::manID using $var set variable $qty = warehouse_qty go to layout (manufacturings) set field manufacturings (linked_qty = $qty) etc.. but I'd like to know if there's a faster (and more clever) way to do this, maybe via a calculation field. I hope my post is clear..thank you very much!
  10. @bcooney I guess the answer to your question is yes: my "Orders line items" table has a field named date due, and line items are linked in a calendar to keep track of shipping dates. Am I doing something wrong?
  11. Thank you bcooney, the file you posted will be really useful I understand your point about not needing a "snapshot pdf" but I'll try to give you an explanation: When I receive an order from a customer I fill my order layout with the data on the customer's order (let's say my customer orders 1000 pcs of product A). I send to my customer the pdf produced by "order entry pdf layout", i.e. order confirmation. If I am not able to ship the whole 1000 pcs and want to do a partial shipping I'll have to modify the order line item, i.e. modify the order. (While I'm writing I understand I should send another order confirmation to my customer, but I can't since the customer wants to keep track of our company's delays). Hence I need to have a snapshot of the order I received, saved as pdf. This does not apply to Invoices and/or purchasing orders which are never modified, but my db users asked me anyway to keep all the documents we produce saved as pdf if possible. I'm about to figure out how to achieve this, I'll post the solution I've come up with when done. Thank you guys
  12. Yes Ralph, but I don't understand HOW to write it on the server..
  13. Ok guys, I'm having a bit of trouble here. I read about remote containers (article "Remote Containers" by Wim Decorte & Steven H. Blackwell included) and I suspect this is the thing I need. I'll try to explain in detail what I'd like to achieve: I have a table named "Invoices", and for this table I have two layouts: "Invoices_layout" and "Invoices_pdf_layout". Of course "invoices_pdf_layout" is a pdf-like layout, whith a part "visible" in preview mode and a part cut off in preview mode. What I'd like to do , while sitting on "invoices_pdf_layout" is to execute a script (pressing a button) that saves as pdf the invoice and puts it in a container field on this same layout. Can I do this with remote containers, so that every user of the database can consult and/or send via email the pdf version of the invoice? Which script steps shall I use to save the invoice as pdf directly in the container folder (FMS)? Or do I have to save the file locally and then put it in the container field so that is gets saved on the server? Which script step allows me to insert a .pdf file in the container field? Thank you very much again.
  14. Thank you Ralph. Even thou I don't want to make an automated server script (I don't need it) I'll certainly take a deep look at your posts, they'll certainly be useful to me.
  15. I don't need the files to be accessible from outside FM, all users have a copy of FMpro. I'll try to go for the container field solution, since I have 2 osx users and 1 windows user.
  • Create New...

Important Information

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