Cleveland Consulting Support Forum

Custom Functions :: Registry function

Author: Pat_rick
Subject: Registry function
Posted: Fri May 02, 2008 5:49 am (GMT -9)
Topic Replies: 0

Good day everyone

i was just wondering if, from FileMaker, i can look for a specific key in the registry to see if it exists or not. Add litle code that says if found =1 else =0.

I dont know if anyone every came across this, but it would hlp me out in geting FMP to trouble shout for me if maybe im missing that key and require to activate it.

Thx

General Support :: RE: Finder Scripts

Author: Court Bowman
Posted: Sun Apr 20, 2008 5:31 pm (GMT -9)
Topic Replies: 1

Your use of the term Finder is a bit confusing, as that is what the Mac OS calls the application running as the graphical layer of the OS. The desktop if you will.

However if I understand you correctly, you can use insert calculated result to insert the local variable you have defined into a field in find mode.

I hope that helps.
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

General Support :: Finder Scripts

Author: glhein
Subject: Finder Scripts
Posted: Sun Apr 13, 2008 11:54 am (GMT -9)
Topic Replies: 1

Can I have arguments in a Finder script function? This script doers what I need done but I have to define the $trip and $pref manually. It would be really nice Finder would use that arguments. If I specify the arguments in Finder they show as text.

Show All Records
Set Variable [ $trip; Value:1 ]
Loop
Set Variable [ $pref; Value:1 ]
Loop
Enter Find Mode [ ]
[ Pause ]
#How can I make $pref and $trip be arguments to the Find?
Perform Find [ ]
Enter Browse Mode
Pause/Resume Script [ Indefinitely ]
Set Variable [ $pref; Value:$pref + 1 ]
Exit Loop If [ $pref ≥ 7 ]
End Loop
Set Variable [ $trip; Value:$trip + 1 ]
Exit Loop If [ $trip ≥ 15 ]
End Loop
_________________
ghein

Custom Functions :: RE: Finding duplicate values using a custom function

Author: Court Bowman
Posted: Sun Apr 06, 2008 12:57 pm (GMT -9)
Topic Replies: 3

Greetings,

There is a custom function on the site here:

http://www.clevelandconsulting.com/support/viewtopic.php?t=54

it gets the count of each word in a field. It could easily be reworked to accomplish your goals I think. If you run into troubles, let us know and I can work something up.
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

Custom Functions :: RE: Finding duplicate values using a custom function

Author: kbernstein
Subject: A relationship will not work
Posted: Thu Apr 03, 2008 1:14 pm (GMT -9)
Topic Replies: 3

That is a good idea, I considered it but it will not work for my needs. I need to check for duplicates within a found set. The relationship will relate to records that are within the found set or part of the entire table.

I need to check for duplicates within a relatively small found set, so I do not think the speed or 10,000 recursion limit will have an affect.

My table of records will have duplicates. I just need to make sure that a found set within that table does not have duplicate, that is why I need to check.

Thanks for posting.

Custom Functions :: RE: Finding duplicate values using a custom function

Author: Ender
Posted: Thu Apr 03, 2008 1:07 pm (GMT -9)
Topic Replies: 3

It seems easier to use a relationship to a second TO of the table to locate duplicates:

Table <=> Table 2
Table::TableID ≠ Table 2::TableID
AND Table::Field = Table 2::Field

Use a calc to report the presence of a duplicate:

If(Table 2::TableID; Field; "NotADup")

If you want a list of them, you could then use a List() or recursive CF to put them all together.

This should perform much better than a CF that has to check every other record for a duplicate recursively (I think the recursive CF would take O(n^2) time, and would have significant limitations on the number of records it could process).

Custom Functions :: Finding duplicate values using a custom function

Author: kbernstein
Subject: Finding duplicate values using a custom function
Posted: Thu Apr 03, 2008 10:17 am (GMT -9)
Topic Replies: 3

This is a great place/forum to learn about custom functions. I have used a lot of the posting here to gather my knowledge about this powerful FMP tool. Thanks for providing this superlative resource about CF

In various places there is outstanding available custom functions that eliminate duplicate values in a list of records. I am trying to do something a little different, leaving me a bit stymied.

I would like to use a custom function to loop through a found set of records and detect a duplicate value in a text field. The result of the custom function would be a listing of those values that are duplicate. If There are no duplicates the result would be blank.

A sample file is attached that contains the below.

Lets say I have a found set of 5 records

Apple
Pear
peach
Pear
Grape

I am looking for a result that shows:

NotADup
Pear
NotADup
Pear
NotADup

I want the custom function to compare itself to every other found record (except itself) to test for a duplicate.

Here is my flawed CF as it stands now:

Let([

TotalNum = Found;

CurrentNum = Found;

TestNum = Found;

CurrentRecord = GetNthRecord(Field;$CurrentNum);

TestRecord = GetNthRecord(Field;$TestNum)];

Case(

CurrentNum < 1;

Case(

TestNum < 1;
Found & DupCheck(Field;CurrentNum - 1);

CurrentNum=TestNum;
DupCheck(Field;TestNum-1);

CurrentRecord = TestRecord;
CurrentRecord & "¶"& DupCheck(Field;TestNum-1);

CurrentRecord <> TestRecord;
"NotADup" & "¶"& DupCheck(Field;TestNum-1);

CurrentRecord

)))

The problem as I see it; using the recursive nature of CF I can only advance one field at a time. I have no problem advancing the "TestNum" variable, but at the end of the first loop, I need to reset the "TestNum" variable back to "Found" and the "CurrentNum" variable to Found - 1. How can I change two variables at one time?

