Script Workspace and Script Triggers

Anyone?? I did a search here for endecia - nothing. I need to open this program called DAZzel and tell it to print my .xml. I've searched posts but can't find aything of relevence and I'm out of time. I did have it work fine and then I sc****d something up. I'm leaving on vacation tomorrow (now Tues because of this)and have to have this automated. Sooooo ... I was using the 'send event' in scriptmaker. Here's what they (DAZzle)say. Using the Command Line DAZzle operations can be automated by launching DAZzle with an XML file in the command line. The specified XML file should include the optional “DAZzle” attributes to signal DAZzle which method to…

I have a script that runs on a scheduled basis. When the script finds certain criterea and the user has the filemaker window minimized, I would like to be able to Maximize the Filemaker window via script. Is this possible? (windows OS) Thanks, Mel

Hi, I am having a problem with a calculation involving an IF function. I want the IF statement to be based on whether or not a field contains a specific value. However, I am having trouble differentiating between the field containing just that value vs. that value along with other values. The field in question is based on a value list of countries. The beginning of my IF statement is: If(CountryName="Canada";"CA"). For most records the CountryName field contains many different countries, not just "Canada" alone. I want the calculation to work on any record that has "Canada" but not only "Canada". So right now it is not applying the calculat…

I'm Running Server 8 and have a perplexing situation. I have a notes table. Let's say User A inputs a note. I've included the ability for any other user to append the note. When User B appends User A's note, my script fills in a field to notify User A that their note has been appended. I've written a script that will check the table at a certain increment (say every 10 minutes) to see if a note the user has written has been appended. I have all of this working just fine EXCEPT....... The script I am using has to change to the layout that shows the records of the notes table to check for changes. I have included that if get(recordOpenState) is not equal to 0 not to…

Newbie -- I've been searching and can't find how to create a script that searches via a Date field. I have a database that shows room assignments A button on the Test Screen links to the Room Booking Screen so that the viewer can see any conflicts On the test screen the operator has to enter the Date of the Test. I want the operator to be able to click on the button, go to the Room Booking Screen, and see all tests occurring on the date of the test. I can't put in a specific date range or date because the dates change depending on the student and test. And if I go make the operator do a FIND for all tests on this test date, the oper…

OK, I will try to explain this as best I can. We have a Timecard system built in FileMaker. Our HR department had us build in some "exceptions." At our offices, weekend are always paid at the overtime rate. So in the system, they(HR) wanted us to program the system so that if a person started their shift on a Friday at 8PM and worked until 3AM Saturday morning, when they punched out for the day, the Friday hours would show 8PM to 11:59PM, and then a Saturday punch would be added that showed 12AM to 3AM. We have this deployed at 4 divisions, and we only have a problem with one. The past few months, they have a guy who has been coming in on Saturday at about 5AM…

Hi all, I have a script that appears to give an hour glass in normal mode and then quits, but when its put into debug mode does all the things it's supposed to (and with correct end result) Is there anything generic that might cause this? is there a way of tracking down the prob given that debugger steps through ok thanks in advance Simon

Hi Guys Bit of an odd one... I have a single step script to send e-mail using "Send mail". I am using outlook 2003 on XPPro. My problem is that in the script anything I put in the "message" option is ignored and doesn't appear in the email body - have i missed something really obvious Many thanks Simon

I've made a 4-file relational database as part of my IT course. The related files are called 'clients', 'sales', 'products' and 'orders', with the orders file as the main file. Everything is working as it should be, with the exception of sub-summary fields in an automatically generated report. The report is supposed to summarise all products sold within a chosen month. The month and year is selected via a drop-down menu on a separate layout, and the script that generates the report uses this information to search for relevant products/records. The invoice/order layout features a portal where products can be added to a single form and printed with the client's name. I…

Hi, In the following sample script, when should I commit records? Maybe I should do it every time I use the Set field command, but maybe it is redundant. Are there any clear guidelines about it? Go to layout 1 New record Set field ... Set field Go to layout 2 Go to record Set field Go to related records Loop Go to record (first by Variable) Set field ... Set field Go to record (Next by Variable) Exit loop if End loop Go to layout (original layout) Thank you

I want to write a script to search for a "#" mark in a text field and replace it with a carriage return, then find the next hache mark and replace it and so on through a series of records. In FM Pro 8 HELP it says However I cannot work out how to copy an invisible character. Where do I find it? What do I enter in the REPLACE WITH TEXT box?

