Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Toni

  • Rank
  • Birthday 04/27/1974

Profile Information

  • Gender
  • Location
  • Interests

FileMaker Experience

  • Skill Level
  • FM Application
    11 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Windows 7, Windows 10

Recent Profile Visitors

1,377 profile views
  1. combinations or ...

    Yes Fitch, that what I was thinking. A script with loop which would tick each record that fulfills the condition. But interesting reading about knapsack nonetheless, integrating that into FM is another story.
  2. combinations or ...

    Thank you jbante, a lot to read for today. I wish I was at my 20s again
  3. combinations or ...

    Hello This might be a math combination problem or alike (I can not come with a better expression in english). I would want a set of random numbers to be matched to a sum. For example I have numbers: 9,17 and 4. Then there is another set with sum = 29. The first set has a sum of 30 while the second is 29. What I want to do is fill the second set with numbers from first until there is no more room. So in this example I would use only number 9 and 17 and leave 4 out. The remainder from set two is 3 (29 - 9 - 17 = 3). I would want this remainder to be the smallest possible. To achieve this I thought of ordering numbers in descending order, higher numbers at the top and so on, leaving the smallest at the bottom. This way I believe I can fill the pool of the second set better with the smallest remainder possible. Do you think this is correct, is there any other better method to achieve it?
  4. GetSummary from two related tables

    The language is italian and albanian, both used (don't ask me why ). The menu is just a customized one, one can activate the standard with no problem. The files missing in relation are of no importance, can be ignored. The data is there to help with summaries, are not of great sensitivity, it's just a very small portion of the whole. I see what I can do to make an imitation of the database without the hassle this one carries. Thank you Lee
  5. GetSummary from two related tables

    Yes, sorry about that, the common mistake. Had in mind to change it but forgot. I am attaching the file with user: admin and no password. ComNuovo Clone Copy.zip
  6. GetSummary from two related tables

    Thank you Lee, so here I go with actual field names on the database: The database has 7 tables, but those at our interest are ComNuovo Inventari Raport_Ditor On ComNuovo table there is a summary field called Tot.Capi from where I want to get the summary when ordered by field=Rep. On Inventari table there is a summary field called TotaleCapi from where I want to get the summary when ordered by field=Rep. Both summary functions will be calculated on table Raport_Ditor where I have two fields Dalje_ComNuovo_Copy and Dalje_Inventar_Copy. On the Raport_Ditor I was planning to create the records by script, but they can be created manually by filling only Rep. field and Date field, the rest is calculated. The field that is used to relate the tables is Date_Rep. I am attaching the file.
  7. Hello guys I am really struggling to get this job done which seems pretty easy. I have two tables, let's call them Table A and Table B. On table A I have records of the product flow into the production chain (product goes from phase 1 to phase 2 and so on). On table B I have records which tracks the movements through export from Table A. So table A will give me the situation on every department of the chain production, while Table B will give me totals based on day or hours or month etc. I have created a third table, Table C, on which I want to get a day by day situation from the above tables. On table C I would want to get the summary from Table A and Table B. I have created a field on each table based on date and department which I use as relation from C to A and from C to B. While I can successfully get the summary from table B I can not understand how I can not get from A. The field from A gets the total of B instead of its own. Table A Table B Table C field1=department field1=department field1=date field2=product unit code field2=product unit field2=department field3=quantity product unit field3=quantity field3=getsummary tot department on A field4=date field4=date field4=getsummary tot department on B Table A and B may look the same, but in A the product unit exists only once changing its department every time as it moves forward showing where it is at that moment. On B, the product unit will have as many instances as many times it has moved, keeping track of its movements on every stage. Any idea what I might be doing wrong?
  8. Hello I am experiencing a strange issue with custom menu and CTRL+F keyboard shortcut when changing keyboard layout to albanian. The custom menu is basically a copy of the default menu with some items left out, not the view mode though. But when I press CTRL+F nothing happens. If instead I go to the view menu and click on find mode it switches to it and I can see the CTRL+F shortcut on the side of the menu. Also, if I first go to layout mode by pressing CTRL+L then it works by pressing CTRL+F but will not work back again. If instead I switch to the default menu, all works fine. Issue is verified on two PC, both with Windows 7 and FM11
  9. Well, I am not gonna revisit this script again in a long time and probably will forget the logic behind it . Having a field which will show the result of the calculation will help me remind about it.
  10. I think I am getting there. For the calculation of folder name, I used the formula suggested by @comment. Great tip Then searching and testing, after some time of both, managed to come with a script with send event in it which creates the folder from there. Script steps: set variable [$path; value:"D:\Docss\FileMaker\GestProduzione1\\"] # here "Table" is the table of FM and "Make_Folder_prev_month" is the name of the calculated field send event ["aevt"; "odoc"; "cmd.exe /C MKDIR " & Quote($path&Table::Make_Folder_prev_month)] One thing which I don't understand (and I hate it) is why I need to add a backslash at the end of the value of $path variable. Is the extra backslash to indicate end of the string? Shouldn't be enough a quotation mark? Thank you both for great input. Very happy with it.
  11. Thank you both, great contribution I chose to export it into a cmd or bat file because obviously I am not that good to figure it out by the send event :). I will try some more and let you know, it's late around here and will try it tomorrow
  12. Thanks Wim for your reply I tried it and it won't create the folder. See, this character is somehow inserted in the file. I can not see it when I open it with notepad, but when i try to execute it within cmd window it shows up. Even if try to execute the date.cmd file by double clicking it won't create the folder. Funny thing is that if I manually copy the content of the field from FM and paste it in the cmd window it will execute normally. This character is inserted during the export. I have defined the field, in the language option as unicode.
  13. Hello I am trying to automatically create subfolders in Windows which should be named year_month, like 2016_11, 2016_12 and so on. This will be done once the month has passed, probably around 10 to 15 of next month. For example, on the 15 of November 2016 a folder named 2016_10 has to be created. I have managed to create a calculated field which content is exactly what I need. Below is the calculated field: "md"&" "&( If ( Middle( Get ( CurrentDate );4;2)="01" ; (Middle ( Get ( CurrentDate );7;4)-1)&"_"&"12" ; Middle ( Get ( CurrentDate );7;4)&"_"&Right(0&(Middle( Get ( CurrentDate );4;2)-1);2))) Then, a script, exports this field content into a file "date.cmd" in the folder I need to and is set to automatically open it. So, what I expect is command line file which simply has as content "md 2016_10" and when executed it should create the folder. Thing is, it doesn't. When I open cmd and execute from there the created file, I see that there is a black square character preceding "md", thus cmd responds with " '■m' is not recognized as an internal or external command". I suppose that is some character added in export, during translation from field content of FM to the text file of windows. Any idea how to solve this?
  14. Import XML how to

    Thank you @comment for the sample. I will play a little bit and come back with some results if I can
  15. Import XML how to

    I didn't wanted to bother you guys with an attachment. It wood look like I am looking for you to do my work Since you asked, I am going to attach it. I deleted a great part of the file, because it is really big. If you open it in Excel you would have a better understanding of what the fields are. Thank you all for your replies. As I understand, first I need to learn the XSLT language, but I should understand the FMPXRESULT as well, right? To have a better idea, the XSLT is a file whihc tells FileMaker where to pick the fields from the XML, or it does transform the XML into another XML understandable for FileMaker? Is one XSLT file enough for many XML files, or would I need an XSLT for each of the XML files? 2015-01-11_Arbane1.zip

Important Information

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