torifile

It works wonderfully! Thanks! One more question: when I perform the script the first time, my results are filtered to the one child entry, but subsequent runs of the script just add them to the found set. How do I get it to "reset" the new window?

It's certainly not "cumbersome" in the sense that there's too much to do, it just didn't to be the most straightforward solution (to be honest, I figured since it was the only way I could figure out how to do it, there must be some other way!). What you're telling me is that my method is the "right" way to do it and now that I've created the script to implement it, it's not a problem at all. My only remaining concern is that there should only be one of particular types of child records; that is, a 1:1 relationship, I think. My script doesn't prevent multiple entries. It's not a huge deal because this is just for me and a few colleagues, so I'll just tell them about that quirk, but I like to try to design something bulletproof and correct. But it looks like the script you put up there addresses that concern, so thanks. : I was wondering what you meant by "script triggers". Can you elaborate some on that?

I've got a database with patient information. Each patient has a number of different types of notes associated with them. Some of these notes are "one time" types of things, like an intake report. Others are multiples, like session notes. Is there an easy way to create entries in related tables automatically upon creation of those these entries? For example, I've got a "master treatment plan" table, with patientID as a foreign key. When a new patient is entered into the database, I'd like a way to have the master treatment plan table populated with the foreign key so I'm ready to go when it's time to write that report. Any ideas? Right now, I've created a script that uses globals to pass along the foreign key between the layouts and create a new record in that particular layout. Seems a bit cumbersome and probably wrong.

I see what I did wrong in defining my relationship - I had the wrong key referenced in my logic. Now that I've fixed that it works. Now the issue is that if the weight is changed in the older entry, like if there was typo, the newer weight's record is not updated. I even have the auto-enter calc to replace existing value.

That's helpful but I'm not quite sure how to implement it. Can you have a look at my database? It's messy but the tables I'm referring to are called "weights" and "weights 2". New_CH.fp7.zip

So if you enter the data our of chronological order, the date will be the deciding factor? Are there any downsides to that approach?

I'm working on a database where I've got values that need to be carried forward from week to week. IOW, on a current "note", I'll input some data, like weight, and the next week's note, I'll need that previous week's weight in the field for "previous week". Do I need to create a table for "previous weights" or is there some way to just display the previous week's weight without having to do that? Similarly, there are some checkboxes that are marked on each week's notes and I'd like those checkboxes marked with the previous week's values.

Yeah. That script was in mid revision when I threw my hands up and decided to post here.

I'm going to be kicking myself when I read the answer to this question but I can't for the life of me figure it out on my own. I'd like to be able to press a button in my main window to pop up a new window with a layout for data entry. In this window, I'd like to only see the one record I wanted to create the entry for. The scenario: Each patient has a number of notes associated with them. The way I've got it set up right now, is that I can flip through patient info in my "main" window. From there, there are various buttons that I'd like to trigger a script to open a new window with only the current patient as the found set. If the button triggers a script to go to the layout, it does go to the proper record, but I don't need other records to be accessible from that window. Does that make any sense? I'm going attach a file with the database so you can see what I'm referring to. Under the layout called "Dates and Links" there's a button that says "BPSA". I'd like clicking on that to do the same thing as opening a new window with the layout "BPSA" and finding records based on "patientID_pk" in that window. New_CH.fp7.zip

I'm working on a database for managing my clients and session notes. Each client has a "patient ID" and each client has a number of sessions associated with them. My thinking is that I'd have a portal with a list of session dates that could take me to a "note" layout to write the note for that particular day. Something like where clicking on the checkbox will trigger a script. Does that make any sense? What do you think would be the best way to accomplish this? I've currently got a "master" key table which is related to the sessions table through a foreign key relationship. I'm using FMP 9.

Hmm. I don't know. My thinking was that patient IDs should be associated with the Axis tables (there are 5 of them). I suppose they are through the Axes table.

I'm not sure if I'm describing that right but let me post a screen cap of my database: So I've got my "main" table related to my "axis 1" table via a relationship through "axes". In my testing, the patientID_fk in "axis 1" does not get created in my "axis 1" table upon a record creation. edit: I just added another relationship between patientID_fk in the "axes" table and the "axis 1" table and that seemed to do it. Is that right? I also don't know why my screencap is so small. The actual image, full size is here

