Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About VAB

  • Rank
  1. Thank you! I was trying to do these relationships through calculations... quite impossible... One more question though: these are AND relationships, can I make OR relationships as well? For instance: start time > 2::start time AND start time < 2::end time OR end time > 2::start time AND start time < 2::end time
  2. Dear FM talents, I have a challenging problem. In a table with: - students (indexed ID related to other table) - dates (date) - lesson start (time) - lesson end (time) I'd like to prevent making an new record with a lesson that starts or finishes while another lesson takes place. I've made a self-join and a calculated field (with patterncount(list(etc.);dates)) to identify the lessons that take place on the same day, but I don't know how to do it with the times. It only works when two lessons start or finish at exactly the same time, but I want to identify the lessons that
  3. I finally got it!!! Thanks so much for your patience and persistence.
  4. I think I didn't make it clear enough what i want to do. I don't want to get the path, I want to put the path into the script, so that when I run the script and insert a file, the window opens in the folder I want it to.
  5. "That is what the "default location" parameter in the choose file command wants" where's that?
  6. Thank you!!! I'll study it when my head is clear again. I don't think I can process anything anymore... Thank you again for spending so much time and effort on my question!
  7. wow, I really, really appreciate you not giving up on me, but maybe you should. I still don't understand. The only thing I understand is that there are 6 scripts, each one more complicated, using AppleScript. And I can see the result of them, but I have no clue how to transform them to do what I want (tell filemaker where the files are I want to choose from to insert).
  8. It seems to only remember it when you insert it yourself, using the window, not when you use automatic insertion. So, you say I don't need to understand applescript, but then how do I tell it which path to use?
  9. By the way, the option without appscript didn't work, because when you have FM select a file automatically, it doesn't "remember" the location.
  10. I'm sorry, but I really don't understand it, while you did so much to make it clear! Sorry! (I don't even know how to "set myFile to (choose file without invisibles)". I'll try to learn, but it seems hard.
  11. Thank you, Fenton! I indeed want to choose an arbitrary file from a specific folder. I've never used AppleScript before, but will give it a try. They other option you mentioned is very clever. I might just go for that one. Thanks again, Ente
  12. I have a script that opens the "Insert File" window. I'd like to add the folder the file can be found in. "Specify source file" doesn't work, because I need a designate a file there. So what I want to be able to do is to specify the source folder. Does anyone know how to do that? Thank you!!
  13. It took me a while, and I had to change a few things in the script, but now I understand. Thank you!
  14. I'm sorry, this doesn't seem to work. The idea is: field1 = 1,2,3,4... (each checked or unchecked) By clicking a button I want to deselect all 3's.
  15. Thanks to the help from the forum, I was able to write a script that can automatically check values for multiple records in a checkbox set. See: http://www.fmforums.com/forum/showtopic.php?tid/199116 Now I'd like to know if it's possible to do the same for unchecking values. Anyone?
  • Create New...

Important Information

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