i understood how to create a dynamic filepath by setting variables within a "esport to excel" script. it works fine. now i have another question: let's say, someone wants to export several found sets one after the other to excel without the second export overwriting the first. e.g. script is saving the file automatically onto the local desktop. the first file would have the name "file1.xls", the second exported file would get the name "file2.xls", the third "file3.xls" - safari does this when downloading several files with the same name.... thanks for all your help. hans

Hi, What do you think is the best way to populate a field/fields in all related records? The options I spot are: 1.- Go to related records > Create 2 variables, one holding number 1, the other counting the number of related records > Use this variables in a loop to populate the records 2.- Go to a layout showing related records > Replace the value in the field for all records. I do not like either one. The first one is too slow and too cumbersome in some cases (many fields or many records). The second one requires a specific layout and I particularly do not like to use the replace command at all. It can easily lock if one of the related r…

Is there a way to detect a paused script? Or prevent a script from being run based on whether another script is paused? I inherited a solution that has about 15 scripts in the Scriptmaker drop down. There are several scripts that pause for user entry. Sometimes when a user is paused, they will lose focus and run another script which often dumps them somewhere they don't expect/shouldn't be (usually in a find layout but in browse mode). I'd like to stop this from happening with the least amount of effort. Ideas? Thanks, DJ

Hi, I've been working with the Business Productivity Kit. I have modified it to do everything I need...Except, I can't figure out how to change the names of the "Modules" or "Reports" listed in the toolbar. Any help would be greatly appreciated. Regards, Seattleflo

I’m using FM 8 and Win Vista. I’m having troubles column calculations. I’m using GetSummary fields instead of Summary fields so I can do the calculations. The fields are located in a sub-summary part. See Attachment for screen shot of layout and browse modes I have three columns of data, D. E and F. Column D uses a GetSummary field to calculate values, and Column E uses a GetSummary field to calculate values. Both show correct results. In column F, I’m trying to subtract Column D from Column E with a GetSummary field . It simply subtracts the D and E GetSummary fields. The results are all correct except for the very first value in the column. This seems stran…

Hi I am having a find and scripting problem. I know this should be easy but I can't get it to work... I have a job file and each job has a deadline date. The script I have setup is searching for all jobs within a certain date range which is working fine but I then want to omit or constrain these found records so that any COMPLETED jobs are not shown. The first part of the script works fine - all the jobs within the date range come up. Then the second part of the script when i perform either another Perform Find using the omit variable or I try to use the constrain found set it then shows all records with all dates except the COMPLETED jobs!! I can't get this to …

I am using Send Event to start a VBscript that does a mass e-mail. The script step is using the following parameter: Quote("C:Documents and SettingsAdministratorDesktopmail.vbs") & " " & Quote( $v ) It all worked ok until $v became > 1987 characters. This causes the script to ignore the Send Event and get(lasterror) returns 3. I cannot find any documentation that mentions a limit of chars in Send Event so if anybody can figure out a workaround for it I would be greatly appreciative! cheers John B PS - can't use Filemakers built in email script step as this will cause MS Outlook to prompt for every email.

hello all, i am using FMP 8.5 advanced, windows xp. i have a REAL problem. i am on a job in houston, texas where i want to create a new record and copy the data from my edit area and populate the fields in the new record. i have created two dummy db's, dummy1.fp7' and 'dummy2.fp7' to demonstrate the problem and i have attached them for review in 'dummy1.zip'. there is nothing malicious about these. when i create a new record and try to read a field from the first Db and paste it into the new record via a script, nothing happens. i have tried 'Set Field', 'Copy' followed by 'Paste' and i have used the script debugger to view the fields all t…

I recently deployed a solution and it was working fine, except I had a report that kept printing in portrait instead of landscape. I also had another report that saved to the desktop as a PDF file and associated it to an email, it worked fine. I fixed the landscaping problem and redeployed the solution, now I cannot save the PDF report. It works fine on my computer but will not work on the on the other computer. I deployed it as a runtime solution. The script works fine but it seems to be skipping the "save as PDF". What am I doing wrong.

Hello there, I'd be so glad if someone helped me with the following problem: - I use a global field (number) in a script. - When the user which works with the server PC displays the field ore runs the script which uses the field, everything is fine. - When a user that works with a client PC displays the global field or runs a script which uses the global field, the value is not correct. It remains the same as the previous time it was used on that PC, regardless another user has updated the value in the global field itself. - all users (server included) have FM 8.0x client on their PC. Thanks for the help!

Layout A shows records from table A. I have a portal which shows related records from table B. Is it possible to step back and forth via script through the records in table B via the portal. I'm trying not to switch layouts any more than absolutely neccessary. Thanks, Mel