Well, I keep answering my own questions. I guess that's a good thing. This is probably a crude hack but it seems to work... I created a global field, pasted the contents of the found records in there and used that field in the "message body" area of the dialog box. The one thing I'm not too happy about is that the global field doesn't "clean itself up" afterwards so I've got to have the script select the contents of the field and clear it out. I thought globals weren't stored?

One more question: how can I automatically compose an email with these newly created dates? What I'm trying (not working right) doesn't get to the point of pasting the data. I can select the right dates and copy them but I can't get them to be pasted into the email window. It looks like I might have to put it in the message field in the dialog box but I don't know how. Thoughts?

Sweet. Got it working. I got caught with the "optional script parameter" on the "generate dates" button, but I got it figured out. Thank you very much. :

comment, Thanks for that! That looks about right. Now I need to figure out how to get it into my file. Looking through it, it seems pretty straightforward. I've got one question though: what is "ScriptParameter"? Is that a special Get() argument? Thanks a ton. I'll let you know if I've got any more questions. :

Man, sorry I'm having a hard time explaining myself. Thanks for sticking with me. Anyway, the first date is defined by the date the request is made. That is, if I want a set of dates generated today, the start date is today and the end date is 12 months from now. Thinking about it a little more, it may make sense to have the start date user-defined, with the default being the current day (if that makes any sense). The gist of the project is that I need to randomly select one therapy session per month per client over a 12 month period for review. I want FM to generate the random day per month and input it into the table.

Ah, yes. Detail. I need 12 months of random dates, one per month (so a total of 12). The end date is defined by the date of the request. The "date" records need to be created by the script, but the client records will be created prior to generating the dates. Thanks.

This may have been asked before, but I'm having trouble coming up with the proper search terms to find it, if it has. Anyway my question is pretty basic: I'd like to generate a list of random dates when the user requests it and enters those dates into the proper table. My set up is like this: I've got a client table. Each client in the table can have multiple dates associated with it. So, the clientID is a foreign key in a one-to-many relationship with dates. I'd like the dates table populated with the foreign key (obviously) and the random dates. Any ideas? I'm running FM 7, if that matters. (Please remember that I'm a newbie. )

This is a new problem to me... I'm trying to open the IWP settings and every time FM7 quits. My install seems to be screwed up somehow - FM will hang when I open it without using a pre-existing database to launch it (i.e., if I just double-click in the finder on the application it will hang). If I open it by opening a database, it will launch fine. Trying the IWP settings will still make it crash. Any ideas? I'm running 10.4.3. Personal Web Sharing is OFF (I tried it both ways). Sharing over the filemaker network seems fine. edit: running FM 7.0 v3

The TO is still there, just with no fields listed. In the Tables tab of "Define Database", it says "0 fields, 12 records" and the layout that I was using for it is just BROKEN, as in I can't delete it, change it's name, add anything to it. Nothing. Who knows.

The TO is still there, just with no fields listed. In the Tables tab of "Define Database", it says "0 fields, 12 records" and the layout that I was using for it is just BROKEN, as in I can't delete it, change it's name, add anything to it. Nothing. Who knows.

The TO is still there, just with no fields listed. In the Tables tab of "Define Database", it says "0 fields, 12 records" and the layout that I was using for it is just BROKEN, as in I can't delete it, change it's name, add anything to it. Nothing. Who knows.

Absolutely. The more I work with FMP, the more I realize that it's a very rich environment. I'd like to learn more than my books can teach me.... So far, I've convinced the people I work with that it's been a very good investment. I'm trying to get them to pony up the dough for a copy of FM Server and a few more copies of FMP because I think it'll streamline our tracking/data collection greatly. I just hope we don't have many more near disasters like this one. I'm still curious about what could have caused the corruption and what I can do to prevent it. I was looking at a very long night getting it all working again. Thank goodness you posted when you did.

Absolutely. The more I work with FMP, the more I realize that it's a very rich environment. I'd like to learn more than my books can teach me.... So far, I've convinced the people I work with that it's been a very good investment. I'm trying to get them to pony up the dough for a copy of FM Server and a few more copies of FMP because I think it'll streamline our tracking/data collection greatly. I just hope we don't have many more near disasters like this one. I'm still curious about what could have caused the corruption and what I can do to prevent it. I was looking at a very long night getting it all working again. Thank goodness you posted when you did.