VAB

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

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 have a time overlap. Any ideas? Thank you! EB

I finally got it!!! Thanks so much for your patience and persistence.

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.

"That is what the "default location" parameter in the choose file command wants" where's that?

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!

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).

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?

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.

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.

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

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!!

It took me a while, and I had to change a few things in the script, but now I understand. Thank you!

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.

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?

Ok. By adding Case(isEmpty(... and Case(Patterncount... the problems are solved. Thank you.

Now, it only works when there's already a checkbox selected and it seems it adds the same values on top of the old ones. So when I want to deselect a box I have to keep clicking.

Actually... it doesn't work anymore...

Thank you! That works

I'd really appreciate any help with the following problem. I have a field that contains a value list, shown as a checkbox set. Different records have different checkboxes checked. In a certain layout, I'd like to check one of the boxes for a certain found set of records. I now have this script: Go to Record [First] Loop Insert Calculated Result [select; fieldname ; value] Go to Record [Next; Exit after last] End Loop This works, but it replaces the current checked boxes, because I use "[select;...]". But if I don't use that, I doesn't work. I get an error message telling me that my field doesn't except the new value. What am I doing wrong? Thank you, VAB

My field3 is a selection box too, to select my records in my database. I use two buttons, because I want to extend my previous selection. Anyway, it works now... thank you very much!

that's it! thank you.

Sorry, both solutions seemed to work, but in end they didn't give me the results I wanted. So let me tell a little bit more about what I want: I use the calculation for a "replace field contents" behind a button. Field1 = 1,2,3... or 14 Field2 (checkbox set) = 1,2,3... and/or 14 Field3 = empty or "x" button1: Case1(When field1 = one of selected in field2 ; field3 = "x") button2: Case2(When field1 = one of selected in field2 ; field3 = "") Solution with length() doesn't works in case2. Solution with patterncount() doesn't work because it counts the "1" in "11", "12", "13" etc. as well. Can you help me?

thank you!!! I don't understand why, but it totally works!

thanks!