saralee

Hi Thanks for asking about my find feature. I used some if statements to include search criteria where users choose to apply during their search. There are check boxes in my user interface asking people if they want to include premature babies or households that have not been given regsitry permission and such in their search.. It works so far.. Thanksfully..

Thank you, comment! Duplicate Record was what I needed.. It works now. Thanks again.

HI sorry about the unclear msg. I tried using the "new record" line, but since i have other criteria to construct this big search, when i did "new record" it is combining the big search with one registration condition with the other registration condition... ok, let me try to explain it more.. this is just a rough version of my script- enter find mode[] set field[...] set field[...] if (....) set field[babies::letter; "Yes"]; set field[babies::letter; "DBL"]; end if in this case, the search is doing for records that with letter field that is set "DBL" instead of "Yes" or "DBL" and if I tried set field[...]; -- other conditions set field[...]; if (...) set field[] -- condition 1 new record set field[] -- condition 2 end if The search is looking for records that meet the other conditions and condition 1 PLUS those that meet condition 2.. i'm looking at a script to look for records that meet other conditions along with condition 1 and condition 2. Hope it makes sense.

Hi comment. Sorry about the confusion. I meant "two criteria" because there are two conditions for a household that would be considered registered. One is baby::letter = "Yes" and the other would be baby::letter = "DBL" Either of these would qualify, and that was where I had trouble with. Because I wanted to put conditions/criteria down to define the search, but only the second condition (whichever comes the second) would be recognized. What I essentially want is to have the "letter" field defined as either "Yes" or "DBL." is there a way to do that? Any ideas on how I can define two conditions for the same field. Thanks!

hi everyone, i'm working on a search feature that would set a field with two different values (either A or , but the script didn't seem work.. Here is my script- $omitHHnoLetter is a check box field If ($omitHHnoLetter="Omit HH no letter") set field (babies::letter = "Yes") set field (babies::letter = "Letter sent") end if The script is recognizing the second criteria (the second criteria seems overriding the first one) So is there a way to combine these two criteria to make both of them valid for the same search? i really am looking for records with the "letter" field equal to Yes or Letter sent. i tried set field (babies::letter = "Yes" or "Letter sent") but it didn't work.. Please advice. Thank you! Qinqin

Hi lawaid, Thank you for being so kind! i tried having three dots in between the "&"s in my calculation, but the search still didn't work properly. In fact it seemed that "insert calculated field" function does not work at all.. when i used that, the search is all over the place. so I changed back to the "set field" function. but the mystery still exist: the search only finds a set of the results that meet the criteria, and the missing records do not follow any pattern. what is going on?? let me know if you have any ideas. thanks a lot!

Thanks, James. i did exactly the same thing as what you described here, so i suppose my data structure is good. i gonna look into other areas to solve my search function mystery then.. hmm... Oh yeah, i'm working on a database for a baby studies center. haha it's quite cheerful here except the database is giving me much headache.. i'm learning.. : btw, can you think of any reason that might be causing my search mystery? my org post is here. http://www.fmforums.com/forum/showtopic.php?tid/216740/fromactivity/mytopics/ Thanks!

Hi everyone, I might have a data structure issue here, since my search function does not work properly.. so here is what i have so far- i have tblHousehold and two baby tables tblBabies and tblBabies2, and these are self-joint with the indication that there are siblings who belong to the same household, so they have the same household IDs but different baby IDs.. I wonder if this self-joint structure is proper or not.. They have the exactly same fields, and only tblBabies links with other related tables such as tblLanguages and tblBabyEthnicity .. Any ideas? Thanks a lot!

