Calculation Storage / Indexing

[jptrue]

Is it possible to have a FileMaker calculation field, which utilizes a ScriptMaster External Function, store the resulting value for indexing?

I seem to be unable to make this happen.

Any help would be greatly appreciated.

Thanks,

Jeff

[Jesse Barnum]

This should work like any other calculation. What is the problem that you're having?

[jptrue]

Thanks Jesse,

I have a calculation field using:

Right ( SCGetFileURL( ""; "//myserver04/c$/Users/SuperContainer/"; "Files/DATA/resume/" & candidate_id & "/" );

Length ( SCGetFileURL( ""; "//myserver04/c$/Users/SuperContainer/"; "Files/DATA/resume/" & candidate_id & "/" )) -7

)

The calculation works great. However, When I click on "storage options...", and uncheck "Do not store calculation results", the calculation no longer works. No error is returned either.

Thanks again,

Jeff

[Jesse Barnum]

Can you be more detailed when you say "no longer works"? Is it returning a blank result? Is it just not updating? Is it a question mark?

[jptrue]

Sure,

It returns a blank result.

Thanks again,

Jeff

[jptrue]

OK,

Did some more troubleshooting/testing.

When I use this calculation(and try to store the results), the result of the calculation is "?":

SCGetFileURL( ""; "//myserver/c$/Users/SuperContainer/"; "Files/DATA/" & candidate_id & "/" )

When I do NOT try to store the results, the calculation performs as expected.

Thanks,

Jeff

[Jesse Barnum]

Ah, I think I might know what's causing it. This is hosted on FileMaker Server, right? It's because when you change it to a stored calc, that calculation is evaluated ON THE SERVER for all existing records. I'm guessing that you don't have the plugin installed on the server, which causes the ?. There are two solutions for this:

1) Install the SuperContainer plugin on the server, change the calc back to unstored, then change it to stored, and the server will update everything correctly.

2) Don't install the plugin on the server. On a connected client computer with the plugin installed, do a calculated replace on the 'candidate_id' field, and replace it with itself. This will trigger the calculation to re-evaluate for each record on the client. You can try this before doing the replace on all records by just re-setting that candidate_id field on a single record to see if it is fixed.

[jptrue]

Genius!!

That did the trick.

BTW I presented the FileMaker Solution to my internal clients yesterday to much fanfare.

Thanks for building such a great product.

Thanks,

Jeff

[Jesse Barnum]

Excellent! Glad to hear it :-)