Script Workspace and Script Triggers

Hi, How can change layout size according with user's desktop windows size, after he/she open database?

I cannot now reproduce this behavior... but with a given type of field ( I do not remember ) the script step: Perform Find/Replace has created four local $vars: $null $CLRemainder (with reps) $CLn (with reps) $CLExeCount They were visible only with the Data Viewer. Does anybody know anything about them ?

In all of my fm databases, I find that having a logging table is very useful. I've created some scripts that do this : Log($msg, $severity, $user...) // adds a timestamped log message to the log table with given severity e.g. PerformScript("$msg=\"Bad error occurred in XXXX\" ; $severity=\"Error\" ; $user=\"" & Get(CurrentUser)& "\";") However, the actual script is not very fast or efficient, as it basically does this: * create a new window showing the log table (or show it if it's already open) * create a new record in the log table * fill in the fields * commit * close or hide the log window The reason that I use a separate…

I remember once seeing, what I believe was a plugin product (I'm guessing from 360works), that lets you search for scripts based on things like what functions it uses (and maybe what fields it sets). I'm returning to work on a database I haven't touched in a long time, with about 300 scripts. I'm having a lot of trouble remember which scripts do what. I'm thinking something that lets me search like that would really help, so if anyone could help me remember what I'm thinking of, I'd really appreciate it.

I have created a script to renumber a field across a set of portal records from within the portal itself. It works ok (attached) but I just wondered if there was an easier way. I want the first portal record to be given the value of 1100 and every subsequent record plus 10 i.e. 1100, 1110, 1120 etc. I also noticed that when I ran my script with a looped exit after last record it added a record at the end because the relationship between the two tables is set to allow the creation of records in that table. I don't want it to do this and got round it by using an 'if' function. Would someone be kind enough to see if my script would be similar to the way that you would d…

Hi All, I have a radio button on one of my layouts which belongs to a "I have read the terms and conditions...." action; the button must be selected in order to proceed to the next step. My script is defined: If Is Empty(radio button field) SetField (message) "In order to proceed you must agree..." Else Go to Layout XYZ I put the script on a NEXT button and if only clicked once this script runs fine and only if the user selects the radio button, he can get to the next layout. But if you double click the button (which many users my do) it jumps the script and goes to the next layout which it is not supposed to do. Can anyone tell me why this i…

Hi all, Hope you might shed some light on this issue. I am writing a script to sync information between Filemaker Pro & Go, but the record import process is behaving strangely. Basically, for each table I want to synchronise, I have a batch of 4 scripts. This consists of 3 "doing" scripts, and one "controller" script. The controller script simply performs the 3 "doing" scripts, in order. I have 6 tables. Each has its own set of 4 sync scripts, which are mostly identical, except of course to reference the table I'm syncing at the time. *********** Now, obviously I want a nice big "Sync Now" button. This button performs one more script, which…

I am trying to write a script that will show all records that begin with ''a', all that begin with 'b', all that begin with 'c' etc. Each letter of the alphabet would have its own separate script (or all of them combined into one, if possible) This searches cell 'Name' of every record for instances where the leading character is 'A' or 'a': Sort [Restore,No dialog] Show All Records Go to Record/Request/Page [First] Allow User Abort [On] Loop if ["Left(Name,1)="A""] #Show this record The problem is here, I am looping through each record, and it determines the appropriate records alright, but how do I get it to display all of those records and only …

Hey Gang, i was looking around but could not find how to show the magnify glass like in Filemakermagazine's videos. I am trying to put some videos together that i think others should do, but would like to magnify certain areas to show better. Anyone know how to do this if they have seen Matt's videos showing the magnifying glass and it grays out the rest of the screen? thanks in advance, -ian

I would like to script the page number into a defined field so they can be reused later in a contents page. Unfortunately I don't seem to have the right technique. (see attached file). At the completion of the script the first record shows the total number of pages and the other record shows zero. in summary the script is Go to Record/Request/Page [ First ] Enter Preview Mode Loop Exit Loop If [ Get(LastError)≠0 ] Set Field [ test::pagenumber; Get(PageNumber) ] Go to Record/Request/Page [ Next ] End Loop Set Field [ test::pagenumber; Get(PageNumber) ] Go to Record/Request/Page [ First ] Enter Browse Mode test.fp7.zip

I use FileMaker Pro 6 on an Apple MacBook running system 10.6.8 and I use AppleScript extensively. I modeled this statement directly from an example script which came with the app. tell application "FileMaker Pro" do menu menu item "New Record" of menu "Records" end tell When I run the script, I get the following error dialog: Does anyone know how to fix the problem or at least how I can find out what error -10000 means ?

I have provided a sample table from a budget database that has both monthly & quarterly bills that will be due. I am experiencing problems pulling both monthly & quarterly bills due. I would like for the user to input term (ie Fall) and academic year (ie- 2011-2012) and have the results be both any monthly bills that fall between the billing_begindate & billing_endDate and all quarterly bills that are Fall 2011-2012. I have a script List_Billing_Monthly- and it’s working- based on the c_test=Active. I would rather not have the calculated field that says pull this monthly bill. I would like to delete the c_test field and just use a script to get t…

Howdy, I'm trying to create a script trigger. I have several fields and associated "comment" fields. Like this: abc abc_comment defg defg_comment The trigger would be if the abc_comment field has text in it, put a "Y" in the abc field. I'm sure it can be done, but I'm not smart enough to figure out how to read just the first part of the field name and parse out the "_comment" part. I'm currently using the function below to get the name of the active field. GetFieldName ( Evaluate(Get(ActiveFieldName))) Any help is greatly appreciated. P.S. I guess I could rename all the fields so that they have the same length before the "_comm…

First off Hi! This is my first post here. I'm new to database creation and have been working with FM8 pro on a venerable G4 mirror door Mac running Tiger to develop an estimating and works order solution for our small print business. It took me a while but I found most of the logic quite straightforward and to be fair it still is a work in progress. The estimator is reasonably versatile and seems to run really well, but occasionally when I'm out of the office there is a need for the document to run on another Mac via file sharing. All well and good but really I'd like a script to autoclose the file when it's been idle for say 15mins thus allowing it to…

The following is supposed to look for and close any windows belonging to the open database when the main window is closed. I’m sure I’ve tested it successfully, but now it goes into a never-ending loop. Loop Exit Loop If [$WindowCount = 0] If [ValueCount (WindowNames (Get(FileName))) ≥ 1] Set Variable [$WindowCount; ValueCount (WindowNames (Get (FileName)))] Close Window [Current Window] End If End Loop If I make the third line: If [ValueCount (WindowNames (Get(FileName))) + 1 ≥ 1] it closes the frontmost window leaving any others open. If I create a field with the unstored calculation: ValueCount (WindowNames (Get(Fi…

My clients have requested that I combine 3 reports into one. Table 1 (Parent) Jobs (Job ID, Customer) Table 2 (Child) TimeLines (fkJobID, Date, Employee, Start, End) Table 3 (Child) EquipmentLines (fkJobID, EQID, Date, Start, End) Table 4 (Child) NotesLines (fkJobID, NoteID, Date, Start, End) Currently I report on each Child table. My clients want the report to look like: JOBID (from Table1) Date, Employee, Start, End (from Table2) Date, EQID, Start, End (from Table3) Date, NoteID, Start, End (from Table4) Should I combine Table2-4 into one large table? (would be a major rewrite), loop script to copy re…

Is there any way to specify a table by calculation in Goto Related Record? Pretty sure the answer is no, just looking for confirmation i guess :)

I have set up a Preferences table finally. I just read again about it being important and that everyone has one. Everyone talks about it but nobody says how they keep to one record. So even though my file will have hopefully correct and tight privileges and even though new records will only be allowed by button, I need to stop new records from ever being allowed in this table. Only one allowed. And if one doesn't exist, create it maybe. Or am I worrying too much? I first looked at field validation then layout triggers. Not sure where to even post the question, to be honest. I should add that I tried using unique serial with ID 1 and then validate Se…

So this is kind of simple, but I can't make it work: I have three fields that I want to be filled according to number of characters: field 1 gets the largest number of characters and field 3 gets the smallest. I have a script that works for fields 1 and 3, but the middle-value field won't work. To fill fields 1 and 3, I'm saying If [Length ( db::sourceField2 ) > Length ( db::sourceField1 ) and Length ( db::sourceField3 )] Set Field [db::fieldText1; db::sourceField2] Else If [Length ( db::sourceField3 ) > Length ( db::sourceField1 ) and Length ( db::sourceField2 )] Set Field [db::fieldText1; db::sourceField3] Else Set Field [d…

I have a database of contact attempts. Every time a salesman makes contact with a client, be it by e-mail, phone, sending a fax, whatever, they make an entry in this table. I sort these records first by the user that created them, and then by type. On my layout I have only subsummaries, one for sorting by user, the other for sorting by contact type, so when I sort I get a header with the person's name, followed by 1 "line item" for each type of contact with a count: example: *James * 9 EMail 1 No Contact 1 Order 2 Fax The contact types (email, order, etc) are in an editable value list. We allow new types to be created arbitrarily. What I'm lo…

I have a report. One of the fields in this report is EmployeeName, which is auto-populated by the system which generates the report. This field contains user IDs pulled from employee accounts on other in-house systems. There may be some variety. For example, John Doe might sometimes appear in the report as "John Doe," and at other times "JD.." or "jdoe001". I need a means of maintaining a list of employee names and their various aliases. I suspect a table is more appropriate than a list. This table would contain two fields: EmployeeName and __kp_Alias. Then I need a script that will systematically check the contents of EmployeeName in all records, and substitute…

Hi, I have quite a few scripts that perform finds for "2011" as a text field. Is it possible to make a global variable $$CurrentYear so that I don't have to manually go through all these scripts every year and update the year number to the current year. Thanks, jim

Hi Guys, wondering if you could check over this script. I have an job order i need to converted to an invoice. I can get most of except, these invoices are created by the user selecting which items from the job order to be invoiced. Again no problem. what I am trying to do is warn the user that if they select an item already invoiced, please try again. But I am stuck. The first check is to see if they want to create a second invoice most time they do. ==Create Invoices==: Create Invoices # Allow User Abort[ Off ] Set Error Capture [ On ] # If [ Invoices_From_Jobs::id_joborder ] Show Custom Dialog[ Title: "Transfer Error"; Message: "An INVOICE has already …

I am trying to create a scheduling database to show a weekly view (Monday-Saturday) of courses booked 7am-10pm. I am trying to get a script to create new records in the Calendar table for Monday 7am-10pm in 5 minute increments. I have 1 record Day Time Monday 7:00:00 I have a script that is adding 300 but it won’t recognize the previous record's time of 7:00:00. I have attached my attempt. Any assistance would greatly be appreciated. scheduling-test.fp7.zip

Hi there, I have set up a script to export records from one table creating a file on the desktop called 'Lists.xls'. It saves to a worksheet that is created called 'Families'. I would like as part of the same script to also export the list of Students to another worksheet called 'Students'. Is it possible to export multiple sets Records to different worksheets all within one .xls file? Thanks so much for your kind help. Have a great day, Maria

There's a topic from a couple of years ago on this very subject ... but it was never really resolved. http://fmforums.com/...cript-on-enter/ In my specific case, I have a layout with a single field on it. The field is set with "Go to next object using Tab/Return/Enter". I want the script to trigger with the user types a word and presses Enter. It's the simplest case of all. The OP reported he got it to work ... any idea how? Processing individual keystrokes introduces a slight field flicker on the layout, so I want to avoid that. Thanks for any assistance.

Hi, I need some help, I have a field in a database called "Project Number" this field has a format PXXXX-Y in a drop down list, so user cannot modify the field. I am required to replace this value so that if the user want to print an invoice, the project number is automatically changed from PXXXX-Y to PXXXX00Y in the invoice layout. How does the script look like if I want to implement this? Thank you for your help

Dear all, I have a list of refrees in premier league which consists 40 entries. There are 9 matches each week in the league. For every match must one refree, one fourth refree and two assistant refrees be appointed. All I want to do is an automatic appointment of the most appopriate refree by File Maker. The criterias are as follows: -When one refree is appointed for a match, next two weeks he cannot be appointed for either of the teams. -He must get at least 8 points by an observer, otherwise he cannot be appointed for a match for one month. -There is an exception list of refrees. There will be a weekly exception list. If the refree has indicated an exception, …

Hi, It's been so long since I've had to do any maintenance on my database that I'm having trouble remembering how to do this, and possibly never even knew how to do this. I want to change a date from dd/mm/yyyy to mm/yyyy format for a PeriodEnding field via a script. I know how to do this as far as in the field in the layout but I then have to export this PeriodEnding field to an excel and therefore I need the date to appear as mm/yyyy in the excel and not revert to the original dd/mm/yyyy. I also need to calculate in a script, the PeriodBeginning field to be 3 months before the PeriodEnding field. eg if the PeriodEnding field is 06/2011, I need the Perio…

Is there a way to sort/resort portal data using a script? For example: If I have a portal that shows Client, Product, and UPC information, can I set up one button for "Sort by Client," another for "Sort by Product," etc.? I know in layout mode I can choose how a portal sorts information, but is there a way to set up scripts so that the user can change how the portal sorts rows?

Can we resize the image size in FileMaker application through script?

Hey, guys. Just a quick question for clarification. I have a script that involves a lot of IF statements. I want to make a sub-script that I can call via Perform Script, so I don't have to have a 1000 line script. If I set variables in the main script that I want to use in the sub-script, do I need to set those to global variables?

Hello Everyone; I have been working on a file and was just playing around with GTRR & FIND - I have attached the file for anyone to review; THere are no safety checks, etc, just doing some testing. Should i use the GTRR or Find method? or is it just a matter of doing the same thing another way. thanks -i cupcakeFriday Copy.fp7.zip

My records have the fields State and City. I’m having trouble creating a report that totals the costs for each city and the costs for each state (which is the sum of the costs for each state). I want the report to look as follows: Tot cost is a summary field that totals the field cost. State1 City A Tot cost City B Tot cost Subtotal Tot cost State2 City E Tot cost City F Tot cost Subtotal Tot cost Grand total Tot cost To do this I’ve tried the following layout: Sub-Summary sorted by State (leading) Sub-Summary sorted by City (leading) …

Sees like a simple problem, but can't solve it. My script in File 1 says: Copy number in Field A in File 1 Go to related Record in File 2 Go to Field X in File 2 Paste number in Field X of File 2 For some reason the third step fails. The cursor won't go to Field X. The first two steps are fine, and the fourth one is too (because If I put the cursor in Field X and do Apple V, it pastes the copied number). Grateful for any ideas. Philip p.s. I've read elsewhere tha one slution may be to add 'Exit Script False" to the script if the first script is triggered by a script trigger, but it isn't.

I have a portal in Members. The portal field contents are the object of several scripts for error checking, input etc... One script issues a command: Set Field[Dues::Status; "Late". The problem is (and I can watch it happen in the debugger) when this line is executed, not only is Dues::Status assigned a value of "Late" but the Dues::Date field is assigned a value of 02/09/2012 (Or whatever todays' date is) Huh? Help is greatly appreciated. I have never run across anything as weird as this.... Thanks Ron

Hi, I am just wondering how to see the variable "currentList", "existingSelection", and filteredList inside calculation. The debug tool in filemaker advanced didn't have it. Many Thanks. Kent

I really thought this was a FileMaker no-brainer but it's turning out to be a Richard no-brain. :S I have a script step in my runtime solution--that I'm coding on a Mac--that sets the current date for a Date field: SetField [WEBSITE::LastVisitedDate__lxd; Get(CurrentDate)] The Date field, in the Inspector, is set to "As entered" and File Options [Text] is set to "Always use current system settings." The computer's Date & Time Preference is set in Language and Text > Formats as Custom with the "Short" date format set to 01-05-2012. The problem is that when the script step runs it inputs the date as 2/12/2012 instead of 02-12-2012. However, if I c…

I have inherited a field with multiple values in it, and sometimes the first line is empty -- in other words, the first character in the field is a carriage return: ¶ How can I simply strip out gratuitous leading (and for that matter trailing) ¶ 's ? I'm thinking there's maybe something like Trim(text) for carriage returns -- or how do I seek and destroy these pesky characters? Thanks

Hello all! I created my first database and then I created a runtime solution, in order to share my work with people that don't own filemaker. So far, so good and I admit that I am in love with filemaker! My only problem is that, when the .exe file opens, the user sees a big window in the back (and of course the small window with my program in the front). I created a "open" script hiding all the menus, (as the only thing that my user needs is to use the buttons) but how can I remove the "back" window? I want my user to see only the application! I have "painted" red the window that I want to get rid of, in order to help you understand what I want to do... …

Hi there, I have a databse of children's games that is searchable by any number of criteria, e.g.; Topic Age Language Skill Group size etc... Once the teachers search for their game, how could I display at the top of the page the exact search terms they used in their perform find for example: Clothing 4-6 year olds Speaking activites (These are all searchable items) I imagine I need to $Set Variables at the moment of seach and then paste those variables into a global field placed in the header? Or am I way off track? Thanks so much, Maria

I would like to use the summary of the found set and use it for printing reports in another layout(table).The problem when I use the total fields in another layout I get the total of all records and not the total of the found set. Getsummary doesn't work for me .I need some tips to make this work. I want to use the total of flight hours during date range, and I need this total to print to aircraft logbooks.

Can somebody show me a script to search a field in all records, look for extra space at the end of the value, and delete it? In our company's contact management dbase, many of the users accidentally add a space at the end of a company name, and then the company appears twice on value-based drop-down lists ("solar city" and "solar city ").

Hello everyone! I have a Human Resources database that is served and currently runs in a multi platform environment. At the request of Management, I need to rebuild my security badging system so that it functions on a PC with some new photo software. I want to be able to mimic what I had running via AppleScript on my Mac. I did some quick research and couldn't find a straight answer. Can anyone help me with the Send DDE Execute script step to create a couple of scripts that can open and close a file named inPhoto.exe? Thank you in advance, Justin

Hello I have a script sequence as follows go to Layout A go to field A pause paste go to field B pause paste go to field C pause paste I paste various Items text and pictures I have several cut-paste steps However while the order of fields and pasting is always the same at times I do not have enough data to paste. Is there a why to halt the script not clicking the "Cancel" button and add a script step to open another script? Something like if "cancel" perform script B end if thanks a lot but I couldn't find an answer so far in google Regards

Hello! I have designed a database with a field which is a drop-down menu with only two options, lets say "optionA" and "optionB". What I want to do is, when someone is in find mode, and sees only x records out of y, to be able, by pressing a button to change all "optionA" values to "optionB". What's the code for this button? Thank you in advance!

Hoping for some help from you AWESOME people!!! I'm trying to validate time entries from a relationship, the problem: the time entries are entered into a portal and the records do not commit to trip the validation error. here is what I have: Job table (jobID, Customer, EmpID) time table (FKEmpID, date, timestart, timeend) layout based off of Job Table, portal to times. I'm looking for a better way to prevent overlapping time entries. Maybe i'm on the right track, I don't know.. still a newb. ATTACHED: a sample of the issue. More details inside the file timevalidation.zip

Hi guys, Not sure if this is the best place to post it, but I've searched and can't find a solution. Is there a script step (or a workaround) to force a web view to reload? I'm currently using the Filemaker Wordpress plugin to sync various fields with a Wordpress website. Works great, but there are a few fiddly custom fields and other elements that don't work with the sync, so the user has to interact with the admin page of the Wordpress back end. It all works fairly well, except that if the script I use to update the Wordpress page runs then the web viewer to the right of the page doesn't reload, so the new information sent to the page doesn't show up. If the u…

Hi, I am trying to figure out why set field has ¶ sign. In the output, the kf_OrderNumSelected column has only "1141" in the column for all records. Thanks. K.C. customer_ORDER::__kp_OrderNum & ¶ & CUSTOMER::_kf_OrderNumSelected

HI, I've got an English teaching Children's games database. One of the fields is 'Topic' (animals, clothing, foods etc. ) which also includes 'Flashcards' which are games where any topic can be taught as long you have the flashcards for that topic. Teachers search for a topic, but can also check a 'Yes' in a field called 'Include Flashcard Games' My perform find script goes as follows: If [GamesBank::Include Flashcard Games="Yes"] Clear [select;GamesBank::Include Flashcard Games] Perform Find [] Commit Records/Requests [] Extend Found Set [Restore] (Gamesbank::Flashcards) Else Perform Find [] End If Go to Layout ["S…

When running the AppleScript the first time a new record in the sdhcCARD table gets created and the cells ("_EmptyingSDHC", "_EjectSDHC") get updated correctly. The next time the script is run a new record gets created, however the cells "_EmptyingSDHC", "_EjectSDHC" of the first record gets updated not the new one. Everything stays blank on the new record (i.e record #2). If I run it again a third record gets created and the cells "_EmptyingSDHC", "_EjectSDHC" of the first record gets updated not the new one. Everything stays blank on the new record (i.e record #3). I've tried using something like current record and it did not make any differences. I ma…

From a google search, I see there is no easy way to see which various accounts are currently logged in from around the globe either on IWP or locally. Get (User How would I setup a startup script to Get (Accountname) and paste it into a field along with logon time and then delete that data from the field with an exit script. I have tried 'IF' but I just can't get it to work. Thanks so much, Maria

It is me again. I found so many hits when I searched script parameter I realize I will never find what I need. Even only looking in Managing Scripts the list is too long. I have script which has a script parameter on it. This script runs a subscript which needs this parameter. I know I read to 'pass it' somewhere but it was ever explained how. Can Exit Script Result[] be used? the Help on it is very confusing and so are the script examples they show. I just need to use the original script parameter in the subscript. How to pass it?

Hi I have a huge amount of photographs that I would like to be able to search on by keyword. I have set up a basic db with the following fields: Thumbnail : Container; the thumbnail image imported from the specified directory Path ; text ; the pathname to the file FileName ; text ; The name of the actual image Photo ; container ; the actual photo itself Keywords ; text ; keywords associated with that photo The idea is that I want to import all pics from 1 directory and all of its subdirectories. No problem here, works fine importing the thumbnail, file path and file name. I then want to search on the keywords to narrow down the viewed thum…

I have two databases related by the fields: File_No = File_No Date = Date (Taken together, all records are unique.) The databases are called Electronic_Recording and Transcript_Requests. If someone requests a transcript of a recording after an employee enters a record in Electronic_Recording, someone else creates a new record in Transcript_Requests. As soon as they enter the File_No and Date, most of the fields populate by "lookup." Quite often, a transcript is requested immediately. I was wondering if there is a way to script a new record in the Transcript_Requests database from within the open Electronic_Recording file. In other words, if an employee cre…

Hi to all, I am pretty new in creating databases, so I ask for your patience. English is not my native language, so I may do few mistakes. I ask for your patience I am creating a database. What I want is to create a dropdown list with three choises. When a user selects, lets say "Option A" I want a specific image (such as image-a.jpg) to appear in a certain field. When he chooses "option B" another image (image-b.jpg) should be "attached" in this particular field and so on. What are the steps that I have to follow? Please try to be as specific as possible! Thank you very much for your help! George

FM 11 Advanced I always thought that to suppress an error message when no records were found that you needed to have an if statement immediately after the find to capture the error code. I use the following script steps to allow the user to do repeated finds until one of them is successful. It does not even use an If statement, and the error message does not appear if a find fails. It does however use an Exit Loop If statement. Allow User Abort [ Off ] Set Error Capture [ On ] Go to Layout [ “Find customer” (Customer) ] Loop Enter Find Mode [ ] [ Pause ] Perform Find [ ] Set Variable [ $E; Value:Get ( LastError ) ] Exit Loop If [ $E ≠ 401 ]…

Small mess to clean up: I have two street address fields: street_1 and street_2. However, there are times when 2 street lines haven't been enough. Users have added two lines of text separated by hard return to either street_1 or street_2 indescriminately. (Unfortunately.) I need to find those fields with hard returns in them, and create new fields new_street_1, new_street_2 and new_street_3 based on the original street fields without damaging the original data so I can clean it up reliably. What script operation will work best to accomplish this goal? Is there a better way?

I have a text code field that the user can override by selecting from choices in a drop down value list. But there are a few instances where, based on the content of the record, a change to the displayed code is not permitted. I want to use a script trigger to intercept the user's selected choice before it changes the field's current value. The script will inform the user of the special case ... and the original code will remain. I've tried OnObjectEnter, OnObjectKeystroke and OnObjectValidate ... but with each trigger, the code has changed (via the user's selection) before I can find out what it was. I thought this would be a simple and common case, but …

I'm working with this line of code, below. The script crashes here. "Can't get folder MacBook:640Gig:Users:MacBook:Desktop:" then it reports error -1728. set clients_folder to "MacBook:640Gig:Users:MacBook:Desktop:" At the desktop, the "Info" button of the Finder reports the path as MacBook, 640Gig,Users, MacBook, Desktop. I do not understand why I get the error in that line. Any help, folks?

Hello Alll; i was looking @ Comment's script for horizontal portals and just dont seem to understand what this is doing, Can someone please explain if you can? thanks, *this is setting variable in script Name: $$group Value = Let ( [ groupSize = 5 ; //repeating number group = $$group[Parent::ParentID] + Get (ScriptParameter) ; //set group = RepeatingParentID + (What parameter is) limit = Div ( Count ( Child::ParentID ) - 1 ; groupSize ) //eg ( div ( 5 ) -1 ; 5 ) = -1 ] ; Max ( 0 ; Min ( group ; limit ) ) // Max ( 0; Min ?? What is going on here? ) Repetition = Parent::ParentID -i

I need to keep the deleted and edited records in separate table could you please anyone give me the steps to implement this feature to my FileMaker database. Many thanks in advance for your help.

I have a script to Go To Related Record: Open File ["Electronic Recording"] Go to Related Record [show only related records; From table: "Electronic Recording Proceeding"; External; Using layout: <Current Layout>] (If I don't use the Open File step, the file opens at 100% zoom, which is not the zoom level I want.) Here's my question. When the script runs and no related record exists, the result is an empty record. Is there a way to make a custom dialog appear saying no related record exists, and then an "OK" button to close the file? Thanks, Kevin

Thanks to help in this forum, I'm almost done creating this database! I'm so excited! I've hit one last snag. Calculations/scripts are my downfall. Here is my dilemma: I have a "Main table". On it is a portal to my "Social Table". I am assigning each record a value of either "Intro" "Single" or "Paired" (which is in a "Social Status" field). Here's where I'm stuck. I need to do a count of how many records have the "Intro" value, "Single" value or "Paired" value, AND I need it to only count the records that also have the field/value "ACTIVE" selected (since we don't want to count non-active records). I made a field for the calculation, and h…

Help! I have no idea how to go about getting this 'idea' (demand) in place. I've attached a picture of what I need, to help with my poor explanation skills. I have what is essentially a medical record. For each ID number, there is a lot of things being entered. I'm stuck on one section. "Actions". I need to be able to state what day an action (once a day, twice a day, etc) was 'started' and 'stopped'. There can be more than one action active at one time. Each with it's own start and stop date. I need to keep a history of these start/stops (but not visible on the current table/portal). Also, the less typing the people entering the data have to do, the…

I have a Quote Table related to a Lines_Quote Table related to a Product Table. I also have an Order Table related to the Quote Table. I have a filemaker script using Set Field functions to copy the related Quote data to the Order when the Quote is accepted. How can I copy the Lines Quote portal data to the Lines_Order portal? It seems to me that the Quote:: kp_QuoteID is referenced on all the Lines_Quote records. Perhaps I can create a found set based on the kf_QuoteID on the Order and then loop the Set Field function but I am not sure how to create the found set. Nor really how to create the loop. Any advice would be welcome.

I've got a client that was using a POS system designed in FM5. The printer would open the register whenever "A" was sent to the printer in the control (an internal font related to the printer) font. When I updated to FM11, I learned that non-True type fonts aren't supported anymore. Contacted the printer company, and if I send a hexidecimal command to the printer, the register drawer will still trigger. Any help on how to send a hex command tho? Sorry if this is a newbie question.

Here is the context of my issue. I have a script that saves a .pdf file to the desktop, attaches that file to an email, and then sends the email via the user's email client (Outlook, Thunderbird, etc). Immediatly after the Send Email script step I use a Send Event step to delete the .pdf file that was just created from the desktop. The event calculation is as follows: "cmd c/ del " & Quote ( $File ) The $File variable is created eariler in the script and contains the location of the .pdf file to be deleted formated as "C:\[path]\[file name]". I use the Quote() function because parts of the file path contain spaces. When the Send Event script step execut…

Within FileMaker Pro I do have a "Perform AppleScript" function executing the following command (i.e. triggering the application CopytoUSB). The purpose of this function is to behave according to the information contained in cells _CompID and _cardVolume. In the meantime the program is to assign a value to the cell "vgCopytoUSB" of the table "Preferences". At this moment it should be "Yes". Getting the values contained in cells _CompID and _cardVolume work like a charm. However, I cannot get the cell "vgCopytoUSB" to be initialise to "Yes". Would someone have an idea why I cannot send a value to the field "vgCopyt…

SEE NEXT POST - I HAVE REJIGGED MY QUERY. I am trying to understand how I might move field data from one TABLE to another. I have an 'Orders' set up which I would like to replicate for producing quotations. It would be most convenient to keep the to TABLES separate. Otherwise I will end up with many orphaned Order numbers, or IDs. I was thinking I could copy the TABLE, ORDERS, rename it QUOTES, and then on the occasion when the Quote becomes an order I could script a, copy the quote data to a new Order. My thought was to Set Field - target ORDERS field name, calc = PROFORMA field name. But it does not work. I do not have a relationship between the PROFORMA tabl…

I wrote a script which is coping files onto a USB key using information from the filemaker pro database. However, when the script executes, I can no longer have access to other function in the dbms. Is there a way to run a script in the background (like a batch job) and not have to wait for the script to finish. Thanks! Daniel.

When running the script GetUSBKEYname (see down below) the program stops at the command line set USBname to cell "vgUSBKEYTHENAME" of current Record and display the following Error message Object not found Unknown Error : -1728 However, when going to Manage Database I can see the variable name vgUSBKEYTHENAME. Is there something else I must do to register a field for it to be found when calling it in Perform AppleScript. THANKS in ADVANCE! Daniel Commande: GetUSBKEYname Set Variable [ $$USBKEYNAME; Value:100004 ] Go to Layout [ “@Preferences” (Preferences) ] Replace Field Contents [ Preferences::vgUSBKEYTHENAME; Replace with calcu…

Is there a way for a script to "know" whether the last login attempt was sucsessful? I would like to use the outcome of the log in as an IF/THEN step. Something like... IF Get (lastloginattempt) = sucsessful perform action.... ELSE IF Get (lastloginattempt) = failed don't allow action.... It would also have to account for the user cancelling out of a log in prompt, or treat that as a failed attempt. I know there's not a Get (lastloginattempt) but I saw a Get (lasterror) which has many error codes pertaining to passwords. I'm not sure how to write the script though since there is no error code generated if the login is successful, and the Get (laster…

i have employee module... Some times im going to edit the particular employee information. In this case i have to maintain the old records for reference... that means i can able to view the particular record with the old information.. if im have done the edit in three times means.. i could able to view this three records. Hope you can able to understand my requirement.. How can i achieve this.. any scripts or any layout operations.. please suggest me.. Many thanks in advance...

I am working on a work plan which has a portal of acitivties, I want that once the user has completed the workplan and fills in all the acitivties and then when he/she clicks the submit button the portal should be locked for editing and the report of the workplan should be email in PDF to [email protected] Thanks alot for the support.

Here's what I'm doing: I have a privilege set configured in a way that only allows members of that priv set to edit records when those records meet specific conditions. This is working properly. I am allowing users who cannot edit a record at that time to still be able to enter the field so they can select and copy the text. This is working properly. Here's what I don't like about it: If the user tries to edit the field when their privilege set won't let them, they get FileMaker's native dialog that says "Your access privileges do not allow you to perform this action." Here's what I'm trying to do: I'd like to be able to trigger a script that…

Hi, I am using FM to generate ical files that contain specific events that are read from a FM database. Have been doing this for about a year or so with excellent results and it has taken maybe 2 to 3 hours to generate the 3000 or so ical files that run the span of an academic year. The new Lion OS disrupted this because it needs a User ID field in the ics file in order for Lion to read it correctly. Without the UID each event gets imported into iCal twice. So the script below (parts were lifted from the internet) makes a UID and everything works fine except it now takes double the amount of time to run the script. Pretty sure I haven't been the most efficient at sc…

Hi, I am a beginner filemaker user and I use FMP 11 Adv. I have a problem using script to generate serial number. I am required to generate a serial number with this format: YYYYX-PPPPPPP-AA , YYYY is the year X is the month code, the code for example: Jan-Mar = A Apr-Jun = B Jul-Sep = C Oct-Dec = D PPPPPPP is the project number AA is the number of the time the invoice is created, starting from 01 How can I implement this requirement? Thank you very much for your help.

We've been living with this for a few months now, but it's just starting to bug me (it makes things like unprofessional). When using "Show Custom Dialog" the dialog pops up towards the right top of the window (not the screen). I have a custom function that centers the window and I think ever since I did that the system dialogs are way off. They always appear at the same position, pretty much at the top right corner. All my "pop ups" that are created appear right in the center of the window. How is the position of the Custom Dialogs determined and can I "reset" it? Or am I going to have to change something I've scripted to do with the window position? T…

Hi, I am new to this forum, and could use some help with a script. I have found this script on this forum and adjusted it. The script is working almost fine, but i have a problem with the portal rows. Only the first row from the portal is copied and the others not. The reason that i want to copy is that i don't want to type the data twice. I have a screenprint from the script attached. Thanks, Frans Script copy record with portal.doc

Is there a more "elegant" method to test multiple fields with a CASE statement? Example: I have a layout with 51 fields whose value I have to check for "Pass" or "Fail"; ANY One or More "Fail" values out of the 51 is what I am "trapping". What I have done that works as intended is: Case ( Field1 = 1 ; "Fail" ; Field1 = 2 ; "Fail" ; . . . Field51 = 1 ; "Fail" ; "Pass" ) Just wondering if thers is a "shortcut" to achieving the desired result BTW, in "case" you are wondering what type of "test" in which just ONE "Fail" results in a "Fail", it is for a Line Check for 737 Captains! Cheer! Lyle

hi all, i have a script that, among other things, creates a multiline key to filter a portal by date ranges. on my layout, i have several buttons that trigger a script using a different set of script parameters. for example, if i click the button labeled '1st quarter', the key field will be populated with something like 1|2011 2|2011 3|2011 and the parameters i pass to the script by clicking the button are "1¶2¶3" & "1st quarter" i am using the literal at the end to put on a field of the report so i don't forget it. this all works very nice for all quarters, but i also want button for the first and second half of the year, and also th…

I have an application in which I calculate a new date by adding a number of days to today's date. In my current implementation, I enter the days in a field, then hit a button to run the change date script. Is there a way to just enter the days in a field and, by hitting the return key, start to run the script? Herb

Greets, all: In FMP+Windows, I'm coding a script where an instruction looks for an executable file--based on the relative path from Filemaker Pro.exe--and ran into a problem: the Get( FileMakerPath ) command works when I'm using FMP, but when I convert the solution to a runtime the script bombs. Am I to assume, then, that Get( FileMaker Path ) doesn't work in runtimes? I couldn't find an answer in the FileMaker Knowedgebase so I'm stuck. :S Is there a different Get command I could use? As an aside, the runtime will "live' on a flash drive so it won't be looking to the C: drive as a reference. TIA for your help! Rich

I have a file which has a two windows: a "Main" window that the user uses, and a "Log" window which holds debugging info that they don't generally see. Currently, if the user closes the Main window, then the Log window pops forward, which is not very user-friendly. I'd much rather just close the entire file if the user closes the Main window. So I'd like something like this: On Window Close if ValueCount(WindowNames(Get(FileName))) = 1 and WindowNames="Log" then # only 1 window left and it's the Log window so close the file Close File end if I thought about doing this in the OnLayoutExit trigger, but the main window has literally 100s o…

In FM11, Is there a way to determine if a user has hit the Return or Enter key in a field (but NOT the Tab key) so that I can trigger a script, without using OnObjectKeystroke trigger? [ The reason I want to avoid OnObjectKeystroke is that it makes debugging very difficult when using the debugger in FM11 Advanced. ]

I am executing this attached script within FileMaker Pro (FMP) and it works correctly. However, there is one change I want to make. I am now introducing the usage of FMP layout. I want to replace in my script the command "set {text returned:theEVE, button returned:buttonReturned} to display dialog "Please enter your event numbers (i.e 1111 2222) :" buttons { "Changed Invoice No", "OK"} default button 2 default answer theEVE" by using this FMP layout (see file attached). The variable to validate.e to run through this script is called "OrdeEvent1". What is the syntax in FMP script to pass a FFM variable to an applescript module. In this example, the variable…

This seems so simple by I'm stumped. If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";" returns exactly what I need it to: Appliance Cookbooks>Data from Cat Appliance Field; now, I need to go on so I end up with this: Appliance Cookbooks>Data from Cat Appliance Field;Ethnic Cookbooks>Data from Ethnic Cookbook Field; So is there a way to string two If statements together or should I be using something else?? If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";" If(IsEmpty(Cat Ethnic);""; "Ethnic Cookbooks" & ">" & Cat Enth…

Using FileMaker 11, what is the simplest way to connect a single checkbox to a script such as delete related?

How do you handle record locks in your scripts? My issue with ErrorCapture ( ON ) is that the user cannot see who has the record locked unlike the default FileMaker error popup. I am not aware of a function that captures this. Leaving it off allows the user to create chaos. I know I could check ahead of time with Get(RecordOpenState) to prevent the chaos but it still won't tell the user who has it locked. So.... What do you do?

I'm experimenting with script triggers in FM11 advanced, and having issues with the OnObjectKeyStroke trigger and the debugger. Basically, I want to have the debugger window open so I can debug my scripts, but I don't want the debug window to interrupt me on every single keystroke. If i were using a different programming language, I'd leave the debugger off and insert a Debugger() command to open the debug window in the place I want it. Is there any way to do this in fm?

Problem. I have a date field. After "so many" days I need a reminder that it has been "so many" days since that date was entered. I need the reminder to replay everyday at a noon until it is turned off without deleting the date in the field. I hope someone is willing to help me and I thank you in advance for your help. I'm not even close to being a developer and I have to struggle through when I have to do something like this so your patience is appreciated as well.

Hi If i am at a dialog box... how would one make a continuous beeping sound for a operator not at desk or is a sleep at the console? Triggers some external sound? TIA Rod

I have created the following script that runs within FM Pro 5.5 to move a folder from one location to another. tell application "Finder" move folder "folder to move" of folder "test scripts" of folder "Desktop" of folder "adamreece" of folder "Users" of startup disk of application "Finder" to folder "To Archive" of folder "job_folders" of disk "XSERVER" of application "Finder" end tell This works if run as a straightforward script step, but I want to be able to use a calculated field as I want to use a database field to specify the 'folder to move' name etc. We use FM to book in design jobs and invoice them when complete. The aim of this script will…

I have a loop that works! (MYFIRST!EVER!) (see screenshot). What I hope would be possible is to avoid making duplicates. I have a unique control number (AID+CID) for each record of the link table (linking customers (CID), ads (AID) and the issues the ads appear in (IssueID). this table generates printing text as well as billing and payment records. i cannot figure how how to tell FM to skip making a new record if the control number already exists and go on to the next until the loop is exhausted. the called script copies a customer's ID and the ad ID (from the ad table that already has both numbers) and makes a new link record with the current issueID. The loo…

I once remember reading that it is unreliable practice to use Copy / Paste in scripts. I have a looping script that copies data from one table and paste it in another as it as it creates 150-200 new records. I notice that here and there, a few records are missing their pasted data. Should I replace 'Copy' with 'Set Variable' (Using only one $ for that script?) and should I replace all the 'Paste's with 'Set Field'? Or is there a more reliable way to do this? Thanks so much and a very happy new year to you!

I frequently arrange fields on a layout into a column. When I add or remove fields I have to re-adjust the spacing between fields to achiece a uniform spacing. Is there any way to select a number of fields and arrange them vertically (or horizontally) to a specified spacing value (say in inches or pixels)? This would would be a significant time and work saver in orgainzing layouts.. I frequently arrange fields on a layout into a column. When I add or remove fields I have to re-adjust the spacing between fields to achieve a uniform spacing. Is there any way to select a number of fields and arrange them vertically (or horizontally) to a specified spacing value (say in in…

I have a script that imports records for two tables. It goes to a table 1 layout, shows all records, deletes them and then imports records from a FM file. It then goes to table 2, finds all records, deletes them and imports records from another FM file. The problem is that after importing into the table 2 layout it deletes all the records in table 1!!!. I've tried everthing. Is there a problem with doing two imports in one script? Is there a bug, or is my script wrong. As we use to say in the auto business, "sometimes it's the nut that holds the wheel". Here's the script: # This script imports records from the Accounts Records and Gift Card files located in the par…

This is only my second attempt at writing a script, so please bear with me for the exceedingly high noob factor! Background: My club has some members that pay their dues annually and some that pay every month. I'm trying to build a script that will find the monthly dues payers and automatically fill in the date, reason, and amount fields in a related record. I am using two related tables called 'People' and 'Expenses'. I identified the Monthly Dues payers in the People table and allow creation of records in the Expenses table. The script that I have come up with so far properly finds the records of the monthly payers in the people table and the first tim…

FileMaker 11 Adv. How can I configure a solution developed on a PC desktop computer to appear properly on a laptop? When I transfer it on a laptop I have to resize all the layouts to fit on the screen. I know the resolution settings can be different but Is there a way for FM to automatically adjust for this? It seems odd that each solution has to be tailored to a specific computer.