We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Agnès

Members
  • Content count

    46
  • Joined

  • Last visited

  • Days Won

    5

Everything posted by Agnès

  1. Hi All, I am happy to present the FmDynamix project, including cfCall () and #load (), my new 2 custom functions .... In an interest to further test FileMaker more and more ... I tried to give you a presentation of this new method, as explicit as possible, I hope to have succeeded ! You have the description and the presentation here, and take before the file demo : fmx_FmDynamix_Presentation.fmp12 I hope that this file will give you the urge to see this method, I do not think I have view of similar thing I hope that this "modularity" will please you and will give some ideas, feel free to test and give me your comments ! Thanks for your interest Agnès ( and thank you to Google Translate too )
  2. Small reminder for those who want to relax with a bit of calculation and Filemaker;) The files are always open and nobody managed to break the thing Have a good day ! Agnès
  3. I continue and I hope not to bother you ! ( I promise, after, I stop ! ) The number of variable parameters was one of the goals, I just rubbed it to see. We can therefore write functions with a variable number of parameters: A "simple" example : counting a number of occurrences of words in a text, the number of words is variable from one query to another. // cfCall ( CalcCountWord ; #load ( TheText ) & #load ( Word ) { & #load ( Word_2 ) & … & #load ( Word_n ) } ) The settings in green are therefore optional, and their number variable, which does not allow us FileMaker in the native management of the custom functions. The code is put directly into ExpressionCode of cfCall() and the #load() are added as much as you want. ( Max, 400 ) cfCall ( "Let([ $sep = \"-\" ; $text = $fmxLoa_P[GetValue ( $fmxCal_P ; 1 )] ]; Evaluate ( substitute ( \"//\" & $fmxCal_P & \"-\" ; [\"\¶-\" ; \"])\"] ; [\¶ ; \"]) & $sep &\¶PatternCount( $text ; $fmxLoa_P[\" ] ) ) )" ; #load( "Hello to you, I hope to let you discover the power of cfCall, thanks for your tests ) & #load( "j'" ) & #load( "you" ) & #load( "test" ) & #load( "thanks" ) ) We can write : CfCall ( theCalc ; #load ( theText ) & #load ( Word_1 ) & #load ( Word_2 ) & #load ( Word_3 ) & #load ( Word_4 ) // we pass 4 words either, 5 parameters CfCall ( theCalc ; #load ( theText ) & #load ( Word_1 ) & #load ( Word_2 ) ) // we pass 2 words either, 3 parameters Bonne journée Agnès // more info, file fmx_FunctionCalls, template Custom functions, click the "More" button, go to the "Processing" tab, section "manage variable parameters"
  4. Good A priori, some dare, some not. So, I prefer to repeat myself : The demo file is to download here: fmx_FmDynamix_Presentation.fmp12 The access to the fmx_files is on the FmDynamix page, here and in the file presentation I did not want to do automatic opening because it takes an account name to be able to handle the functions and not break those of others! (And if you break everything, so it's correct for me and I have a backup ) You send a mail for your first connection via the appropriate button and you give me time to open the account in both files and prepare your small DataDemo file that I send you normally quickly. Interest in you, I think there are. For me, it is obvious. Apart from sharing calculations, I want to see the behavior of cfCall () & #load () with a max of type of function, you will well write me a day a function that break the thing ! The other interest, the translations, are also on the principle of sharing. For all those already entered in English and French, anyone can add other languages. The Germans can add the German language, The Italian can put his own too ! Do not hesitate to tell me if you have any trouble, connection or use ! Thanks ! Agnès
  5. Hi, the behavior of the formatting is not the same with Web-direct and GetLayoutObjectAttribute ( NameObjectButtonFromButtonBar ; "isActive" ) don't work with web-direct, may be a bug in the function, button is active but we can't take information Agnès
  6. Hello, Get ( ActiveLayoutObjectName ) don't work but GetLayoutObjectAttribute ( NameObjectButtonFromButtonBar ; "isActive" ) is (presque) ok, but not good if you are ≥2 buttonBar ( ≥2 activButton ) I just work on this problem, formatting can read "self" (button title) and can declare variable with the active object ( v14 ButtonBar ) But with Conditional formatting in v12, v13 and v14, you can take the title of the last clicked button. In v14 and the button bar, you can take the nameObject of the barButton - Last Button clicked Here a link for the demo file ( open for v12 to v14 ) ( not ok WebDirect ) Agnès
  7. View File Setof_Print_Vlight.fp7 And Setof_Print_V1.fmp12Hello, Here is a file that allows - To have a foot in the final page, the very end of the last page. - To manage page breaks and reorganize its document the version fp7 it is the "ligth" version, the version fmp12 ( you will find here ) adds the ability to make pdf via a "robot filemaker" with WebDirect and go one can easily transpose it into any database. Do not hesitate to create records, test and tell me any bugs or curiosity. The file is opened 100% and any feedback is welcome! v9 - v14 Compatible. Thanks Agnès SubmitterAgnèsSubmitted05/15/2015CategorySamplesFM VersionChoose one...
  8. Version 1.0.0

    112 downloads

    Hello, Here is a file that allows - To have a foot in the final page, the very end of the last page. - To manage page breaks and reorganize its document the version fp7 it is the "ligth" version, the version fmp12 ( you will find here ) adds the ability to make pdf via a "robot filemaker" with WebDirect and go one can easily transpose it into any database. Do not hesitate to create records, test and tell me any bugs or curiosity. The file is opened 100% and any feedback is welcome! v9 - v14 Compatible.

    Free

  9. Hello, Is someone used / tested the calculations tab label as calculating layout? I use them for calculations layout, independent of context while waiting for the labels calculated. no field and copy paste, a layout to another. Here are 2 "techniques", the tab label as a calc and the window's UnicVariable for pass text for each windows Part of the demo can be complicated(?) but you can simplify and adapt the way. I do not know if this is the right forum or good technique, do not hesitate ! Best regards Agnès WindowVar_TabPanel.fmp12.zip
  10. Hello, Maybe another approach here Agnès
  11. Hello, I do not understand this in your example, i hope is a mistake : 9:45:00 9:50:00 9:55:00 9:50:00 Perhaps this 2 calc are ok ( used CustomList () ) Calc and result 1 : 9:15:00 9:15:00 9:20:00 9:15:00 9:20:00 9:25:00 9:20:00 9:20:00 9:25:00 9:25:00 9:45:00 9:45:00 9:50:00 9:45:00 9:50:00 9:55:00 9:50:00 9:50:00 9:55:00 9:55:00 10:15:00 10:15:00 10:20:00 10:15:00 10:20:00 10:25:00 10:20:00 10:20:00 10:25:00 10:25:00 Let ([ $L = YourList ; $LV = Substitute ( $L ; ¶ ; " " ) ; $Inter = Time ( 0 ; 5 ; 0 ) ; $N = GetAsTime ( GetValue ( $L ; 1 ) ) ; $T = "" ; $Count = 1 ; $Num = 1 ; $P = CustomList ( 2 ; ValueCount ( $L ) +1 ; "Let ([ V = GetAsTime ( GetValue ( $L ; [n] )) ; I = $N + $Inter ; $N = V ; $T = Case ( I = $N ; 1 ) ; R = Case ( $t <> 1 ; CustomList ( 1 ; $Count ; ""$Count - [n] + 1"" )) ; $Num = Case ( $T = 1 ; $Num ; [n] ) ; $Count = Case ( $T = 1 ; $Count ) + 1 ]; R )" ) ]; CustomList ( 1 ; ValueCount ( $L ) ; "Let ([ V = GetValue ( $L ; [n] ) ; $no = [n] ]; CustomList ( 1 ; GetValue ( $P ; [n] ) ; ""MiddleWords ( $LV ; $no ; [n] )"") )") ) or Calc and result 2 : 09:15:00 09:15:00 09:20:00 09:15:00 09:20:00 09:25:00 09:45:00 09:45:00 09:50:00 09:45:00 09:50:00 09:55:00 10:15:00 10:15:00 10:20:00 10:15:00 10:20:00 10:25:00 Let ([ $L = YourList ; $Inter = Time ( 0 ; 5 ; 0 ) ; $N = GetAsTime ( GetValue ( $L ; 1 ) ) ; $T = "" ]; CustomList ( 1 ; ValueCount ( $L ) ; "Let ([ V = GetAsTime ( GetValue ( $L ; [n] )) ; I = $N + $Inter ; $N = V ; $T = Case ( I = $N ; 1 ) ; $Next = Case ( $T = 1 ; $Next & "" "" ) & V ]; $Next )" ) ) really test before take. I do not know why you do this, but if you have a field with this type of calculation and result, you will have slowness in your database Agnès
  12. Solution: List a Found Set Description: to get data list coming from a foundSet, without CF, with a field calculated unstored the field must be in the table source not on the layout Working Under: list Found Set Solution Status: Beta Author(s): Agnès Date: 08/01/08 Instructions / Other Info: Hello, it is a method much faster than CF especially if the data are sorted. Little slower than copy all the records, but may be more flexible because you can list the various fields. It is limited to 60000 records and I do not know the behaviour on a database It's a test. I tested with 50000 records, and by script for saw the result, and it seems to me really fast. but it is just a file test without much data I do not know if it is a solution, and I would like your critiques and comments. Thanks a lot Agnès Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify. FoundSet_test_V1.fp7.zip
  13. Hello, I would like answer to this topic : CustomList custom function limited to 300 items in list on FileMaker Server Be careful when using the CustomList custom function on FileMaker server. My testing has revealed that the list this function will generate is limited to 300 entries when used on FileMaker Server. The documentation of this functions states that it is limited to 500,000 on FileMaker Pro and 150,000 on FileMaker Go. I had never actually tested on server. I just read this article by chance, I just did the test and saw that the function Evaluate () is the problem ( the same for FileMaker Go ) it is the current limit of FileMaker Serveur internal Evaluate function FileMaker GO Evaluate () is limited to 400 (+/-) FMServeur Evaluate () is limited to 300 (test FMServeur v11 ) instead of 1700 (+/-) for FileMaker. ( runtime and IWP ) I update the calc CustomList for this to work correctly on FMSserver ( http://www.briandunning.com/cf/868 and http://www.fmfunctions.com/fid/118 ) Do not hesitate to let me know by email if you have a problem with CustomList () In this case, I have made test with FMS v11, maybe the limit is different with other versions. Thank you Agnès
  14. Numbers to Words in French

    Hello, You have this one CardinalToText ( Amount ) by Clement Hoffmann Agnès
  15. The Check Box "FoundSet"

    Hello, I never paid attention to this CheckBox. ( script action : Send Mail ) Now that I discovered and tested, I do not understand why FileMaker does not give us this option natively in ValuesLists ? Natively, when you check this box, you get the list of email address (or ... other !) in the mail software... I added a calculation to show. This file "FoundSet_test.fp7.zip" is just to demonstrate that the CheckBox "collect foundSet" is in FileMaker Technically, I do not understand why FileMaker does not offer this feature, Function or CheckBox from the moment that has long existed. (this option is ok in FM6....) It would be sufficient to move the CheckBox .... and we would finally be able to list a found set without using "tricks" I would question it can make things happen ... ? Agnès
  16. The Check Box "FoundSet"

    Thank you for your interest, Difference is timing. Filemaker is very very slow if there are a global or a $ $$variable with lots of line. with a large file, comparing the method 1 (explosion into smaller lots, method given a demonstration by Bruce Robertson)) 10000 records = list obtained in 1 second 20000 records = list obtained in 2 seconds but with List ( $v ; FoundSet::ID ) 10000 records = list obtained in 9 second 20000 records = list obtained in 54 seconds the performance difference is very large case : 27 ExtendVariable[n] with 750 lines vs 20000 lines in one variable But looping take time. I have just conclude is easier for FileMaker to give us a simple solution for collect FoundSet'ID's.... (?) Agnès
  17. Hello, I saw your message, on Brian Dunning'site and I make tests. I found that the difference in behavior for Evaluate(). it is the current limit of FileMaker GO internal Evaluate function FileMaker GO Evaluate () is limited to 400 (+/-) instead of 1700 (+/-) for FileMaker. I update the code in CustomList() it's ok now for FileMaker And FileMaker Go. [and I cleaned it a little] Carreful, as the difference between FileMakerGo End - Start = 150000 max. ( instead of 500000 if it's FileMaker ) There may be other differences. I just tested with tris Also, it now appears to work correctly on FMGo Do not hesitate. Thanks a lot Agnès
  18. Hello, I would like your opinion on this "thing" I call a "malfunction" and not a normal behavior. What do you think ? Thanks Agnès MenuTest.fp7.zip
  19. Strange behavior globale, listing, value list

    an other test an other problem Record 1 is active, you have record 100 to the screen, if you click on the global (it nothing happens ) AND you click on "Refresh record" menu filemaker, the globale disappears ...
  20. Strange behavior globale, listing, value list

    OK, Thanks for the link ! "We've had to create dumb work-arounds just to use the functionality." always... Terrible. Merci beaucoup, I feel less alone with my bug ! Agnès
  21. Strange behavior globale, listing, value list

    Hi LaRetta, thank you for your quick reply ! I never seen this before, I am pleased to read that here he was already known and reported. Do we know if FileMaker says it normal or not? Have you one can know if FileMaker say it's normal or not? Or if they'll fix it ! Agnès
  22. Found Set

    Hello, Just 2 precisions : on the calc of ChargeFoundSet if you change the Field Name (ChargeFoundSet becomes x_ChargeFoundSet for example), do not forget this name change in the calculation between quote (...) Calc = "GetNthRecord ( [color:red]ChargeFoundSet ; let ( $n = $n + 150 ; $n ) ) & $rc &" ; (...) and if you want to use ChargeFoundSet on IWP, it's possible if you put 60 instead of 150 (there are three 150 on the calc ) (...) End = Floor ( Get ( FoundCount ) / [color:red]150 ) ; Calc = "GetNthRecord ( ChargeFoundSet ; let ( $n = $n + [color:red]150 ; $n ) ) & $rc &" ; Eval = Case ( End > 0 ; Substitute ( ( 10 ^ end ) - 1 ; 9 ; Calc ) & """" ) ; CFSResult = Evaluate ( Eval ) ]; Case ( Filter ( CFSResult ; ¶ ) = CFSResult ; "" ; CFSResult ) ) ) & Case ( Get ( RecordNumber ) ≤ 1 or Mod ( Get ( RecordNumber ) ; [color:red]150 ) = 0 ; FieldNameList ; (...) I have not button "Edit" and I can change this first file Thanks, Agnès
  23. Hello, Sorry me again ! I come back ! I tested the accordion with differente views.... I made use of a tab panel, it surely needs accurate interface adjustements, but the result can be I let you click anywhere thank M'sieur Alex ! Agnès MenuAccordeon.fp7.zip
  24. Hello, then, I share my new revised and corrected version I do not really know if it's usable, but it's the air to operate thanks you Agnès TiteFleche_Hierarchie_V2.fp7.zip
  25. Hello, and Thanks for your files. my English is not good enough for any understanding on this topic. but, thank you, 2 files are really nice, but I do not understand why their construction is so complex. Here is an example of construction that I used for my menus, I have a script single dispatch using DoScript, also with external parameters. it's simple it seems to me, I had used the idea of a "Hierarchy" that I found here one moment ago. There are certainly subtleties who I do not understand, thank you for explain to me. Agnès Edit : oh... ok, I think I just understand one of subtleties of Genx file's : the number of lines displayed is always the same, display does not jump, and the main lines go down. Very sorry, I did not understand, I'm out ! but thanks a lot, it interests me very much. TiteFleche_Hierarchie.fp7.zip
×

Important Information

By using this site, you agree to our Guidelines.