Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

jageo's Achievements


Apprentice (3/14)

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

Recent Badges



  1. I know this is an older topic, but I came upon it through a search and thought to add my latest results after toying with this idea this afternoon. Am working with FMP12.0v2, and can run script including passing variable values via the URL There were several times it pooped out and didn't tell me what went wrong, but I did eventually, repeatedly, successfully launch and run remote DBs on my local network using the structure like this: fmp://username:password@ /databaseName?script=scriptName&$variableName=x I read and used mostly what was found here: http://help.filemake.../7786/related/1 but made what I presumed were logical changes based on using FMP12 and not FMPGo The only bit I couldn't get to work was including "param=TopClients&" but I wasn't trying very hard once I had $variable working. I think I had something wrong in my script instead. I presume it would have worked as presented in the FMGO documentation if I pursued it further JA
  2. Thanks for the reply John. I will script some buttons and start navigating with them.
  3. My sketch would consider the three tables as: SongTitle (fields: ID_Song & Title) Recording (fields: ID_Rec, fk_Song, fk_Album) Album (fields: ID_Album, Title,Release Date, etc.) Recording being the join table. (Where, if useful, you might consider putting a field for Guest Vocalist, since it relates to the Recording of the Song, not the entire Album, nor to the Song Title) I would think a join table would be needed because a SongTitle could be recorded more than once, and appear on more than one album. And Albums have more than one song. So you have that Many-to-many relationship to resolve. You wouldn't need to have any lookups, just portals. And you wouldn't need a foreign key the Album table. For data entry your user enters Recordings, assigns a SongTitle (if it already exists or makes a new record if it doesn't), and assigns them to an Album (if it already exists or makes a new record if it doesn't) Creative use of other portals could show other Albums that share that recording's SongTitle. Another could show other Recordings on that related Album. Do you think that might be close to what you want to achieve? JA
  4. Is it possible to display in a list view layout a restricted number of records without having to do a find first? For example (attached) I have one base table called Data, and for the sake of simplicity it has one field, an ID field. There's 20 records, and they range from 1 to 20. And there's a global field called g_Ten, with the value "10" I have a table occurrence called AllData and a table occurrence called LowData. It's a self-join and the relationship graph I have the equation LowData:ID < AllData:g_Ten Layout 1 shows records from AllData. Layout 2 is set to show records from LowData. I expected that this would mean Layout 2 would only show me records with ID values from 1 to 9, but instead is shows me all 20 records. Can someone explain how to get this desired result? I don't want to use portals in this particular solution. I'd rather not have to do a find first and then go to Layout 2. But if that is the proper solution I will follow it. If it helps to understand the issue here's the real purpose for the question. I have a database watching project progress through a system. It has a Status field, and as a certain task is completed the Status is changed to a higher number. I wish to have a layout that shows, in list form the projects with status 1, a layout for status 2 etc. I don't want to use the same layout and do a simple find because users need to see different things about the project as it goes from one phase to the next. many thanks, JA
  5. That's what I need. Many thanks. Talking my way through understanding: 1) cTrue in your CustomerTable is a calculation as opposed to an auto enter because that is the easiest/safest? 2) Is it logic or just convention that has you create the self-join where the constant (cTrue) in the "All Customers" table and the variable (Active) is in the Table Occurance. Would it work the other way around? 3) I'm not sure why the value list is defined as 'using the values from the ActiveCustomer table' but where you indicate to include only related values you choose the 'Customers' table. JA
  6. Table called "Order" has fields "Serial#" and "Name" and a global field "ActiveYes" which is auto enter set to equal 1 Table called "CustomerList" has fields "Serial#" and "Name" and "Active" The table is filled with customer data and "Active" is set to 1 or a 0 (to tell if the customer is active or not) I can successfully make Order:Serial# pop up a value list showing ALL records from Customer:Serial# but I can not make it show me only the Active customers. Following the instructions in Filemaker's help files, and creating a self-join works only if you are popping up a value list from field in the same table. How do I make it work across related tables? If anyone can direct me to a solution it would be much appreciated. Many thanks, JA
  7. No, I'm 7.01. I will upgrade and try the same thing again. Thanks JA
  8. Ok, if i did this right there should be a .sit file attached. A small database and an example of text file I'm using to import. If you import using the settings in screen shot one, Field4 will not fill itself in. If you import using the settings in screen shot two, Field4 will fill itself in. JA
  9. I'm not so sure. If Field2 is the one I need to match on and Field 2 is also the vital field that all my calculations inside the database are based on, then I'm screwed. (Luckily in my practical application I can use the Field1 and Field3 to match on.) But, does it make sense that Filemaker won't do the calculations based on the data imported in this field if it is used as a match field? And why? What good thing does it serve that I am missing? JA
  10. Here's more info as I've messed with the import window. When I import with update matching records turned on: if I have the = sign next to Field2, telling it to match records based on this field, Field4 *will not* perform its calculation if I have the = sign next to Field1 and Field3, then Field4 *will* perform its calculation JA
  11. Riddle me this... If I set up a database - Field1, Field2, Field3 with one calculation Field Field4= LeftWords(Field2;1) and one auto-entry Field5 : auto enter serial number and import a text file with 3 CSV fields If I do a plain old import, add new records, perform auto entry then the text comes in as expected. Fields 1-5 are all filled in. If, however, I do an import with "update matching records in found set" (where I have all records showing) and have "add remaining data as new records, things don't import as i would expect. Field5 does auto enter a serial number, but Field4 does NOT calculate, and does not fill in. I very much need it Field4 to do its calculation. What am I missing?
  12. That is part of the problem i was trying to solve over here. 3 fields plus the file name, exactly. post from applescript forum I have only Filemaker 7 to work with tho' and needed to use applescript to perform a few other functions along the way. JA
  13. I have a project where I need to import information from text files that contains lines and lines of 3 comma separated values. I used this thread to get most of the way there. Link to earlier thread but then the customer said that the filename of the text file needed to be included as well. After much thought I came up with this solution below. Feel free to comment on any clumsy code, or potential pitfalls. The script looks at an "in" folder, and works its way through the list of text files available. The text in the file is written to temporary file and at the end of each line the filename is added (to make a fourth field). The applescript launches a Filemaker script to import the text. Then the applescript wipes clean the temporary file and goes on to the next text file. What I still need is a more graceful way to keep the applescript from moving ahead before the Filemaker script is finished importing. The delay 15 is clumsy. Any suggestions? set watchedFolder to (path to desktop as Unicode text) & "watched folder:" set importFolder to (watchedFolder & "New Manifests:") as alias set doneFolder to (watchedFolder & "Imported Manifests:") as alias set picFolder to importFolder as Unicode text tell application "Finder" try set picList to every file of folder picFolder as alias list on error number -1700 set picList to first file of folder picFolder as alias as list end try end tell repeat with eachFile in picList -- picList contains aliases, so need for 'file' before 'eachFile'. set myData to (read eachFile as text using delimiter return) set howMany to count of items in myData set fileName to name of (info for eachFile) try copy (open for access file (watchedFolder & "ImportMeNext.txt") with write permission) to fileRef repeat with i from 1 to howMany write (item i of myData & "," & fileName & return) to fileRef end repeat close access fileRef on error close access fileRef end try tell application "FileMaker Pro" activate do script "Import Script" end tell delay 15 tell application "Finder" activate --- try move eachFile to folder doneFolder on error set name of eachFile to ("1" & fileName) move eachFile to folder doneFolder end try try set myFile to (open for access file (watchedFolder & "ImportMeNext.txt") with write permission) set eof myFile to 0 close access myFile on error close access myFile end try end tell end repeat
  14. it's beautiful. it works. is there a name for this... something that I can look up in the book. I'd like to understand more about how/why it works and how else to apply it. It seems counter-intuitive to put what seems like two values into one cell. JA
  15. Am having difficulty wrapping my brain around this one: I have 300 newspapers uploading files to a central archive. The archive sends me a manifest of filenames each day telling me what files they received. I import this manifest into my database and through calculation fields pull apart the filename so i can keep track of what paper sent their files, and when. For example: the Fictionville Fiction uploads a file called "fifi_20050909_A32_32.pdf" and I can pull out the code "fifi" and have a relationship to my newspaper database that says code "fifi" = the Fictionville Fiction The One-to-Many relationship is where the field "NewspaperCode" in the Newspaper Table = the field "FirstWord" in the Filename Table However,for complicated reasons beyond my control, some papers have two codes, the same paper can also upload "ficfic_20050909_A32_32.pdf" and still be accepted by the archive. How can I set up a relationship between the filename table and the newspaper table where the field "FirstWord"(in filename table) could match "NewspaperCode" or "NewspaperCodeNew" (in Newspaper table)? And what if (mutter, mutter) a newspaper were to change its code. If I were to change the reference in the Newspaper table, I would lose the connection between that paper and all it's previously uploaded files. There must be some different way to approach this. If the newspaper table had a serial number assigned to each paper instead of a code .... how can I have the filename table check different codes to make the relationship to the serial number? should there be some sort of table in the middle? One that has a listing of all the possible codes and the serial numbers that they relate to? JA
  • Create New...

Important Information

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