This one is worth the time typing if someone can come up with an answer. I have a startup script that does various things depending on the users PrivilegeSetName. For some reason, no matter who I logged in as, FileMaker would see the user as [Full Access]. I spent hours doing this and that trying to figure out why it was doing this.(of course I saved a copy of my original startup script before the research began) I tried renaming the file and every other stupid thing I could think of. Finally I created a new script called TestStartup. I then copied ALL of the code from my original startup script and pasted it into the newly created file AND IT WORKED. This one i…

Is it possible to have a script load a table with the names of all files currently in a specified Windows directory? I'm trying to inventory the directory by file types, so I don't need the contents of the files, only the names. I thought I had seen an example of this posted on the forums, but numerous searches haven't come up with anything. Thanks for any help.

Hey-ho, all-- Can anyone tell me why this script is not auto-inserting the text into the chosen field when the appropriate condition is met? After creating a record and entering M30001 in the Press field I can then perform the script manually and it works properly. What am I forgetting? Duh, the first thing I forgot was the script: [color:black]Script Title: Auto Insert M30001 WG [color:red]If [ ImposeCoverSheet::Press = "M30001" ] Perform Script [ “M30001Webgrowth” ] End If Script mentioned above: [color:black]Script Title: M30001Webgrowth [color:red]Insert Text [ ImposeCoverSheet::Web_Growth; “M30001 - Y web = use "Web Growth 0.5_Ba…

Isn't it possible to let the scriptmaker stay opened all the time? How do you handle this if you write new Projects and always have to open the Scriptmaker? Clickmania Is there no other way? Other programms to write scripts? I am a littlebit frustrated : sorry.

Hi, I am looking to use script parameters to avoid having to duplicate scripts with only minor changes. I have a global variable of $$OutputMode and this is a "V" when report is to be viewed on the screen and "P" when it's to be printed. I have an If statement in the script that runs depending if its V or P. Problem is that I don't know how to set this variable when entering the script. Some information I have points to using the script parameter of (for example) $$OutputMode="V" but the variable monitor (in 8.5 Adv) shows that the variable doesnt change when passing into the script. How do I change a global variable in a script parameter. Thanks, …

I am very new to FM and I need to figure out how to hide a field and its label in a layout if the field is empty. Any suggestions?

I am trying to figure out a way to automatically launch the ping command built into Windows and automatically put in the address to ping from a field within the FM database. I managed to have the script launch a command prompt window by using the send event command. I think the next step would be to use the Send DDE Execute command, but I do not know what to put in the Topic field of that script step. Does anyone know if this is possible? Thanks in advance for any help you can provide.

Hi I have a script that creates a weekly time sheet for a user, collecting all jobs that they worked on the previous week and if the job is still 'open' then it adds it to the list of jobs within their time sheet. This worked perfectly for over a year until we started to add Intel based machines on OS X 10.4 and now PC's, when they perform this script that works well for most on the network it collects EVERY job and often they have to force quit to exit the proecess. If this script failed completely for everyone I could understand it. They are using version 8 clients, connecting to a version 8 server both with the latest patches. I have tried new pauses in my script…

Hi Is it possible to call a php page from ScriptMaker? I'm transferring some data out of FileMaker via ODBC into a MySQL table. Once the data is inside te MySQL table (which I've already got it to do through the Execite SQL command ), I would like "activate" a php page which runs a script to manipulate that data so it is usable. Is this possible natively or do I have to go through the plugin route?

I have script that does a lot of other thing, but one of the first things it does is run a diffrent script that set 5 variables using the Set Variable command. This works fine on it's own, but when the variable script is called from inside a diffrent script, it skips all set variable steps. Do the all set variable steps have to be wihtin the main script?

I want to open multiple remote files on startup of FMP. I have full access privileges and have the remote files set to open without dialogue as they are opened. Now I want a script or something that will just open all five files without me having to do anything. For now I am opening them under "open recent" but I'm having to open each one individually. Thanks in advance for any help. Mitzi