Hi lawaid, Thanks for the helpful tips.. I tried to use "insert calculated result" instead of "set field" but it is getting me irrelevant data. Can I use that along with set field? For example, I have something like this Enter Find Mode[] Insert Calculated Result[select; babies:ageinDays; $AgeFromInDays&"..."&"$AgeToInDays] Set Field[Languagues::Lang; $Lang] Set Field[Languagues::LangPercent; $percentLang] It seems like it's only searching for records which meet the last two criteria but the first search criteria does not seem at work.. Any ideas? Thanks!

Hi all, i'm still fine-tuning my baby database. so, i wrote a script to search for babies with criteria set by the users, but it does not work properly. In a simple search like searching for babies with certain language and age criteria, the search result does not include all that meet these criteria. For example, for searching babies who hear 80% English within the range of 4 - 6 months, the search is omitting some baby records that do not follow any patterns. Please see my attached screenshot of my script. Thanks!

Hi ,right now my database is hosted at the FM Server which is at an MAC. I just wonder if i need to shut the server down before shutting down the MACs occasionally... thanks!

Thanks! Yes, the main database is hosted in FM server. So I need to create the import script to do the task.. in the "import data" script, how should i specify more than one matching sets of data? because my database has several tables, and i need to transfer data from all the tables. so do i need to specify several import data scripts then? Also, is there any optimal way to input the IDs in the "temporary" database to keep the IDs separate from the main db? The tricky part is how to integrate the data collected from iPad with the main database in FMS. Thanks a lot!

Thank you both! You are correct. Sorting by DOB works! :)

Thank you, comment! I found out there is a general sorting issue here - even for a babies set that are all single child, the sorting function somehow separates the data sets into two parts, each of the set is sorted but the total order is messed up.. for example, below is a set of age of babies i get (all of them do not have siblings) 4m2d, 4m5d, 5m10d...5m22d || 3m27d, 4m3d, 5m4d... and after the sorting, in the browse mode, the first record that shows up is 3m27day in this case which is after the separator i indicated above.. seems very strange.. do you have any ideas? THANKS :)

Hi, is there any way to update imported data? i migrated a bunch data to my new database and started adding new records, but just found out that there are mismatched repeating fields during the migration, so i need to update the imported data.. i chose to split the repeating fields into individual fields.. and now i just need to update some of the fields in the repeating fields. i tried the two options "update existing records in found set" and "update matching records in found set" but neither of it worked.. Instead of migrating the whole thing again, is there any other way to just update the imported data? thank you!

Thanks, Comment! In step 4, did you mean I need to create a report based in table babies?

Hi everyone, We got our FM database up in an iPad, but can't figure out how to export the records to another computer.. The database in iPad is just something that the user will use remotely, and the records need to be integrated with the main database file (with the same design) in a computer. Now we need to figure out how to somehow retrieve the database file off the iPad? Anyone who's familiar with how the new gadget works? It doesn't seem to have the email attachment function, and I don't even know if we can store files in any locations in iPad.. otherwise i could just email the FM file... Let me know. Thanks a lot!

Thank you comment for the question. i think it does not matter which age range we will put this household.. it could be put either place, since the user will figure out which sibling is in the order of the current sorting.. so would it make things a little easier? Thanks!

Thanks, Lee. It is working properly now! :)

thank you both Comment and Lee!! So I need to clarify some steps here.. after my searching script, I need to go to layout baby and do sorting, right? And then I need to create a report based in the tblBabies? with information pulling from the household? I'm lost here.. Please advice. Thank you!

hi, I tried to implement a script to correct the improper input in an address text field.. for example, change "East" and "E" to "E." ; "Avenue" and "Ave" to "Ave." ... so the script is attached here, and i set the script to the address field as "onObjectModify" it didn't work for me.. the script seemed not be loaded at all.. Could anybody point out what might be the issue? Thanks a lot! :)

thanks, comment!

Hi, I have a number field that I'm giong to change the text color if the value is in a certain range. I don't know how to use the TextColor function in my script.. this wouldn't work- SetField(household::days; textcolor(255;0;0)) What should it be? Thanks!

sorry that is just our design which relates to our operation.. we want the users to view the household as the search result.. oh.. so it is not feasible.. too bad.. anyway i can do the sorting in SOME babies in the baby layout first and then display all related household in the household layout? Thanks a lot! this is getting so specific..

Thanks, Lee. I'm not sure about the reports part. The final product I need to present to my users is a sorted household records within a search constraint.. so bascially search -> sort -> viewable in browse mode.. The tricky thing is that my sorting is based on babies' ages and these babies have to be in the search constraint first..