Script Workspace and Script Triggers

With the release of FileMaker 8, buttons on layouts can now be included in the tab order so the user can tab to a button and hit Shift or Return to perform the actions associated with that button such as running a script. Tabbing through the fields can be simulated using ScriptMaker's Go To Field[] script step. Using this method skips over buttons that are in the tab order though. Does anyone know a way to script the tabbing to a button in the tab order?

Is it possible to ask someone to log in but not allow them to cancel? I have a script that loops and the only way out is if a check field is = to "operator", the only other way out is if the person clicks cancel on the re-login screen. How can I stop this? I mean I can stop the user from going anywhere, but the script is kind of not complete how I want it. Ben

How do you write a script that will set a text field to a word or words found in the middle of a sentence. For example, Say I have a text field with the words John, James, Bill, Ed, Brian. How would I write the script so it will set a text field to the words in-between James, and Brian. James, and Brian will always stay the same.

Hi Folks! I am trying to learn how to use the custom message script step where before a calc is executed a pop up window appears to allow the user to choose to abort the script or continue by selecting "OK" or "Cancel" buttons that are the default setup: Show Custom Dialog ["", "Are you sure you wish to continue?"] Insert Calculated Result [select, "bid 2, "Case(isEmpty(bid) =1, 0, bid * 1.1)"] But the calculated result of bid * 1.1 is always displayed regardless of the button selection in the custom dialog that comes up. Where have I gone wrong, if you please? Thanks in advance

OK Gurus... any help would be appreciated. Here is what I need to do... I have documents that are barcoded and in a filemaker database by barcode number. I need to track their status (in or out). I can do this on an individual basis but want to make the process automated for bulk check-in and check-out. I don't know where to start on this. I would like to have some kind of box that the scanned numbers go into (or better still, have the related record found and displayed in a list view) Once all the records are scanned, I would like to call a script that sets their status and either removes them from the list or marks them updated. Any ideas on the …

Is there an easy way to configure the design set up so that when I design a layout on "a" computer it looks the same when I viewit on another?! By this I mean, the the layout will not change to suit the size of another monitor? The zoom in/out will only go increments of 25%. So obivously it can look to small or too big and the main problem is, it does'nt fit the screen as deisgned. I know you can resize the window, but not sure if its possible to resize the screen. To accomadate different monitors and setups. TIA Ben

Hi, I'd like to be able to delete multiple files via a portal. I've thought of 2 ways of doing this, either by doing a Replace on a field for the files visible in the portal, then a find on that field, then a Delete found set ... or ... by doing a loop script on the portal, deleting as it moves through the portal files. Has anyone a better suggestion? Both of these seem to be real 'kludges' to me. Grant

I am trying to skip a line in a repeating field. I have a number of records that I want in a report that contains repeating fields. I have a script that sets the rep field value based on the count of the field + 1. The records are sorted by group (A B C D). A I loop through the records if the group changes from A to B and so on I would like to skip the next rep field. I have inserted a set field using " "(spaces) as a value list. Then if the value from A does not match B insert the space and enter the value of B in the next rep field. This will only work if I go to the report layout then back tp the original layout. Without changing layouts it does not work. Any I…

as a script step, i would like to find records in my database which range 2 days less than through two days greater than todays date i can get records where x field has todays date by perfrom find = data::x =// but cannot figure out the script formula for a range of days off of the current date...such as data::x =<2...//...>2 it must be simple, but i am stumped. thanks for any help you can give arfus nyc

Hi, I am relatively new to FMP - I've some experience in other databases (Foxpro & Access). I'm taking over a database that had a field added (recno) that was never used. I want to begin relating other tables to the master - but I need to fill in the recno field with a unique ID (recno) would be fine). Is there a scipt to auto load this table one time? Once done the field is setup to add the next sequential number, but we need to fill in a couple of thousand records first. Any help is appreciated! Bob

this is a small display glitch i experience, i want to know if anyone else does to... when you use the goto related record script step and specify the layout to use to display, it works fine, but after you press ok it seems to display the wrong layout i.e. it says unknown or something else completely irrelevent... as the table occurance to display in... just thought id find out if any one else is experiencing this fmp8adv 8.0v1 ~genx

I have multiple containers, that hold photos. I would like to be able to send the contents of the containers in a single email. The container fields are labeled Photo 1, Photo 2 etc. The containers hold the actual files as opposed to file references. I have managed to create the email, however if I reference the field in the body of the email (for instance "here are the pics:"& Database 1::Photo 1 ) all I end up with is; here are the pics: dscxxxx, the name of the pic, not the actual pic! Any help would be appreciated.