In the solution I’m working on, I will have a group of users with restricted privileges that do not allow them to delete records, however in one portal I want them to be able to select a portal button and (via a scripted delete) delete the portal row. This is the only instance in the entire solution in which they will be allowed to delete. How do I allow them “full access” to delete only in this portal? I’ve tried FM Help and looked over accounts and privileges and can’t figure it out. This is what the script looks like now and works great for users with privileges that allow them to delete. --------------------- SetVariable [$CopyRowCurrent; Value:TermYear:…

For some reason my if function is not working. It reads: early? = If (date 2 < 7/1/2007; "y" ; "n" ) where date 2 is a date. Now, if I do a find using the criterion < 7/1/2007 on the date 2 field, I get a found set of records, but the early? field for all those records is "n", whereas it should be "y". In fact, all records have a "n" in that field. Any ideas why this formula doesn't work?

I need a timed backup script for 5 big files, but I don't want to close the files. I want them saved daily at a given time as compressed copies to an external server. Is this possible without closing the file? I've tried backup software but it's undependable and has too many quarks. I'm thinking a script may be all I need. Any help is appreciated. Mitzi [email protected]

This on may take one of the more advanced users to answer if it's possible at all. I have a notes database and am going to allow users to edit their notes. I will be keeping track of who has read the particular note that is being edited. When the note is modified, I need to notify the persons that have read it immediatly. The person editing the note is on computer "A" The people that have read the note are on computer E,F and G. Is it possible to trigger a script on E,F,G from the server to notify them of the change? Thanks, Mel

Is there any way of identifying the user that is causing a record to be open/locked? Thanks in advance!

I cant seem to find the answer to this, If I use "Open URL" to open a file, and the file does NOT exist, is there an error generated? if so where can I find this error? is there a Get function? If the file does not exist, I'd like to be able to show a custom box that tells the user. Thanks in advance

Hello all- I've created a staff scheduling database that calculates overtime worked by staff on a daialy and weekly basis. Supervisors enter in a start time and end time for each shift of the week and then total hours worked and overtime is calculated. I am trying to write a script or scripts that will do two things. 1. flash up a warning message when a staff member is scheduled for more than 12 hours of overtime on a shift; 2. Flash up a warning message when there is less than 8 hours between two shifts. I have a field for multiple staff members for each day of the week (for example staff member one's monday hours would be Staff1MonHrs). I think I know…

I am putting together a button that will utilize the send mail function. Can multiple files be attached? I tried to attach 2 files. But when I tested the button only one file attaches. I went back into button setup attach file and both files appear in the "specify file" box but not in the actual email. Or will filemaker only search for one file but in multiple paths?

hi I need to change a positive number to negative number in a script. How can that be done ?

This is a bit odd. With all the PDF support for Filemaker there doesnt seem to be any tool or plugin that can simply READ THE TEXT in a PDF and dump it in a Filemaker field for me? Does anyone know a plugin or tool that can do that? I wanto write an online FM based database where you can upload a PDF, and later search for it in the filemaker database, using keywords. For that I must get the text of the PDF into a filemaker field. Any ideas are MOST welcome! Thanks The Spongebob

Is it possible to define a field in Scriptmaker so that when the script is run the field will be defined and then data can be entered into the field.

In my solution i have a paypal button but not sure how to link this button to my paypal account since paypal generates a bunch of html code for its button creation and the only thing Im aware that I can do in FMP is attach my button to a url. By the way, I don't need for paypal to interact with my solution in any way; I just need to send the user to my paypal account(paypal site).

Hi, I've created this script but is giving some trouble and I can't understand why. I'm using global fields to temporarily store other fields data. Kind of a clipboard for several fields. This is the script. Copy(Select, "Field1") Paste(Select, "GlobalField1") Copy(Select, "Field2") Paste(Select, "GlobalField2")... Then I have another script that does the opposite. Copy(Select, "GlobalField1") Paste(Select, "Field1")... It works well when on Browse mode, it goes totally crazy in Find mode. Any ideas why and how can I fix this?

I am sure it is easy and I am just missing something, but this script is giving me fits this morning. I am trying to run a script that will find all receipts created on a certain date, then print labels for them. I have created a separate label layout, and if I do it manually everything works fine. I want to be able to do everything with the click of a button and a simple input of the date though. When I do the process manually, I perform the following steps: 1. Open New Window 2. Go to Layout (Pre-Paid) 3. Go to Field (Receipt Date) 4. Find whatever date 5. Go to Layout (Pre-Paid Labels) 6. Print Like I said, that works fine, but I can'…

I work at a school and I have an inventory DB. We have several pieces of equipment listed in each room. The second DB is the staff records that from the room number I want to be able to find all equipment and show it on that sheet. If I have a classroom #130 I want to find all of the equipment listed in that room. I attempted to use it even though I assumed it wouldn't work "lookup" by the room # and then show the data but it didn't work (like expected, it shows the first record for every field created. Thanks for any help that can be given.

Hi, I have looked through as many posts as I could, and googled my self to death... I am trying to insert some calculated text in to a specific point in to another field. For example - I click in a text field containing a letter and edit the information. Then I want to click on a button to insert some text from a portal exactly where the cursor was. I have tried 'Insert Calculated Result', but this only wants to insert the data at the end of the field. How can I pass the correct position to the script? By the way...this is a great forum and my first post. Thanks!

