ezpc_rox

Thx for the reply, we use MagicJack for our phones here, it has it's own program for dialing with a plugin for outlook to dial directly from outlook, this "outlook manipulator" you mentioned sounds interesting, where can i find info on that? Also, you wouldn't happen to know where i can find more info on FM's dde server functions?

Here at our office we use magicjacks for phone use, it comes with a plugin so you can click on a contact in outlook and dial it, I'm looking for a way to send contact phone and maybe address info from filemaker to outlook, like an "export to outlook" button i could link to a script to that would create a vcard or the like, any suggestions?

awesome, that worked like a charm, thank you for the info

I'm trying to get a found set of one single record of 71000, so i started a script that assigns a variable to the serial number of the record currently being viewed, then i wanted to have the script do a find for that variable so i end up with that record in the found set, i can't figure out how to specify a find for a variable.. any suggestions?

ok, i think i got it, it has to be that i have no record in a found set when i have the script bring up my new layout, I started with a blank layout, and all i need is the one record I'm looking at when i click the button to bring up that layout, the script is supposed to use the data in the single record I'm looking at and for example, fill in the name of the contact I'm viewing in the new layout.. the "report" will only be using 1 contact, and eventually create a pdf and email it. Thank you both for the help, greatly appreciated.. I suppose i could have the script perform a find for data that would single out that 1 record.

if i'm viewing a record when i run the script, would n't the new layout use the data from that record? Or do i need to some how tell it to do that? Also, the preview doesn't show any text NOT in fields either, just blank, like when in layout mode, I used the text tool to add a title for the report i'm trying to do, that doesn't show either...

is there any way to save the field mapping at the beginning of an import so xml files with identical field names don't have to be remapped?

I am creating a layout that will eventually be exported as a pdf and emailed, I have not gotten to the difficult parts of this yet, but have designed a basic layout. The problem is that all i have put on the layout so far is some text and a date field, when i switch to preview mode to see what it will look like the page is blank. what did i miss here?

Thank you both for the responses, I am very new to filemaker and the help I get in this forum is excellent, makes learning the program a whole lot less of a kick in the shin. Staggering the backups into different folders is a great idea as i have 6 co-workers entering data all day long, thanks for that Steven, great tip.

I understand that filemaker server can do complete database backups and incremental backups, I can't seem to find anywhere to tell it in the scheduling backup section what type of backup i want it to do, anyone know off hand?

you were right about the loop not evaluating all the records the way i had it, but when i try to add in the "else" before the exit, i get a never ending loop, this script looks different then the one i originally posted, but the if/then structure is basically the same recruit stats Go to Record/Request/Page [ First ] Loop If [ nasd_NOTE__cno::Tried ≠ "tried" ] Omit Record Else If [ nasd_NOTE__cno::TT ≠ "TT" ] Omit Record End If Go to Record/Request/Page [ Next; Exit after last ] End Loop Go to Record/Request/Page [ First ] Loop If [ nasd_NOTE__cno::initials = "KAT" and nasd_NOTE__cno::Tried = "Tried" ] Set Variable [ $kattried; Value:$kattried+1 ] Else If [ nasd_NOTE__cno::initials = "KAT" and nasd_NOTE__cno::TT = "TT" ] Set Variable [ $kattt; Value:$kattt+1 ] Else If [ nasd_NOTE__cno::initials = "DAP" and nasd_NOTE__cno::Tried = "Tried" ] Set Variable [ $daptried; Value:$daptried+1 ] Else If [ nasd_NOTE__cno::initials = "DAP" and nasd_NOTE__cno::TT = "TT" ] Set Variable [ $daptt; Value:$daptt+1 ] Else If [ nasd_NOTE__cno::initials = "JID" and nasd_NOTE__cno::Tried = "Tried" ] Set Variable [ $jidtried; Value:$jidtried+1 ] Else If [ nasd_NOTE__cno::initials = "JID" and nasd_NOTE__cno::TT = "TT" ] Set Variable [ $jidtt; Value:$jidtt+1 ] Else If [ nasd_NOTE__cno::initials = "HML" and nasd_NOTE__cno::Tried = "Tried" ] Set Variable [ $hmltried; Value:$hmltried+1 ] Else If [ nasd_NOTE__cno::initials = "HML" and nasd_NOTE__cno::TT = "TT" ] Set Variable [ $hmltt; Value:$hmltt+1 ] Else Go to Record/Request/Page [ Next; Exit after last ] End If End Loop Set Field [ nasd_NOTE__cno::zc_katcount; $kattried + $kattt ] Set Field [ nasd_NOTE__cno::zc_tt_katcount; $kattt ] Set Field [ nasd_NOTE__cno::zc_jidcount; $jidtried + $jidtt ] Set Field [ nasd_NOTE__cno::zc_tt_jidcount; $jidtt ] Set Field [ nasd_NOTE__cno::zc_dapcount; $daptried + $daptt ] Set Field [ nasd_NOTE__cno::zc_tt_dapcount; $daptt ] Set Field [ nasd_NOTE__cno::zc_hmlcount; $hmltried + $hmltt ] Set Field [ nasd_NOTE__cno::zc_tt_hmlcount; $hmltt ] did i do the else/exit wrong?