I saw the following bit of code on a Web site and was wondering if someone would translate it into a FileMaker script? Personally, I would like to use it on a address field that combines all the elements of an address on one line, instead of breaking each element into its own field such as Street, City and Zip. Anyway, I just thought there might be other FileMaker people that would find this very useful. Thanks, Mitch var mapURL = "http://maps.google.com/maps?f=q&hl=en&q="; if (singleResult.address.length > 0) { mapURL += ""; …

Hi... ok.. i'm creating this sing-in system for a school. On my initial layout i would like to put a real clock, so students can see if they are late or not, but i can't find a way to do that. Can you help me pls? thx!!!

I wrote a script that includes 'show/hide status area [lock, hide] but I made at least one error in it. Now it can't complete and I can't get into the file again. I can't access scriptmaker, I can't change mode, I can't even quit FileMaker. Is there a fix for this? I'm running FM7 on Tiger 10.4.5 Abbe

I have a schedule with 10 time periods each day: Monday, Tuesday, Wednesday, Thursday and Friday (No Sat and Sun) I want to let students sign-in for vaious slots during the week, but they may not sign in for more than 3 slots in any 5 day (weekly) period. Each student has a unique ID#. Is this a script or calc or combination of the both?

Hi all, I've got a problem with a search query.I am trying to look in a table all the records that: - have as record owner the current user - they have a blank value in field Payment I think the problem comes in the second set field instruction, my code looks like this enter find mode[] set field[database admin;get(accountname)] set field[payment;""] perform find I'm getting all the records related to my user but not only the empty ones. Any thinkings? thanks for your help!

I have a main database. I have a link to a second database where I have a script that will open the file and send me to a certain layout. based upon who I am. This works fine and is based on a script that works when the file is opened. The problem I now have is when the file is being shared and is already opened, the script will no longer work as it is remote and the startup script is no longer working. I can't see a way to directing someone to a certain layout from another file?? Basically scriptmaker will not show me layouts from another file?? Is this possible? Is it possible to automatically open a remote file through a script? I have lookad at the scr…

Hi, Script Steps Reference states that for SetField, the specified fields do not have to be on the current layout. But do they have to be on the current table? If so, is the best way to copy data from a field in one table to a field in another? Right now, this is the only way I can get it to work (code abridged) Go to Layout [X] SetVariable [$fieldX] Goto Layout [Y] SetField [$fieldX] Is this the best way? Thanks. Ethan

Is there a way to perform a script based on resulting text from a drop down menu? Ex: if a drop down menu results with the text "Refinance", perform said script. Otherwise, do nothing. I can't use a button for the Field, being that it is a drop down menu (there are other text results that I don't want a script performed) and I don't personally know if there is a way to make it an auto-calculation to run a script based on the drop down result. Any ideas?

hello hello, im trying to make use of the Get(ActiveSelectionStart) function... for this to work i would assume that you would have to incorporate it into a script... the field would be required to remain active... but is soon as i hit the script to execute the button, the field sort of commits and then get(activeselectionstart) evaluates to nothing... help is good, help is great, help is what i'd really really really really really really appreciate cheers, genx

Can someone give a few tips on how to use this step? I have a data base that has a form letter with 14 merge fields, and I want to send these to selected email addresses. The email address is a part of each record. I am using FMP 6 on Max os 10.3.9 Any help will be greatly appreciated.

What does the little red square signify when you click in the grey area to left of scripts while in editing model? My hunch is that this is some tool that may have strokes, but I can't figure it out. Any ideas? Jarvis

Is it possible to specify the fields a portal will sort by through script in any straight forward manner?... or then again, an unstraight forward manner is also perfectly acceptable cheers, genx

I have number fields with order numbers such as: 00076598 and need a script to remove the first three zeros if they appear in any record. I would also like to have the text automatically reformatted to appear as 76598 if someone enters the zeros in a new record. The field is currently a number field, not sure if it needs to be a text field.

Hi, I'm trying to find a calculation function that will allow me to force a calculation's result to contain a certain number of digits. So if I say 4 digits, then calculations of 1 or 15 would result in 0001 or 0015. Any ideas? Thanks Ethan

