Jump to content

The Sparrow

  • Posts

  • Joined

  • Last visited

The Sparrow's Achievements


Rookie (2/14)

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

Recent Badges



  1. Ender, thanks for the reply! the script you suggested is working perfectly. i understand the logic in it. only had to make one tiny change. had to change from Perform Script [Find Script] to Perform Script [sub-scripts, Find Script]. otherwise it was exactly what i needed. also, was able to reincorporate a prior complexity that was causing problems before i took the new approach. thanks again, Sparrow
  2. thanks for taking the time to reply. issuing a Show All Records only seems to buy me one more round. now i can enter two artists in a row that are not in my database and get the opportunity to Modify Find both times. if i enter a 3rd artist that is not in the database, it goes to the blank Artist Report w/ no chance to Modify Find. anyone know why it is exiting the script? surely there is a way to set it up to where it doesn't matter how many times in a row No Matching Records are Found. again, i am wanting it to give me the chance to Modify Find over and over and over again if necessary. otherwise it is not too user-friendly.
  3. for those who read my previous topic "issue with script that has multiple finds", ignore all of that. i have boiled the problem down to one simple question... here's my script: Go to Layout ["Artist"] Enter Find Mode [Pause] Perform Find [Replace Found Set] Go to Layout ["Artist Report"] Sort [Restore, No Dialogue] The Artist layout is a simple screen that says "Enter an Artist" and only shows the Artist field. After you enter the artist you want to search for, it performs the Find and displays the results using the Artist Report layout, which includes the YEAR, TITLE and FORMAT fields. For example, if you were to type in Eric Clapton, you would see all of the Eric Clapton albums I own. You would see the Year, Title of Album, and the format I have (i.e. CD, Cassette, Vinyl, etc). When you enter an Artist that is not in my database, of course it says No Matching Records Found and you choose between Modify Find, Continue or Cancel. If I click Modify Find and enter a 2nd artist and that artist is also not in my database, instead of getting to Modify Find again, it goes to the Artist Report layout as though records were found. There just aren't any records listed. It's blank. All you see are the Field Names (Year, Title, and Format). It seems like I should be able to enter an unlimited number of artists that are not in the database and always be given the chance to Modify Find, no matter how many times in a row No Matching Records are found. Is there something special I need to do in the script? Do I need to set up a loop that runs until records are found? I'm baffled! any insight on this issue would be greatly appreciated. thanks, Sparrow
  4. no luck with the Set Field idea. the idea i had in last post works inconsistently. for some reason, sometimes when i enter back to back artists that are not in my database, instead of continuing to get the Modify Find / Continue / Cancel options, it exits the script and i'm left seeing the Artist Report layout still in Find mode. although sometimes i am able to alternate between artists that yield no matches and artists that do without a problem. is there a way to set up a loop that repeats until OWN="T"?
  5. here's the script i'm working w/ in case it helps anyone w/ troubleshooting the problem: Go to Layout ["Artist"] Enter Find Mode [Pause] Perform Find [Replace Found Set] Go to Layout ["Layout #1"] Enter Find Mode [Restore] Perform Find [Constrain Found Set] Go to Layout ["Artist Report"] Sort [Restore, No Dialogue] Again, when I first entered the script, the 2nd Find was Enter Find Mode [Pause] so I could enter the additional criteria that would weed out records where OWN = "F" and WISH LIST = "T". After the first time I ran the script, I simply changed the 2nd Find to Enter Find Mode [Restore], which removed the pause and kept the criteria I entered the first time, making the 2nd Find an automatic "pass-through" from then on. I realize that I could set it up to where there's just one Find where I specify all criteria, but I thought it would be more interesting if the user only ever saw the one Artist Entry layout (1st Find) that only shows the Artist field and says "Enter an Artist". I'm only having trouble in the following situation: There's a particular Artist in my database that I ONLY have records for where OWN = "F" and WISH LIST = "T". When I enter that artist in the 1st Find, FileMaker finds records. It's only in the 2nd "pass-through" Find where unowned Wish List records are weeded out that it says No Matching Records Found. When I click Modify Find, it returns me to the 2nd Find layout, "Layout #1", where it's too late to enter a different Artist. Hope this is making sense. I have an idea to try. I think I will set it up to where there's only one Find. Initially I will use Layout #1, which shows all fields in order to be able to enter OWN and WISH LIST criteria. The first time I run it, I will only enter "T" for OWN and "F" for WISH LIST. I will then set the script to remember those criteria. Next I will change the script to use the Artist layout, which only shows the Artist field. Even though it only shows that one field, I assume it will still remember the selections I made in the other fields if I use Enter Find Mode [Restore, Pause]. At that point I will be adding the final criteria: which Artist to search for. As I re-run the script over and over, I expect it will only restore the OWN and WISH LIST criteria, giving me the chance to enter different Artists each time while keeping the original entries I made in OWN and WISH LIST. I'll be specifying all 3 criteria every time, but OWN and WISH LIST will be automatic and hidden, the two things I want them to be. Any other solutions? Thanks, Sparrow
  6. i have a music database. each record is an album by an artist. (there are several other fields that are irrelevant here.) most records (albums) are owned, in which case OWN = "T" and WISH LIST = "F". some records are on the wish list, in which case OWN = "F" and WISH LIST = "T". i have an Artist Search script where you first go to a layout that lets you enter the artist. then, the script proceeds with another Find where I get to limit the results to weed out records where WISH LIST = "T" because I do not want my Artist Search to show records I don't own. i only have to do the second find once, as i can go back into the script and turn the pause off and remember the limiting criteria. (using constrain found set on the second find.) SO - here's what's going wrong... when i initiate the Artist Search and enter a bogus artist name, it says No Matching Records. I then click Modify Find and am able to enter an artist whose records i own and proceed with no problem. when i enter an artist that is on the WISH LIST (and ONLY on the WISH LIST), of course I get the same No Matching Records message, but this time because it failed the 2nd "pass-through" Find, not the first. therefore, when I click on Modify Find, I'm taken to the "Limit Criteria" layout. the artist name is already "in memory" from the first find and the only thing i can modify are the limiting criteria that made the 2nd Find fail. I need to be able to restart the script from the very beginning if the 2nd Find returns no matches basically. Preferably by clicking Modify Find and not Continue, but I'll take what I can get. Anyone know how to solve this one? Thanks, Sparrow
  7. Success at Last! Thanks, John. And I understand now why Insert Calculated Result was necessary.
  8. Ender, the way i understand Set Field is that it enters the result of a calculation into a specified field. i have been able to get your suggested script to work if i simplify it to: Enter Find Mode[] Set Field ["DATE ADDED", "Status(CurrentDate)-30"] Perform Find[] which does automate the "30 days ago", but it ONLY finds exactly 30 days ago. the result of the calculation must be a date. i start having problems when i try to Set Field to more than one date or a range of dates. is that supposed to be possible? perhaps the syntax is a bit off? you suggested: Set Field ["DATE ADDED", status(currentdate)-30 & ".." & status(currentdate)] which makes sense to me intuitively. but FileMaker doesn't seem to be translating that to "30 days ago thru Today". any additional help from anyone would be greatly appreciated.
  9. i am not entering any non-dates. each of my records has a field called DATE ADDED which is auto-filled using the current system date in standard MM/DD/YYYY format...
  10. Ender, I have entered the script you recommended, yet when i click on the button to launch the search, it says there are no records that match the request. any ideas? thanks. Sparrow
  11. i'm hoping there is already a way to do this. so far i know that i can type "//" to indicate the current date. what i'm trying to do is indicate a range in find mode that would return records entered from 30 days ago through the current date without having to type in any actual dates. right now i'm having to settle for using, for example, "4/22/2007...//" to indicate the range from 30 days ago through today. tomorrow, the range will only update on one end. the 4/22 won't update to 4/23. that's why i wanted to use "//-30" for that end of the range. can anyone tell me if there's a way to do this? i'm using FileMaker Pro 6. thanks!
  • Create New...

Important Information

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