doh! i see it now, sorry about that.. it does now exit the loop, i just have to figure out why it doesn't like my dates, thanks New Script Go to Layout [ “Layout #36” (nasd_NOTE__cno) ] Set Error Capture [ On ] Perform Find [ Specified Find Requests: Find Records; Criteria: nasd_NOTE__cno::Tried: “Tried” ] [ Restore ] Go to Record/Request/Page [ First ] Loop If [ nasd_NOTE__cno::ndate < nasd_NOTE__cno::st_date ] Omit Record Else If [ nasd_NOTE__cno::ndate > nasd_NOTE__cno::en_date ] Omit Record Else If [ nasd_NOTE__cno::initials ≠ nasd_NOTE__cno::rpt_initials ] Omit Record End If Go to Record/Request/Page [ Next; Exit after last ] Exit Loop If [ (Get ( FoundCount ) = 0) ] End Loop

that makes sense, thank you for the feedback.. so i edited my script as you described, i think i need different criteria for the loop to end though, since it finds 11000 matches, it just continues on..i think it may be ignoring my date range also.. would turning error capture on make it report script errors to me? maybe help me diagnose whats not working? New Script Go to Layout [ “Layout #36” (nasd_NOTE__cno) ] Perform Find [ Specified Find Requests: Find Records; Criteria: nasd_NOTE__cno::Tried: “Tried” ] [ Restore ] Loop If [ nasd_NOTE__cno::ndate < nasd_NOTE__cno::st_date ] Omit Record Else If [ nasd_NOTE__cno::ndate > nasd_NOTE__cno::en_date ] Omit Record End If Exit Loop If [ (Get ( FoundCount ) = 0) ] End Loop also, just to provide more info, this table is a notes portal, ndate is the date of the note st_date is a global field i added to a new layout for this report I'm trying to produce, en_date is the end date, also a global field (i tried using a date field on a previous attempt) the script seems to be ignoring both if statements, i get the same number of results no matter what date i enter.

ok.. trying again.. using this script below New Script Go to Layout [ “Layout #36” (nasd_NOTE__cno) ] Perform Find [ Specified Find Requests: Find Records; Criteria: nasd_NOTE__cno::Tried: “Tried” ] [ Restore ] Loop If [ nasd_NOTE__cno::ndate < nasd_NOTE__cno::st_date ] Omit Record End If If [ nasd_NOTE__cno::en_date > nasd_NOTE__cno::ndate ] Omit Record End If End Loop what i want this to do is find all records with the "tried" field filled in, but i want it to only add the ones in the date range to the found set, it ignores both if lines and stays in the loop until i hit esc.. what gives?

thx for the welcome and the quick reply, I'll do some more reading. Is there a way to "copy" a script and paste it in a post so i can show you what i'm trying?

Just started using filemaker, got a basic grasp of the program but need some help with scripting. The database i'm working on deals with telemarketing of sorts, i need to make a script that will count how many times a call was attempted by a particular user, could anyone maybe point me to some sample scripts that could help in creating a script like this? thx in advance