Hi Squad, Gold star for anyone that solves this one. A customer of mine has been saving files into a container field instead of linking them. This has made that database huge in size considering it only has 1200 records (its about 300 meg). This is not a problem, except for the remote workers that use the DB. When they load it over a VPN connection, it takes at least 5 minutes to load. Normally this is due to large index files, but this is certainly related to the container field this time. If I remove the container field from the DB, the file size drops to 2 meg, and loads almost instantly. So my query is this, I need to create a script that takes t…

Hi all, I have a field with a pull down calendar, what I need it a POPUP or something reminding me of an upcoming birthday a few days before. How to go about this. THANK YOU:

I've spent the last 3 nights trying to find the solution for this one and have come up with ZIP! I have FILE1 and FILE2 related by FIELD1. How do you perform a find in FILE2::FIELD1 based on the contents of FILE1:FIELD1 Thanx, Mel

I think I missed this somewhere, but how do you go to a table, find a particular record in it, but preserve the current found set? Here's a particular scenario: I use GTRR to go from Table B to Table A. The relationship takes me to just one record in A (I print a report from that). Then I want to stay at Table A, but expand the found set (but not quite to "all" records in the table). If I do a GTRR, via self join in Table A, I can get to the subset I want easily enough, but I am no longer "looking at" the same record. How can I get back to it or stay at it without using "show all" (... for various reasons I don't really want to show ALL). I guess …

Trying to create "simple?" form to allow user to select (via popup menu in the first field) a master list of technologies. When that first field is populated – it would automatically show list or popup menu of available sub-technologies (related only to the specific technology first chosen) in the second field. This would occur onward for three or four sub-level fields. Is this done via an "IF" script? Have used FM for years, but only for easy contact list information. This concept is totally new to me. Please be basic with your reply. Thanks for your expertise! Joel

I'm not sure if I would use scriptmaker for this, but hopefully you can help me. I want to use what is in one field to automatically enter text into another field. So, if the first field has "EXT-1" as the entered text, I want it to put "Aisles, stairwells, and exits" in the next field. In other words, can I have Filemaker read what is in the first field and then put in the appropriate text in the next? Thanks!

I have a script that looks like this... Enter Find Mode [] Set Field [table1::number; ">=" & table1::global] Perform Find [] The set field does not work? I'm trying to enter the operators >= and a number from a global field. The field table1::number is a calculation field but that should not matter right?

When using the 'Set Window Title' script step, I'm also trying to change the color of the text. Slick idea, or so I though. I attempted to rename the window to - TextColor ( "BlahBlahBlah......." ; RGB ( 255 ; 0 ; 0 ) ) However, when the script was executed, the title changed, but the text color stayed white. Has anyone else attempted to do this before? Or, can try to see if it gives the same results on their system? I know this idea won't change mankind, but will just be slick if I can pull it off. Thanks for any input......

Hello ALL: Q: How to write the script on FM pro7 to log a record from TABLE1 to TABLE2 w/ a new record_ID. OK, here is my case: ==================== I have a FM pro7 file called DoorAccess Management which has two table: DoorAcces and DoorAccessLog. Both Table has ID, Key#, AccessLevel, Employee. Once the Door key was assignned to other Employee, I will like to log the old record w/ old employee name to DoorAccessLog table. How to do so? Thank you for help.

I've got a comments text field in my database. I'd like to have a button which adds a user's name and the date to the top of the text field, and then positions the cursor beneath it so they can add text. The aim is that users can keep adding comments, with the newest always at the top and the facility to scroll down to see older comments. How can I pull this off? It occured to me that I can cut the entire contents of the field, insert the username and date, and then paste back the field contents. This would be fine, except that it requires the user to position the cursor before typing. I'd rather have the cursor automatically in the right place. I'm on MacOS, so…

Hi, after all, I'm here again, asking your help... I have a database with account names and dates and hours. Every day I create a new record putting the current date and hour to control the time of one person that have one account name. But I have to make a report and I want to view only records of one Account Name (example: Everton) and all dates that I've been inserted by using date ranges. Like this: Account: Everton StartDay: 08/02/2006 EndDay: 10/02/2006 FIND By clickin in find, this will return all records like this: Everton - 08/02/2006 Everton - 09/02/2006 Everton - 10/02/2006 I have writen this script: Ent…

I would like to be able to open a file via an FM button and be able to tell the file which layout to open with. Is this possible?? Thanks, Mel

