5 Replies Latest reply on Oct 4, 2012 7:00 AM by Vincent_L

    Missing Functions


      Here's some new function we're sorely missing and which would allow cleaner code, offer new possibilities, and maybe be faster.


      - a Get(ActiveStatus) function that returns true if the record is the active/selected one. That will allow current line highlighting via a conditional formatting in list view for instance (one that works, fast and realiable, there's plenty of workarounds, but they're slow because they need some slow and unreliable tricks to know if the a record is the active one.


      - Get script call stack (like the script calling stack you see in script debugger). It would return the script file, name, and parameter of the previous scripts as a value list. Empty is returned if no script called this one. Very usefull to know if the running script was called or not, which scrip called it.Etc, very usefful for logging, and error toubleshooting


      - a Get clipboard content This will retrieve the content of the cliboard, text if text field, container if container field


      - Native, unlimited, ultra-fast equivalent of the GetNthRecordSet ( fieldName ; recordNumStart ; recordNumEnd ) custom value. Yes there's EsxecuteSQL, but unfortunately it's much slower !


      - Get last exported file filepath / last imported file filepath. Run after a import or exports  records/fields that ask the user to choose the file/folders (no specified files), they'd get the file's filepath of the file/folder choosed by the user.


      - Get(RecordOpenCount) that works : that gets all the uncommitted records (list of their record_id) of the hosted database by all users. Very usefull to avoid issues due to locked records when importing, replacing etc.


      - List without duplicate values (a value list replacement). Ok now the ExecuteSQL can do it, but Execute SQL is unfortunately slower than nativ Filemaker functions.

        • 1. Re: Missing Functions

          Some really good suggesions...

          • 2. Re: Missing Functions


            Here maybe some workarounds for you:

            Get(ActiveState)   - use a single script step on list view layout (set to trigger onRecordLoad) that says Set Variable ($$RecID : Value (GetRecID) )

            Then you create a layout box with the exact size of one row, place that under all your fields and add conditional formatting when $$RecID=GetRecID to change color.


            Get Clipboard Content: I would never take a users clipboard w/o explicit consent, so either you make a field with the data you want to send to the clipboard and add that step as a button, or you should work your way around it using global or script params. E.g. is if the user wants to copy a calculated address label to another program, there is a button to do that.


            List w/o dupl: check out the CustomFunctions at BrianDunning.com, there is a ton of valuable custom functions


            Some of your other suggestions I would like to have too!

            • 3. Re: Missing Functions

              Hi psijmons,


              Thanks for those tips, but I know them all, the preciseley the point is to AVOID those workaround because they're much slower than native function.


              Clipboard consent, of course, you may pop a dialog or not that's our chose that does not means we shouldn't get the function.

              Or we can have an explicit logo. All programs on eart allows copy and paste, filemaker shoudl also


              No users can't copy not enterable in browse mode fileds, there's no button for that. If you can't enter a field your can't copy it that's stupid.


              About CF, tjhose covering basics needs like that and can work on big data sets are calling for being native. FM Inc should have a team dedicated to convert most popular CF, because if they're so popular that's because the feature missses.


              Not only for performance, but for newbie undesrtanding and plattform accessibility then they shoudl be native

              • 4. Re: Missing Functions



                I have 2 more:


                - List for foundset


                - Perform Script by Name (calculated) / well ... this actually a scriot step, but still...

                • 5. Re: Missing Functions

                  Thanks hbrendel,


                  actually your two more are already in my posts :-)


                  List for foundset = native GetNthRecordSet


                  - Perform Script by Name (calculated) / well ... this actually a scriot step, but still... : it's on my missing script step post because that's a script step :-)


                  But thanks for teh support