Jump to content


  • Posts

  • Joined

  • Last visited

Lashex's Achievements


Rookie (2/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. The only tiny difference is that this will explicitly open Safari.
  2. OK this is not what I was specifically trying to do so my question still stands; however, I figured I would share this AppleScript code. This code is what I currently use as a FM Calculated Applescript to open a Google search page in the Safari (MacOS X) browser. The search query is comprised of text from fields in the database which are used as keywords. "tell application" & ""Safari"" & ¶ & "make new document at end of documents" & ¶ & "set URL of document 1 to "http://www.google.com/search?hl=en&lr=&c2coff=1&client=safari&rls=en&q=" & FooTO::BarData & "+" & FooTO::NeetData & "&btnG=Search"" & ¶ & "end tell"
  3. I would like to click on a button in Filemaker and send text from a field to the Google Search WSDL-defined web service. I would expect the behavior to be similar to the "Open URL" action and open a window to show the results of the invocation.
  4. Trying the more complex script that is avoiding a gglobal only seems to create records as follows: WidgetID Date Type 1 mm/dd/yyyy 12-34-56 2 12-34-56 3 12-34-56 ...notice that only the first record actually has the entered date captured. I'll play around a bit more to see if I missed anything in your example.
  5. OK here's my final functioning DB example. This behaves the way I originally desired. I had to use a global to pass the date to each record versus having each history record default to the creation date. If you have a suggestion on how I might avoid the global I would appreciate hearing it; in any language/environment I try to avoid globals. Thanks for all the help folks. Widget-Test.fp7.zip
  6. OK after looking at your example I do see how you're using the Portal capability. I've actually played with doing that method earlier. The portal approach would work if I had the screen real estate. Unfortunately my desire is to simply press a button to "Add History Item", the button then fires a script which adds a Historic Date record in the History table for the current Widget. Also I would then like to have a button "Add History Item to All" that fires a script which would add a Historic Date record to all existing Widgets. I've attached an example of what I am trying to do. I have the two buttons: -- "Add Fertilize" which equals "Add History Item" -- "Fertilize All" which equals "Add History Item to All" ...neither of which either work, or work the way I want them to. As before, I continue to appreciate the help. Widget-Test.fp7.zip
  7. As the "Indexed, Lookup" aspect of the ID is simply something I have done while learning FileMaker I appreciate the feedback. I'll review your attached example and see if I can do what I need to do from it. Thanks.
  8. Thanks Fenton... I appreciate the positive thoughts. To your point I only included my other experience so someone might be able to help me translate my frutration using a language (or concepts) someone might share with me. Now, the question of "what am I actually trying to do?" is of course a good one for helping others know how to help me. I don't purport to be the best arranger of Filemaker tables, but here's where I am at. One table "Widget" collects all non-historic information about a widget; widget name, widget source, etc. Another table "History" collects multiple historic records about widgets; modified date one, modified date two, etc... Each historic record has History::WidgetID that is an Indexed, Lookup field to the Widget::WidgetID. Goal: Add a new corresponding history record for all Widgets Goal: Add a new corresponding history record to each member of a found set of Widgets Goal: Eventually show a historic report about how many times and on what dates each Widget was modified. Since my initial post, instead of my Max(Widget:ID) reference I've added a Widget::WidgetCount field which is a Summary field that stores the maximum WidgetID field of the Widget table. Furthermore, Goal #3 is why I cannot simply replace previously existing data. Again, thanks for any and all help.
  9. I am trying to figure out how to perform the following straightforward task. I'll use pseudo-logic to describe my question. loop until count > Max(FooTO::ID) Add New Record to BarTO SetField BarTO::Date of new BarTO record to Current Date count++ end loop BarTO::ID is a "looked up" relational value (I think of it as a foreign key) from FooTO:ID. Any and all help will be appreciated. p.s. I have to say... I'm a newbie to Filemaker 7 but so far it is the most non-intuitive (sometimes even counter-intuitive) data and coding environment I've ever worked in. I have experience with C, C++, JavaScript, Java, J2EE, SQL and AppleScript if that helps with any mental transformation suggestions on how to thing in the FM7 world.
  10. Thanks. I don't know if it is a best practice or not, but that worked. I'll stick with this unless anyone else has a better suggestion.
  11. I would like to perform the following task: From my main entry form while entering data into JunkTO, I want to push a button and add a new record to a history table. The current record's JunkID should be used to auto-populate the JunkID in the history table. Here's the detail... << Italic = field, Bold = Table, Underline = TO >> JunkTO is over the table JunkTable and has a number field JunkID and a text field JunkDescription JunkHistoryTO is over the table JunkHistoryTable and has a number field JunkID and a date field JunkHistoryChanged The two TO's JunkID fields have an "=" relationship between them I have tried setting up a portal field on my JunkTO main entry form exposing the JunkHistoryChanged field. However, when I edit the JunkHistoryChanged portal field the JunkID in JunkHistoryTO does not get auto-populated with the value from the JunkTO JunkID field. I also can't seem to create a new record in the new table from the entry form I am on no matter what I try. I've been trying some scripting commands... argh.. but I am completely lost. I've created an example file with the relationship in it and attached it in case my text description isn't quite clear. Any help is appreciated. JunkTest.fp7.zip
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.