I have an update script that compares the values between two tables, updates the values if needed and then marks the record as needing revision control. The script works perfectly on the MAC, but under windows it constantly marks off all the records as needing revision control. It is the exact same script, same everything, but the outcome is different. Is this a common issue developing for windows machines on a mac in filemaker? I'm not sure what to do at this point considering logically the script should work just fine, and it does on the mac...

... basically i have a bunch of related records showing through a portal... there is a button overlayed over each particular row in the portal to insert a merge code into a field on the current layout... ... now i know i can use set field to insert it at the end... but i want to be able to insert from where the cursor was last in the main field... is this possible? cheers, genx

I have a layout that creates a new record ID everytime a new record is created. Naturally. I have a layout which is based on the same table where I have another form. I do not wish to give this layout the same ID number as the main layout number. I have a button which will take me to layout 2 and what I need this button to do is is find the last number entered when the button was pressed and input that unique ID. I have thought about introducing a global field, setting the field to the say 0001 +1 and then setting the solid field to the value in the global field. This would give me a unique value but I do not feel that this method is "Robust"?Does anyone have any…

I'm just starting to learn FMP and have a Question. If you care to answer it please don't go into detail because I can assure you I won't understand your detailed reply. Is it possible to scan a document directly (or as directly as possible) to a container field? I'm working to convert my office to "paperless"...or as close as I can get. Thanks, Mel

hello, not sure if this is the best place to post this but i can;t see anywhere better (prob as i am not too sure if it is possible) I have a page which i can enter a value in and select FIND then that takes me to a result list. I need to then take the result from that list to another page. I have the following: Copy [select, "Product Code"] Perform Script [subscripts, External: "Order Details"] Which i thought would take the value and then direct me to thepage. But obviosuly i need to set the value in the new page as well.. if anyone has any advice on how to do this it would be appreciated. thanks RF

Hi, I'm planning on including a 'group edit' script in my address database, so that I can edit a number of address records at the same time (like if a company address has changed and I have 20 different records for different people in the company) and I would like to ask if anyone has any advice about the best way to go about it. I thought the best way to do this, is to create 'global' fields to 'mimic' the normal ones, then from a group of records in a portal, set the global fields to the same values as one of the records ... via a script. Then I can edit the info in the 'global' fields and once it's the way I want it, run a second script to change/set this ne…

I have been doing a great deal of reading lately as I am am trying to tighten up my programming skills. I know how to do what I am about to ask using a Copy & Paste scenario but I think there must be a more elegant way...And everything I have been reading lately tells me to avoid using Copy & Paste solutions like the plague as they are unprofessional and potentially a user does not want to lose what might already be on their clip board. With that said I have two related tables, one being a contact table the other being an art development information table. IN the art development table when a user enters the company name the "auto fill function" will fill in…

Is there a way to set the "Output file character set" when using the "Export Field Content" option? I would like to set it to ASCII like when you use "Export Records".

I am attempting to use the lookup function but following part does not seem to work properly. I always get the "NA" response. It seems like an easy enough function to use. Does anyone have any suggestions?

Hi I have various layouts that use Buttons with go to related record scripts to navigate each record set. These will only work if there has been a record created on those layouts. If no related record exists i can not access that layout unless i use a second button scripted to, go to (whatever) layout & then create a new record.This works But i think i have to many buttons & scripts What i would like to do is go to related record/& if no record exists create a new related record. Is this what i should be trying to do & if so how do i script this. I have never written/understood scripts. Also is there a way to dissable the close button on the win…

Is there away I can combine text and "field" information in the body of an e-mail message, using the built in e-mail function in scripting? What I would like to do is something like: Dear "Field Name" Attached is your invoice number "field name". Thank for your continued Support. Steve ----------------------- Thanks for any help from the list. Steve

Hi Folks, Quick question, and I cant seem to find an easy answer for in online and in my filemaker 8 books. I'd like to calculate elapsed time from a date entered field. Simple right? Yet, I can't quite figure it out. I want to know how many days have passed since I sent a letter out. Here is the specifics, I have a date_sent feild, then a resolved field. If the resolved feild is not checked, I want to know how many days have passed. I also want to know how many days have passed between date_sent and resolved if the issue has been resolved. As always, thanks so much! Jake

I have tried to find the answer to this - so if its already been answered please re direct me! I currently use a calculation to put peoples ages into a field using their date of birth and todays date. This is fine when the record is created, but a year down the line the age is a year out as my database doesn't recalculate the age. Can this be rectified so that a "real time" age is displayed. This may be via a script that is executed to update the ages. Help please !!

