Robby

In March Soliant Consulting published Sara Severson's excellent script for dynamically filtering portal results as users type into a global field: http://www.soliantconsulting.com/blog/2013/03/dynamically-filtering-filtered-portals I too had the impulse to display a count of the results, and added two lines to her script to set $$Filtered_Portal_Count as the filter is updated: Between Sara's two lines: Set Field by Name [$field ; Evaluate ($field)] // Refresh portal without flicker Go to Object [Object Name: $filter] // Return to global filter field I inserted: Go to P

From "Triggered" Script B, I want to "Resume" Paused Script A. But putting a "Pause/Resume" step in Script B Pauses Script B rather than "Resuming" Script A. The only Script B step I have found that will end the Pause in Script A is "Halt Script." But this discards Script A's local context (variables, original layout, etc.), requiring "globalization" of Script A's context if I want Script B to "complete" Script A's steps before Halting. Am I missing another approach (without Plug-ins) to a Script B completion of Script A's Pause? Here is my understanding: If Script A contai

Michael, Thank you for posting. I am sorry for the depth of offense you experienced in this thread. As you will see in the attached file, I too developed solutions for this, one scripted and the other using a recursive function. The algorithm is quite simple: - identify the longest running match between the two strings, using the first of multiple matches as a tie-breaker. - If there is such a match: --- Recurse by comparing the text from each source which precedes the match. --- Pass the match through without modification. --- Recurse by comparing the text from each s

Vaughan, You wrote: Thank you for this insightful observation. At present my Filemaker involvement is as a hobbyist who has the luxury of exploring possibilities rather than a professional who has to produce results, even though I hope eventually to produce something useful. So the question of whether a single Filemaker solution can be made to act like an application is like a mountain that beckons me to climb it, regardless of the impracticality. As I tinker to refine my basic accounting solution through real accounting work with multiple independent sets, I find da

Vaughan, My accounting implementation involves a complex grid for each financial "entity," which tags each of potentially thousands of transactions per year by: year, cost center, bank account, period, entry, and account, with summaries available across multiple matrices of time and account. To avoid bogging down with Filemaker's automated summaries, I have taken to maintaining summaries manually with event triggers, which adds to the overhead complexity. All of this seems complex enough without the additional complexity of handling the isolation of multiple, unrelated data sets

Vaughan, I wrote: You suggested: I appreciate your willingness to push back on my assumptions and offer alternatives. I perceive several barriers to a web-based application: - Many of those I want to assist are scattered in locations where internet access is still non-existent, and for all practical purposes may continue to be indefinitely. - The range of accounting novelties which I want to make available have not, to my knowledge, appeared in any inexpensive version of accounting that I know of. - I have decades of experience in Filemaker from when I was a

My primary "application" use at this point is accounting, with completely different sets of financial records, each involving at least two related tables.

Vaughn, You wrote: I'm in the penny pinching world of faith-based non-profits, and am wanting to produce compiled solutions from a simple Pro Advanced that can be given away to thousands of people and organizations that would never spring for the cost of a client. However even where the end user will pay for their own copy of Filemaker, there may be some benefit to enabling Filemaker to act more like an "application" which can work transparently on multiple independent data sets.

theTominator, You wrote: Thanks for suggesting this alternative. I have not delved far enough into XML to consider it, but may check this out.

I got as far as "proof of concept" using AppleScript to manage aliases, then had to turn my attention to other things and haven't gotten back to it. As I recall: - Separate your Data from your Program - Store the Data file in a global container field in your program as a source for new files - Change the name of your Data - Create an alias to your real Data under the old Data name - Export new copies of the Data as necessary - Shuffle aliases using AppleScript to have your "Program" open the right Data - Perhaps use a helper FM file to close your "Program" and open it again

Aholtzapfel, thanks for your interest. What I have is working: a runtime file and a Filemaker file alternately accessing the same runtime datafile, which is stored on a central "server." The access of both the runtime and Filemaker file is through respective aliases to the runtime datafile. My original problem, which I think I solved last night in my sleep, is how a Filemaker "app" can select from multiple alternate "data sources" without hitting the "File not found" message before it allows the user to identify the desired "Data Source." I think the solution is to let the user

James, thank you for your reply. I was beginning to fear that the Data Separation forum was dead. I have found what I am trying to do quite useful just on a single computer, as I continue refining an "accounting program" which I use to manipulate a variety of independent data sets. I have also found I can use the same technique to provide my daughters a compiled program that accesses their financial data through an alias to a file on a central "server" (a 400MHz iMac), which I can then also access from my Filemaker when they aren't accessing it. In their case, since they each on

I would like to create and distribute a "separated" runtime solution which acts like an "application" in enabling the user to manage multiple independent data sets with the same logic. Each independent data set would start as a clone of the Data Source listed for the data file side of the separation model, and the logic file would be directed to link to the appropriate data set upon opening, so the user would need to quit the "application" and reopen it to work with a different data set. Ultimately I would like to keep a list of recent data files the user has accessed with this Filemaker

Has this problem been solved? Is a recursive function to do this publicly available?

Thank you for this suggestion, but splitting the script is exactly what I was hoping to avoid as that would require turning local variables into globals (or some equivalent) that would reduce the portability of my script.