Any assistance would be appreciated, editing this logic or taking a new approach to resolving my DeDuping issue.

Thank you.

Custom Functions :: RE: Date Recursive Help

Author: Court Bowman
Posted: Sun Mar 30, 2008 4:08 am (GMT -9)
Topic Replies: 1

First of all, sorry for the delay in replying, you caught us on a particularly busy week here at CCI.

The simplest approach, which doesn't really need a custom function, is to brute force it. Something along these lines.

Code:

If (

DateFilterField = "Past Two Days" ;
Get ( CurrentDate ) & "�" & Get ( CurrentDate ) -1 ;

DateFilterField = "Past Week" ;
Get ( CurrentDate ) & "�" & Get ( CurrentDate ) -1 & "�" & Get ( CurrentDate ) -2 & "�" & Get ( CurrentDate ) -3 & "�" & Get ( CurrentDate ) -4 & "�" & Get ( CurrentDate ) -5 & "�" & Get ( CurrentDate ) -6 ;

Etc...

)

Try that approach, and let us know if you have any trouble.
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

Custom Functions :: Date Recursive Help

Author: jacobe01
Subject: Date Recursive Help
Posted: Tue Mar 25, 2008 8:06 am (GMT -9)
Topic Replies: 1

I'm looking for a UI field that allows the user to select the following.

Past Two days
Past Week
Past Two weeks
Past Month
etc.

I'm looking for something that allows me to use a exploded date key to filter a portal based upon the above choices.

Example...
I select the past week.

The CF looks at the Get (CurrentDate) Mar 25/2008

Result is
Mar 25/2008
Mar 24/2008....
Mar 18/2008

I'm new to CF so I haven't had a chance to work on this myself. I can't seem to grasp the other examples yet either because some of them are to confusing.

Thanks for your help and in educating me.

What are general rules to CF recursive functions. Any whitepapers out there with a simplified example(s).

Are there places you would use a Recursive CF and places you would not.

My background is in science (biochem/microbiology/chemistry/genetics/medicine)

First post in this forum...so hello to all!

Mike
FMP 9.0 Advanced
Mac OS 10 Panther

General Support :: RE: Advertisement: JAFA Plugin for FileMaker

Author: fmstack.com
Posted: Tue Jan 29, 2008 10:51 am (GMT -9)
Topic Replies: 2

Thanks Court
I'm new to the FM forum spaces.
I appreciate your placing of the ad in the general forum.
_________________
FileMaker <-> Java integrations

General Support :: RE: Advertisement: JAFA Plugin for FileMaker

Author: Court Bowman
Subject: Ads
Posted: Tue Jan 29, 2008 3:48 am (GMT -9)
Topic Replies: 2

Greetings,

Ads are not normally allowed on this forum without prior consent, however I like the promise of your plug-in and left the ad.

Please contact us in advance before placing an ad. I moved the topic to the general forum which would be the appropriate place in any event.
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

General Support :: Advertisement: JAFA Plugin for FileMaker

Author: fmstack.com
Subject: Advertisement: JAFA Plugin for FileMaker
Posted: Sat Jan 26, 2008 10:55 pm (GMT -9)
Topic Replies: 2

JAFA Plugin for FileMaker, http://www.fmstack.com/

JAFA is a FileMaker Plugin that allows Java developers to write Functions using the Java Programming Language.
This means that Users can Script inside FileMaker to your in-process Java components and services.

The JAFA 'Function Provider Toolkit' allows Java developers to code, build, deploy, digitally sign and then sell licenses for their own functions. And, this is all managed within a FileMaker database itself !!

'Function' can mean almost anything Java.
Some functions perform only local processing.
Other functions introduce enterprise-level integrations using transport layers supported by the Java technology stack.

The toolkit has just been released.

If you are interested in using the Toolkit to write your own JAFA functions, then view the 'JAFA Development' pages at

http://www.fmstack.com
You can request a trial license.

If you are interested in learning about existing and in-development JAFA functions for your own use, then view the 'JAFA

Function Provider' pages at http://www.fmstack.com
In the first week, 2 functions have already been released by cybersack.com

-Collections
- NumericSort.

If you would like to get us to perform a FileMaker -> Java integration, using our toolkit, on your behalf, then drop us a line from the 'Contact' page
_________________
FileMaker <-> Java integrations

General Support :: RE: checkbox set control question

Author: catman
Posted: Mon Jan 21, 2008 10:16 am (GMT -9)
Topic Replies: 4

Court,

Very helpful indeed. javascript:emoticon('')

Thanks much.

Catman

General Support :: RE: checkbox set control question

Author: Court Bowman
Posted: Mon Jan 21, 2008 5:30 am (GMT -9)
Topic Replies: 4

Catman,

If you can change the three fields to one field, with three values in the value list, it will likely serve you better, however if you can't for some other reason, there is still an option.

You will need to create a script, and assign it to the field as a button.

The script will simple check the value of the field clicked, set it to the other option, then set the other two fields to the appropriate value.

So for the field positive it would be:

Code:

Set Field - Positive
If ( Positive = "Positive" ; "" ; "Positive" )
Set field - Negative
""
Set Field - Undecided
""

You would have a similar script for the other two fields. Not for the clever out there, there are more dynamic ways to do this with script parameters, but this is the easiest for a beginner to deploy.

Hope that helps.
_________________
Court Bowman, President
Cleveland Consulting, Inc.

http://www.clevelandconsulting.com/

General Support :: RE: Help with conditional color fill

Author: Larry
Posted: Thu Jan 17, 2008 5:48 pm (GMT -9)
Topic Replies: 5

Thanks, I will upgrade to 9.
_________________
Larry