I've got a script that is going to create an export file for me on a regular basis. I don't want to use a fixed name, that will overwrite the previous export. I don't want to leave the naming in the hands of the user, I would prefer to dynamically name the file with something like export_(insertdatehere).csv. Is there a way to perform this in FM 6? Please let me know. Thanks,

Is there any way to create an input mask so that the person doing data entry doesn't need to put in the parentheses or hyphens in a phone number? I saw that it can be done with Custom Functions, but there's no way I can justify FM8 Advanced.

Hi all, Picture this scenario: A layout with a portal showing related records. There's a button in each portal row that runs a script to open the record related to the record in the portal. This related record is shown in a new, smaller window in front of the main window and is intended for editing the record in a more detailed view than what's available in the portal. Here's the issue: If the record is not committed and the text cursor is still active in a field in the portal, the message "This record cannot be modified in this window because it is already being modified in a different window." is displayed. What I've done to handle this is as …

I have 4 rows of 96 *'s. I used a script that I found on here that will allow the user to select a section of the row and change the text color to red. Now I want to write a script that will go through the string of 96 *'s and count the red ones, or maybe the black ones if it's easier... I don't see a scriptMaker function that can check the color of the text? Anyone have any ideas? Mainly I'm using this to create a graph of a 24hr period (broken into 15min sections) to show where our drivers have been. Off Duty Sleeper Driving On Duty Not Driving Any help would be appreciated.

I'm trying to figure out how I can populate a list of all client names when status field reads "Confirmed by Phone" or "Confirmed by e-mail". I need to be able to follow a lead that is supposed to be sending a contract for service. Sometimes I will lose track once they say "confirm". Any help would be great! Thanks all! Aaron

Hi, I am working on a student database. The students are in the database and I'm trying to set up a Call Center. The Call Center will be for when teachers call a student they will log details of the discussion and be kept as part of the student record. At this time, I cannot get the appopriate student to show up after click the Call Center button on their record. For example, I am on J. Smith's student record. I click the Call Center button on J. Smiths record and it goes to the Call Center Layout. However, J.B. Good is the name in the student record. Here is my relationship. Table - Call Center - (Student Name) is the field. This field relates to t…

