Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About ping

  • Rank

Profile Information

  • Gender

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I haven't been able to make this work yet. Recently, I do a lot of surfing and reading trying to understand this last part. By implementing your solution I was not able to make it work yet. Since I am not a programmer my daily duties keep me away from this puzzle but I am determined not just to solve this problem but rather to understand how to solve this problem. When I referred myself as being Mac user I wanted to say that is harder to make XML style sheet on mac or virtually impossible. My first idea was to create an XML style sheet and export data as XML. Of course, Filemaker does not have anything to do with this.
  2. My company is fairly small and excel sales order sheet came from a very big oil company. We asked them to create order in pdf or to send them our sales order sheet. They rejected all other solution and insist on getting an order in their predefined format.
  3. I have a simple Excel document one of my partner using as an sales order sheet. A few fields has to be fill out, such as quantity, type of goods and preferred delivery date. At first I tried to learn how to make excel style sheet and export data from Filemaker to xml. Since I am mac user it turns out, it is not a simple task. Then somebody told me to explore use of apple script. It works almost like a charm. Here is what I did so far. I created script in filemaker as follows: Set variable [ $quantity ; Value: Orders::Quantitiy ] Set variable [ $goods ; Value: Orders::Type of goods ] Perform AppleScript [ "tell application \"Microsoft Excel\"" & ¶ & "open \"Users:ping:Desktop:Order:Order.xlsx\"" & ¶ & "set value of cell \"C16\" to \"$quantity\" & ¶ & "set value of cell \"D16\" to \"$goods\"" & ¶ & "end tell" ] By pressing button export I get following result: Microsoft Excel opens Order.xlsx opens Cell C16 is filled with $quantity instead of value in field Quantity Cell D16 is filled with $goods instead of value in field Type of goods I am not developer and this is not life saving job, but I would like to learn something and automate the process if possible.
  4. Does this version support Dropbox?
  5. You are right. I thought it might be something with file name, and I tried to copy name only. Now I tried to copy entire field and this solved the problem. Thank you for this tip.
  6. Hi, I created warehouse table with fields like: Catalog No., Producer, Serial number, Qty., Description, incoming date and outcoming date. I also have a calculation field which tells me if item is on stock or it has been delivered. To know what I have on stock I created new list view layout and script which basically create report with items I have on stock and summarize how many items I have for each category. Records are organize by Catalog number. Problem appears when I create report, some items are repeated. However, item count is correct. For example: if I have following records: Cat No. Description Qty 123 A 1 234 B 5 345 C 2 123 A 3 234 B 1 345 C 1 My report looks like: 123 A 4 - correct 234 B 5 234 B 1 345 C 3 - correct Catalog number field is text field whith option Auto complete using existing values. I was not able to find pattern, why this happens on certain items. Tomislav
  7. Hi, I have two tables, one is warehouse with all items I have and other one is called bill of lading. I am dealing with sellable items and demonstration items. It means, I send out and after week or two receive same items back in warehouse. I do not create invoices. So far I did as follows: in table warehouse I have fields catalog number, serial number, description, incoming date, and outgoing date. Based on incoming and outgoing date I have calculation field with simple result in or out. in table bill of lading I have user information fields, product informations fields and select items field. This field is a value list filed with outgoing date. It means, if in table warehouse outgoing date has been filled out, this date will be shown in value list. Then in product information fields I will be able to select only specific product with specific SN. Main goal of this database was, to be able to select only items based on serial number, which are scheduled to go out to specific customer. This is working just fine, but I am stacked and not able to get more information from this. I try to get portal within warehouse table, which will show in one tab items still in warehouse and in other tab items which has left warehouse either as demo or sold items. Portals are very much related to the record which is open. Also, I can created relationship with calculation field which is set to "Do not store, recalculate when needed". Question is how to do it.
  8. ping

    Filtering portal

    Thank you. That's it.
  9. ping

    Filtering portal

    @ comment I tried all option possible and I am not able to create relationship which will filter portal and separate payment due and overdue. What I get, is list of all records for selected ID. Any clues? @ BruceR Unfortunately, switching to version 11 is not an option now. (My boss has different views from me, when it comes to which software is really needed.)
  10. ping

    Filtering portal

    Hi, I create invoicing solution with separate tables for incoming invoice and outgoing invoice. In both of them I have calculation fields which can not be indexed because they calculate payment terms (30, 40, or 90 days from delivery). Calculation in field "c_valute" looks like: Get (Current date) - Incoming : When payable Result is a number. "Do not store results - reculculate when needed" option is selected. After that I created field which tells me if my payment is due or not. Calculation for field c_due": If ( Incoming : c_valute ≥ 0 ; "must be paid" : "not payable yet" ) Results is a test. "Do not store results - reculculate when needed" option is selected. In Incoming invoices I want to create several portals where I would separate : all invoices must be paid invoices not payable yet invoices paid invoices not paid invoices. I can view records in portals only if calculation field can be indexed. However, I want to create relationship with fields which I can not indexed. I created portal with all invoices an now I look to find a way to filter those records. I found certain solutions on the web but none of them deal with unstored records.
  11. Where I leave, internet providers, often have support for PHP, .NET, SQL, but not for FM. So, I thought, it would be much easier to learn basic PHP, and how to interact data from server to FM. Thanks for the tip on the book. I will read it.
  12. Hello, I would like to learn in shortest time possible, how to create web page with forms, which can be, at the end, saved in filemaker databese on my computer. I do not have possibility to use filemaker server. I can create web page, familiar with html and css and I would say I am intermediate user of FM. Where I can find books (in PDF if possible), web pages, templates which will explain how it works. Also, I would like to know where to go to learn PHP in shortest time possible. (books, web pages, templates).
  • Create New...

Important Information

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