Hi, I have a database with a list of clients and for each client you can add a list of enquiries they make. What I want to do is for the enquiry form to appear on a new page when you click a button, so what I'm trying to do is create a variable that copies the clientID record from the CLIENTS table and then automatically pastes it into the ClientID record for the new enquiry in the CLIENT ENQUIRIES table. I'm trying to use scriptmaker to get this to work, and so far I have: - Set Variable [$IDforEnquiry; Value:clients::Client ID] - Go to Layout ["Client Enquiries"(Client Enquiries)] - New Record/Request but I'm missing that vital last line that wi…

Hi. I want my users to be able to click on a button that opens up a blank email with a recipient typed in. Currently the mailto type function also sends it. I just want it to fill in the recipient, and leave the rest blank WITHOUT sending it, so my client can fill the details in themselves. My client uses Outlook, but I suppose it could work for any email client. Anybody know how I can get around this? Greg

My Script is taking all related records from a table and puting them into one text field for easy reading. (The records are all notes relating to a project.) I would like to create a button or a "link" (as you can do with HTML ie. Does anyone know if this is possible with FMP? It would be quite easy if a portal would word wrap but I haven't found a way to make that happen either. Thanks a million, Mel

I am embarrassed to even ask, but I am not finding my answer. Simply, there is the "Open URL" step, and I am adding it to a button. The web address exists in a field, and is formatted correctly. I set the calculation to be the web address field in the "Open URL" step, but in executing, in the browser all I get is local host. Am I missing something, or is FM not able read the URL in the manner I have chosen. Thank you!

Hi All. I have a small filemaker DB that has contacts, jobs and invoices tables. I would like to create a script where i can select a date range from a popup menu to fill in start date and end date based on the invoice date. The invoice date field is formatted "dd month year". How do a make the script to work so it will pick the date range that => and =< ? Many thanks in advance.

I have a script which works great except for one feature of it. I am trying to omit all but the first record in the found set but its not working too well. Nothing stands out for me as to what I am missing in the script area (see "Omit all but the first record" in the attachment) wps_ZipCode.pdf

Another rookie question.... Is it possible to have selected values in one value list checkbox set automatically select values in another value list checkbox set? i.e. VT or ME or NH equal North Atlantic

First of all I have to acknowledge that I have a permanent mental block against databases. I could probably figure this out in Excel and be done with it but I have friends relying on a FileMaker solution. Here's the situation: I have a pile of CDs with lots of document files on them. The files on each CD are indexed in a .txt file on the same CD. The software that creates the files and index has a limit of 64 characters and spaces per field. If a field contents exceeds 64 characters, then the program creates a duplicate line with the same document number, but the info in that field picks up where the text left off in the previous line. Furthermore there are several…

I've got a project where the goal is to figure out when benefits (Dental Insurance, Medical Insurance, Life Insurance) will be available to new employees. The business rules say employees are eligible for benefits after 90 calendar days from the Start Date, but only if there are no absences in that period. If there's an absence, the clock starts over and the employee would have to wait until another 90 days to pass without absence. If a new employee is absent on day 40, they would not be eligible again until day 130. If that same employee were absent on day 135 (after a 90 day period had elapsed without absences), they would still be eligible as of day 130. T…

Hello, I am having a difficult time with a script that I'm writing. I'm looping a delete portal row. Here is my script: Set Error Capture [ On ] Set Variable [ $OldNum; Value:Run:# of Samples ] Show Custom Dialog [ Title: "Change Number of Samples"; Buttons: “OK”, “Cancel”; Input #1: Run::# of Samples, "New Number of Samples" ] Set Variable [ $NewNum; Value:Run::# of Samples ] Set Variable [ $Counter; $NewNum ] Freeze Window If [ Evaluate ( $OldNum ) ≥ Evaluate ( $NewNum ) ] Loop Go to Portal Row [ Run::# of Samples + 1 ] [ Select; No dialog ] Delete Portal Row [ No dialog ] Set Variable [ $Counter; $Counter + 1 ] Exit Loop If [ $C…

What I am trying to do is get this script to use the Custom Dialog Input Fields to ask for search criteria. I'd like the pop up to ask for the report number, put the layout in to Find Mode, set the user entered data to field, the perform the find. I have it working up to performing the find. When the script runs it stops and waits for the user to click the "Find" button (which shows up on the left Menu) in order to continue the script. The report number is set to the proper field for the search, I just can't come up with the "go" command to execute the search. I want the end user to key the report number into the pop up field, press enter and it bring u…

I have server8 and pro8.5 adv How do i schedule a script to run a certain time?

I have modified a FMP template that has buttons that take the user to the Form View, List View, and Table View. I have added other tables to the template and, therefore, have other layouts. Is there a way to script these buttons so that they will show the form, list, or table depending on the layout? Or, do I have to have a seperate script for each layout? I presume it may have something to do with the Get (Script Parameter) function, but I am new to this function, so any advice is most welcome. Thanks. dan

Hello, i was wondering if someone can help me out. i am doing script to send mail. i am trying to figure out is there a way to do Bcc in FM 6.0. using a script. thank you victor

Hi All, can anyone give me the name of a good book on FileMaker scripting?? There are many books about FileMaker but for the most part they do not spend much time on scripting. I am looking for a book that gives basic to advanced examples of FileMaker scripting. Thanks in advance for any thoughts...............Ray

I just add a new column and want to insert value into this column. I want it to be auto insert by auto increment number. How to do that? I use filemaker pro 8.5

I'm trying to crate a script that will let me update the status in my task list from defer to open once the start date is passed Currently the script I have is: If[Tasks::Start Date ≥ Get ( CurrentDate ) and Tasks::Priority = "Defer"] Set Field [Tasks::Priority = "Open"] End If I'm sure it is something simple I'm missing, but I can't figure it out. Thanks for any help, Matt

This is the golf course solution I recently spoke about. I have finished all the layouts and navigation and I think I have a handle on the printing of receipts and daily reports. Where I need your collective guidance is the scripting of the flow of a typical transaction as follows: Golfer wants to play 18 holes of golf and rent a golf cart. Normally he would present the cashier with a membership card which the cashier would scan. The 5 digit bar code (a Unique number) would be input on the transaction table layout as a new record in the member_id field. The program must first check to see if this unique number has been used today and if so, the cashier will make…

Hi all, I'm not sure where to post this. On some of my databases when I open them I get a Dialog and progress bar that states it is "Scanning for Unused Blocks" What is going on here and can I do something to clean my data to prevent this from happening? I have tried compacting and or recovering and it does not seem to help. What are the "unused blocks" that are being referred to. Thanks, Steve

please help again, i need a script to do this: i have a field (field1) with number values. what i want to do is to find the value on that field (field1) which is equal or the first greater than value to the value on field2. and put tha3 value on field3 which is the opposite on a new field via a script. for example: field1 - fiedl3 3 - 4000 4 - 5000 56 - 5600 78 - 6400 90 - 6800 102 - 7000 120 - 7200 on field2 for example the value is 101 so we know that 102 is the first greater than value to 101. so field 3 should contain the value 7000. i hope i explain myself.

Can anyone tell me why the following scripts steps don’t work? If [Get ( PrivilegeSetName ) = "[Full Access]"] Install Menu Set [“Custom Menu Set”] End if Everything works fine if I replace the steps with: If [Get ( AccountName ) =”Admin”] Install Menu Set [“Custom Menu Set”] End if

I have a database with a little more than 1 million records where a very simplified version of 1 table looks like this. Record.....ID_Field....Log_in 1.............1234........1 2.............1234........2 3.............1234........2 4.............1234........4 5.............1234........2 6.............1234........3 7.............1234........4 I need to run a looping script that will look for the highest number in field 2 and then assign it to all of the records in a third field so it looks something like this. Record.....ID_field....Log_in.....NumLogIn 1.............1234........1..........4 2.............1234........2..........4 3......…

Hi, all - A client is interested in getting a document control system. Before he does, I want to explore the option of using FM Pro for this. There's a template called "Document Library" that is a pretty good start. What he'd like to do is to see a thumbnail of the document from within the database (perhaps we can create this and store it as a separate object), and then be able to open the document from the DB as well. Is this just a pipe dream, or is there a way to do it? Thanks...

In a report with several sub-summary parts, page-breaks between parts can separate items that must be seen together. There is no obvious way to prohibit page-breaks between two parts or to force a page-break before a specific part should it occur at the bottom of a page. Is there a work-around for this or has FileMaker actually created a function that is virtually useless for creating reports with an acceptable appearance?

Let me try and explain what I am trying to do. I work with youth. I have multiple tables and the youth are working on various things like sports and reading. I am trying to keep track of different requirements that are set for sports and reading. If they complete all of the requirements they are rewarded. Now for example if one of the youth reads a book about sports then it can satisfy two requirements. One under sports and one under reading. I want to create a script so that when any of the counselors clicks on a button it will check to see if one of the fields, in either sports or reading, has a date entered. If it does then it will automatically enter the …

Does anyone know of a script (or other method) to have the text color of one field reflect the contents of another in FM Pro 7? What I'm trying to accomplish is to have all my Sr. students show up in one color of text, my Jrs. another and so on and am looking for a script to execute this? Anyone?

hi, I have a portal in which dates can be entered (only saturdays). I also have created a field first_saturday and another field number_of_saturdays. What I'm trying to get is if i enter 26/05/07 in the field first_saturday and 5 in Number_of_saturday, then in the portal 26/05 will be in first row, 2/6 second, 9/6 third, ect and this depending on the value number_of_saturday. So far, I've only managed to automatically have 26/5 in portal (by copy and paste) and 2/6 with a calculation first_saturday +7... but don't know how to get the loop for the remaining . Hope someone can help. regards

Hi, Is it possible to start FM without having the Open window ? I have a VBScript that I want to execute everyday using the Windows task manager. Here's the VBScript : Option Explicit Dim Oshell Dim strCmd Dim FMApp Dim FMDocs Dim myOpenFile Set OShell = CreateObject ("wscript.shell") strCmd = chr(34) & "C:Program FilesFileMakerFilemaker Pro 8.5 AdvancedFilemaker Pro Advanced.exe" OShell.Run strCmd, False 'wait 10 seconds for correct start wscript.sleep 10000 Set FMApp = CreateObject("FMPRO.Application") Set FMDocs = FMApp.Documents Set myOpenFile = FMDocs.Open("C:FileName","User","PassWord") myOpen…

Please forgive this newbie question, but I can't quite figure it out: I'm trying to use the GoToPortalRow[by calculation] script step to go to a row in which the value of relatedFieldXYZ (which is a field within the portal) is "foo". So, if the field in the third portal row contains "foo", go to row 3. Using Go to Portal Row [Line_Items::relatedFieldXYZ = "foo"] doesn't work, nor does a couple other things I've tried. How is this accomplished? Many thanks--

I'm using Set Variable to set date boundaries for a find I'm performing but I'm having problems incrementing the date by this method. Set Variable [$Week Start; Value:$Week End + 1] Where $Week End is a date If I don't include the "+1" Set Variable sets $Week Start equal to $Week End in the form of a date fine, but when I add the "+1" $Week Start is treated as a number not a date and also it also only increments the last digit i.e. the year instead of the day which is what I what. I'm not sure what I'm doing wrong - is this the right way to be doing this? Thanks in advance. Graham

There is a great custom function for mac to upload a file to an ftp folder via curl and apple script. 1. Does anyone know if it is possible to write a script to delete the file from the directory? 2. Has anyone seen the equivilant for PC

I am trying to get the next serial value as : GetNextSerialValue ( Get(FileName) ; Billing cases::Case ) But no value is returned ?? Also SetNextSerialValue is not seting the value either ? Anyone has this problem with FMP 8.5 Advance ??

I have gotten myself into a rather tedious scripting scenario. I have a rather large script (about 300 steps, many of which are repetitive.) Is there a way to speed things up at all when duplicating large numbers of steps. I would take any of the following suggestions: 1. Export the script to plain text and re-import when finished. 2. Copy blocks of the script and move them as a block (I can only seem to move one step at a time, not a block) 3. Any way to actually enter code directly, not via point and click. I am running FileMaker Pro 8.5. I have a feeling I may need FileMaker Advanced to do some of these things...please tell me I'm wrong. Thank…

I host a FM database online that several people in my company access from different locations. I recently built a series of scripts that pull a list, sort it, and save it to my desktop. When my co-workers try to run these scripts, they get an error message because FM is pointing the document to save on *my* desktop. Is there some way to save to a relative filepath (like filemac:Desktop/filename.xls), so that no matter who runs the script, the file will be saved to the desktop of the computer they are using?

I know there are threads for this, but it seems like a lot of work for a simple calculation. All I need to do is take current date subtract 30 days and have the records displayed. I think I will use a portal for that. Looking to create 3 or 4 buttons with 30 60 90 and 120. Click on the button run the script. Is there anyway to take // - # of days? Sorry I am from the Access world and this seems a little strange to me. Sharon

Hi all, I am a newbie here so my apologies if I stumble. I am a marine biologist working with a database of ~2000 records of encounters with groups of killer whales. Each record is one encounter, and I have a field called "Individual ID" in which up to 30 individuals are listed, space delimited (eg "T001 T002 T002A" etc). What I want to do is to parse this data so that it is organized by individual, rather than by encounter, with all of the relevant data for each encounter associated with each individual. In a separate table, I have a list of all the known individual whales (n=300). I'm thinking that what I need to do is create a script that looks up the…

I am having a little trouble with a script that looks for a related record and if it doesn't find one, creates one by netering a value into a related record. It works fine, except that if there is no record, it enters the serial value, but then doesn't update the record in time to show on the layout for the related record. The serial appears empty until the next time you run the script. I have even tried looping it round twice, but that doesn't work either. Its probably something really stupid that I just can't get my head around - any ideas out there for this one. Many thanks in advance for any hints, laughter or abuse. Tol If [ INVOICES::IN…

Hi, I'm having trouble figuring out why ValueCount always return 1 when I trying to count the number of values in a repeating variable. Here's is my test Set variable [$test; Value:1] Set variable [$test[2]; Value:2] Show Custom Dialog ["Test"; ValueCount($test)] I'm sure the answer is very simple, but it's just not coming up right now...

FMP8 Adv, WinXP In FMP5.5 I used this script successfully to move the cursor to the next line in a text field (list of items). Set Field ["ItemField", "ItemField & """] This worked great in FMP5.5. Then with a subsequent SetField, I could enter another value and it is placed properly on the next line under the first value and the cursor moves to the next line, etc, etc. In FMP8 I need to do the same thing (i.e. move the cursor to the next line in order to be in position to accept the next value) but the same script isn't working. Set Field [TableName::ItemField; TableName::ItemField & ] This returns the cursor to the next line OK, b…

I have two related tables (Table A & Table that are linked by one field: contact id (number field). I would like to be able to use the contact id field in Table A. to check for a matching id in Table B. Then, once I identify those records in Table A with matches, I would like to display them in a list layout. I know how to display them but not sure how to check the two tables for matches. I'm sure this is simple, but i can't think of anything now.

Is there a way to perform a script based on a calculation. Similar to the go to layout step?

Hi All - First timer so please be kind. I have been trying to write a script to save 23,000+ records into individual .pdf's by automaticaly using the first name and lastname from my fields. Alas, I have found that I am not that smart. Is there someone that can help me? I hope! Thank you in advance. Jenny B

I have a search page on my database to search a certain table. When i click the search it performs a script which enters find mode allows me to enter search criteria and then view the relevant records etc... But i want a button on the criteria input page which will cancel the current find script, go to browse mode and then go to the main menu layout. My main problem is knowing how to cancel the already running script... help please?

Dear Friends, I am looking if some one can help me in writing a script which could bring GPS coordinates (Long, Lati) from Palm PDA or iPaq 6515 to filemaker mobile field. Thanks in Advance for your help. Regards, Tusif Ahmad Filemaker Developer Perth, Australia

How do I setup a username and password so when a url is opened the user is signed in?

I have a field that is a Yes or No Radio button. I am using the visibility trick to show or hide some items in a portal. It works well, except that if you make an entry to the Yes or No radio buttons, you then have to click somewhere else on the layout to commit the record, and thus show or hide the items in the portal. This will do, I guess, but my preference would be that a click on either radio button would automatically commit the record, thus revealing or concealing the objects in the portal immediately. If anyone has a notion of how I might accomplish this I'd be interested to hear about it.

I would like to create a script that will take all the records from Table_A and create a find request for each in Table_B. The user will enter their request in Table_A as a temporary file so that they can evaluate the data prior to submitting the find request (like a shopping cart). If someone could point me in the right direction as what script commands would be best I would appreciate the help. R

This is such a simple question, I'm sure it's staring me right in the face. Is there a function that allows me to program a "BACK" button to go to whatever the previous layout was? I have one layout that 4 different layouts (representing 4 different workflow tasks) lead to. Right now, I'm creating multiple versions of that one magical end layout with a back button that leads back to one of each of the previous paths. Is there an easier way? I'm hoping a sage FMP developer will help me with this problem. Many thanks in advance, DB Gal

I am seeking help in creating a script that will perform multiple finds on user input data. Using a bar code reader the user will enter his/her requests (approx 20 entries) into a temporary table. The user will then run a script to search for all items within this temporary table. I suspect that I will need a looping script but how do I import the records from the temp table into the Find mode (create a new request for each entry)? Thanks

Hello, I am using FileMaker Advanced and have been having some problems with the Send Event Script command for windows xp. I am attempting to execute a program to parse a file into csv for importing. It is written in C# 2005. The problem is it is intermittent on wether it will throw an error. The program works perfect when i execute it manually. The problem is that after closing filemaker and openting up the script i have to redefine the file reference of the exe in order for it work work. if i skip that step then it will throw an error with my application. The EXE does not use the command line for extra configurations option so it cannot fail because some extra character…

When using the Send Email function in the subject line can you specify more than one field?