Hello all, changing the value of a field in a table, lets assume table A, field a, accordingly with the value b in table B, like for instance A.a = A.a+B.b. In pre 7 versions you had to write a script going from the appropriate layout, copying the value and changing to the target layout (and table) and manipulating the value appropriately. After that returning to the old layout. All in all needing at least two script. By now with just one database file and several tables it should be possible to manipulate the values without changing layouts, yet I never saw any examples or implementations of it. My question: is it possible now in 7 or 8 (maybe using $/$$vari…

If my goal is to write a script which will create a record in a table, and my goal is to also make this script as generic as possible (so it can be called from any layout/table), here is what I used to do: (Assume FM8) MakeARecordInTableX(id) Set Variable $id = Get(ScriptParameter) Freeze Window // to prevent flashing Go to layout (TableX) New record/request Set Field (key = $id) commit records go to layout (original layout) end script Now, this works great. this script can be called from anywhere in the solution, no matter what layout/record you are on, and it returns you to the same place you left off. The problem is, that…

Hello! Newbie here. Great feel so far to this cyber-community! I have a script to "find" records, and it seems to be pretty "user-proof", but since I have hidden the status area to keep new users "unconfused" (it is all layout button driven) I don't know how to signify the omit command/checkbox. In other words, if someone wants to find all Minnesotans, but omit those who live in Frosbite Falls, I have a button that sets the omit checkbox in the status area (in the second request)... but since the status area is locked hidden, the user isn't sure the request was set for omission because there is no visual feedback. Hope this makes sense. Thank you in advance!

Hi folks! Since I am new to this forum, please forgive my rudeness if this query looks too obvious. I have a bibliographical Database containing titles of texts included in the Chinese Buddhist Canon. What I am trying to do is to have a button that opens the corresponding text file. The standard procedure for doing this seems to be to create a button that uses the "Send Event" function. Then, following the "Specify" button I select from the menu "Send the event with ." I also choose the to choose the Target Application "TextEdit.app". The whole Event thus is displayed as: Send Event ["TextEdit.app"; "aevt"; "odoc"; "file:taisho_files/TSD_082_/" & taisho:…

I have a script that works in FM 8 but not FM 7 My portal is two portals the fisrt showing rows 1-3 the second showing 4-6. There is only one field in each row showing a name. Here are the first to steps. Go to Portal Row [select; Get (PortalRowNumber)] Copy [select; User::Name] In FM 7 if my button is in rows 4-6 it gets the right portal row number for the first step but, then then it goes to the first portal row to makes the copy step. if the portal row i click on is rows 1-3 it works fine. Any suggestions for a work around or a fix am i missing a step in 7? Any info is greatly appreciated.

Hi all. I've gottn the following to work... If [isEmpty(TrimAll(Substitute(Country::gNew;¶;" ");0;0))] but, how would I get this to work if I have also have a second field (gNew2) that needs to work the same way? I know I'm probably just thinking about this too much, but I've tried several things and non of them are working. Thank you in advance for any help your able to offer. Sarah

I need to create a script that will run every few minutes automatically. Can the script be triggered to run from within FileMaker or would I have to use an external source?

I have several tables tied to one database and for each of these table I have maintenance screens which contain function buttons (New button, Delete button, ect.). Is it better to create scripts that perform each function (new, delete, ect.) for all the tables in the database or is it better to have one script that performs all functions for a given table? This is probably a matter of opinion, but is there a programming standard that is used in the FMP world?

Hello, I have a script that someone else wrote and it is written to auto close after running. This sounds like a silly question but i have not been able to figure it out for myself. How do i go about opening the page so i can view and edit the script? Many Thanks, RF

I have seen this done in the Business Tracker database, but I can't seem to figure out how it works. I have a table with a portal displaying all open material orders for a construction job. I want to make each row in the portal a button that will take me to that particular related record. It doesnt seem like this should be hard, but I cant figure out what to do! any suggestions? Thanks

I have a table of documents. There are 3 types of documents specified in a field as LET MRI RPT and depending upon the type of document I wish to display it in a specific layout. IU have set up a trigger field which calculates the following If ((Letter_Type = "MRI" and Get (LayoutName) = "Letters:Letter" ) or (Letter_Type= "LET" and Get ( LayoutName ) = "Letters:MRI" ) or (Letter_Type="RPT" and Get (LayoutName) = "Letters:Letter" ) or (Letter_Type="LET" and Get (LayoutName) = "Letters:Report" ) or (Letter_Type="MRI" and Get (LayoutName) = "Letters:Report" ) or (Letter_Type="RPT" and Get (LayoutName) = "Letters:MRI");........ then I wish to r…

...for the first time (almost). How does one execute functions within a script? I'm thinking specifically about the let and copy functions. They don't appear in the list of script steps, and ScriptMaker won't let me manually type them in. I've tried going through the help, but can't find anything. What am I doing wrong or missing? Thanks...

I have 20 fields in a survey that I want to force to a "Y" and then give the person an opportunity to change it to a "N". I do not want all the records in the database to automatically have a "Y" in the twenty fields, but I want the user to click a button and 20 fields in the one record will go to "Y" and then the person could edit the field to a "N"

FM 8v2 with Server 8v2 I have a script with a step that reads as follows: Go to Related Record [show only related records; Match found set; From table: "Spots"; Using layout: "spots" {Spots}] After that line in the script, concatenation is done based upon the results of that script step. What I am observing is that if there are no (zero) related records in the Spots table, I am getting a concatenation of ALL the records in the Spots table (which are unrelated to the record I am currently working with). Is it possible to skip the subsequent series of steps if the number of related records is zero, as opposed to proceeding with the script for ALL recor…

I want my user to be able to enter something that will then be entered in records in the same field. The best way to do this seemed like creating a variable in my script, then having the user enter that value. However, the custom dialog script step does not seem to have a provision for me to enter a variable name to hold this data till its used - its only letting me select fields in my tables. Is there a workaround anyone is aware of? Or is there a better way of doing this? I can always fall back on just creating a field for this one bit of data, but I would like to embrace these new features where I can. Thanks, R

I have a table Submittal Reportings, using portals I am pulling all the material needed for a construction job with their corresponding required delivery dates. What I need to do is be able to move all the dates (for this particular job) back by a selected number of weeks. I have a script that creates the new date in a field called NewReqDate, and it almost works. The problem I am facing is that it will updated all of the related records except for the last one. So it looks like my exit loop if statement isnt working right, but im not sure why not. Here is the script: Go to related records [show only related records; from table: “Submittal Data”; Using layou…

This seems to be a bug to me, at least it's not behaving as I would expect. Two tables Company and Event attendance. I create an event attendance record and want to apply a company to it by selecting the company from a portal. If you then use a button driven delete record request it deletes the company not the event attendance record even though the portal is set not to allow deletion of related records.It's ok if you click into space after selecting the company to put focus in the event attendance record or add a got to field[] step in the selection script so it's easily fixed but surely you shouldn't be able to delete a related record when the portal is set not to …

I have a record that shows records through a portal via a self join. I have the records shown by a condition of them being open. I need help or some idea on a looping script that will go through the records shown (or each portal row) and give them all the same ID so I can reference all the items at that time later on. I have no experience with looping at all. Can anyone help?

I have a script that importing records from via ODBC. It is a SQL database. Basically, I need to populate some subfields in another table based on the query results. A simplified version of the query would be "Select * from teacherdata where StateID = FMPDB:stateid" The script runs through the records in table A (which includes a value in the stateID field) and populates table B with the results of the query. I'm basically pulling down 1 record at a time from a secordary database. My problem is that Table A has 1491 records and after a successfull run of the script Table B only had a little over 1300 records. My guess is that the query didn't return results before t…

I have been searching the forum for some time. I thought there might be a script that automates the process of manually importing each table and resetting the serial number when copying into a clone. It is time consuming to do this for each table. Thanks

I can't seem to get this script step to go to the next portal row. I can get it to go to the last or first but not next. Has anyone ever seen this?

Im porting a POS program from Access to FM 7 Developer. I want to create a new record in a LayBy table when that is the chosen method of sale on an invoice. In Access I can do that via code when a button is clicked. Can I create a new record in Filemaker in a related table with field information derived from the invoice form without the user having to provide any input? In other words can I create and populate a new record via a script? File attached. Any help is appreciated. POS.zip

On one of my layouts, I need to make it impossible for the user to exit the application. So, when they click on the upper right red cross, I'd like to display a message "go to the main layout before exiting" and then stop the shutdown process (I can't simply go to the main layout because of various user based validations). Any help would be appreciated :clap:

I am having some difficulties copying data from a field in a related table to a field in a layout we use. The script creates a new record in file-A, populates field-1 with a new number, then opens file-B, the next step is to create a new record in file-B (file-B has only two fields), populate field-x with a new number, then set field-y to a serial value from field-1 in file-A. Unfortunately, the set field command is not copying that information and placing it in field-y in file-B. Any ideas??? Thanks, Dave

Today's my day for problems. I would like to have a script that creates a new record based on a previous record. I bill my clients on a retainer basis. The record has a Jo_ID related to the Company_ID. All relationships work correctly. When I go to Retainer layout, create new record, and add the Jo_ID the company name, address etc. fields are properly filled in. My problem is I can not get "set field" to fill in the data from the previous months record. Additionally, I have a payment number field and I need to increment that number every month. In some instance there are 2 or 3 large payments and in other instances there are up to 6 or more smaller monthly p…

I have a start-up script that checks my monthly billing everyday and if there is billing to be done takes me to the proper layout. The problem is we don't have billing everyday and I'd like to turn off the FM warning box in the script so it just goes on to the next statement and I'm not bothered with it. I have looked to see if there is a "Perform without dialog" check box in the "perform find" statement and do not see how to do it. Is there a way to do it?

How do I get an enviornment variable called "REGDATE", REGNUMBER" and "REGNAME"? I m using exeshield for my security, and need to extract this info. I tried a number of "GET" commands, but nothing worked.

Hello Forum I am in the UK and want to know if I can integrate a postcode program into Filemaker. EG - After I insert the "house number" and "postcode" and then search I get to insert the full address. Hope someone can give me some help. Martin

Is it possible to import only new records? That is, can FM recognise a matching record, and then ignore it completely, (only importing unrecognised records)? Currently, my belief is that if I use 'matching records' in the import, then FM will update the results (which I don't want)? Please help if you know something I don't :qwery:

I have an invoice db, in which I have a checkbox for whether or not the invoice has been paid. Upon checking the box, I would like my 'date paid' field to be populated with today's date. I have this script on the date field, but am not able to get it to work: If ( paid checkbox = "yes" ; Get ( CurrentDate )) Can someone help? -Adam

I'm trying to standardize two databases for a client; in one of them buildings are refered to by their full names, in another buildings are refered to by numeric codes, which were assigned in the order in which they were created. Each building also has a number of different units. So in one database I might have "Shady Grove 1," which would be called 0101. "Shady Grove 2" would be "0102," whereas "Thousand Pines 1" would be 0201, and so forth. I need to have at least one constant point of reference between the two databases, so if I could convert the numeric to text or vice versa, I'd be fine. I've tried going about this a couple different ways but can't figure out a w…

Hi, I know FileMaker can run SQL UPDATE/DELETE/INSERT statements with "Execute SQL", but can it run SELECT statement? If yes, in what form or name does the query result appear? In other words, how can I use the query result in the script? Cyont

Hi. I'm trying out the possibility of using variable number of monitors for a solution (1 or 2). I thought Get(ScreenWidth) or Get(DesktopWidth) would help me, but that gives me just the width of the monitor that holds the window at any time - not the total of all the monitors. So when I place the window on my right screen and run the script it gets width = 1600, and on the left 1280. If it gave me the sum 2880 I could make Filemaker figure out how many monitors each user has... but no. Anybody who has been through the same out there?

I have a custom dialog box that prompts the user for input to use in the current script. However, if the user clicks Cancel instead of OK I want the script to Halt. Currently, the script continues regardless if there is any input or not.

How do I set a new value into a field that applys to all records? I use a script, setfield function. And I called the value from another database using the relationship. It didn't do anything. If I did "copy/paste", it only pastes into the current records. Thanks

Hello, I am trying to pass multiple parameters using a button, is there an easy way to do this? I am using FM7 Thank You! Rick DeCollo

I am trying to simplify by automating this task. I have a field that says "staff name". I also have a field that says "staff email". I did a script that will insert a email if "staff name" is selected, but I have to somehow make the script execute. Can someone tell me how to make it auto execute the script when I select "staff name"? -OR- Give me a better solution to make this happen? Thanks everyone! Love this forum!

I have been using FileMaker Pro since the days when one had to use multiple files to create related records. Back then to create a related record I would copy the unique ID of the parent record, go to the other file ("child file"), create a new record, paste the copied unique ID into the appropriate field in the child file, and voila they would be related. I continue to use this method in FM8 but with tables instead of files now and it seems to work pretty well. However, rather often the paste step of my script that pastes the unique ID does not work and my "foreign key" field in the related table is left blank. So my questions for those far more intelligent than me…

hello, if you have read my other posts you will know i have be left to get my head around a database that someone else created and left no documentation. I am trying to use a feature of the database and i get an error message saying "The Script Cannot be found or has been deleted". Is there any way i can search all scripts to find where that error is coming from? Just wondering as potetially that is a huge task to find manually. Thanks. RF

I know it's possible to write a script that eliminates extra spaces and extra returns (I don't know how to do it but I know it's possible:-). But if after all the extraneous junk is removed from a field, there is still too much info in the field, what else can I do? Is it possible with scripting to say that if there are more than 500 characters in a field, to change the font size to "10" (from "12") and if there are more than 700 characters in the field, to chanage the font size to "8" or something like this? I'm trying to solve the same problem that I posted under another topic (merging objects with formatted text or something like that) which no one was able to h…

I had a hard time even coming up with a subject for this post and I'm not sure that merging is what I need to do, so I will appreciate any input on this problem ... I have a IWP performance review database. Employees go in and do their self-review, give peer inputs and if they are Team Leads or Supervisors, they do those reviews for the employees they are over. There are between 5 and 10 measures for each position, i.e., a Sr. Software Engineer has 8 measures, an Administrator has 10. The FMP layout mode allows me to have 12 letter-size pages. Normally, there would be 13 pages for someone with 10 measures, i.e., a first page that gives the review scores and othe…

Hello Everyone, I have this database that tracks all our projects for one client. I have a field with a value list (on track, behind 1 week, behind 2 weeks, behind more than 2 weeks, ongoing, finished). Is there a way by a click of button, I can transfer all the information in all of the fields into another database, which will archive these finished projects. So basically when the project is finished, I want to click on this button and will transfer all it's fields into a database with the same exact fields. Is that possible? Thanks! Maria

How can I have filemaker do the following call... I:Jobsconvert.vbs 245345 I'm stumped. I know if I type that line at the command prompt in WinXP it will do what I want.. but I don't know how to get filemaker to call this? Hell if I put that line into my computer it wont launch, but if I put it into "RUN" on the start menu it will.