Script Workspace and Script Triggers

I have FileMaker Pro (unfortunately not advanced) and have created a ChangeLog table for my solution. The idea is that whenever the user enters or modifies information into a field, I record where (table, ID, field), when (date, time), who (user) and what (field content before and after) was done. The problem that I have is that a user can delete a record using a toolbar button. If I understand correctly, I cannot attach a script to that action in FileMaker Pro (but in Advance I could do it using custom menus). Is there an "easy" way for me to still document that the user deleted a record? In case it helps; all my tables are equipped with a table ID which is an au…

it is possible to have a button that links to open file network database and auto entry the same user login and password? we have about 10 users, and they have to re enter manually the login and pass when they open new file from button link.

This could very well be a very complicated question, but I'm hoping that someone with far more knowledge than me will have a quick answer to this issue. I have created a financial database that I use to display my boss's financial information via different reports. Let me first say that I KNOW there is a better way to do this, but I have managed to make this work for almost five years, so I'm just looking to fix this one issue, not restructure my database. No question about the fact that I probably did things the hard way. Oh well... I use this database file only for the current year. I generally make a copy of the file and then erase prior year data so I can…

I have created a database which I use mainly in Filemaker Go on an Ipad Every so often I open the database and get this meassge "An installed OnTimer script could not be found or could not be run with current access pri?ileges" which stops the database from opening. I have to reboot the ipad and then the database opens. Anybody any ideas on ow to fix this? Thanks pixeleen

Hi, I'm not very familiar with the user interface possibilities that FileMaker offers when it comes down to navigating the user to the next field that he needs to fill in for a specific task. Imagine the following scenario: A user types in a value, say «iPad», into a field «Table::Item». An onObjectSave script checks this value, and sets the next field (tab order) «Table::Price» to «$399». Then fills a couple of other fields that are further down the tab order in the current layout, to spare some time for the user. Then, after all Set Fields are done, onObjectSave wants to allow the user to be able to directly enter the next logical value for him. So it ends wi…

Hi all, I am a new user to FMP (13) and was reading about Instant Web Publishing (apparently FMP 12 documentation), I now understand that they have removed this feature, most likely in order to try and force people to pay for their hosting server service. I still would like to perform the same thing as IWP using FMP 13, web browser PC access, I understand the iOS access capability with FM Go... Any ideas or thoughts on whether this is possible? Thanks all!

Hi im still a bit of a beginner with filemaker i have been trying to figure this out but need a little help. I have this function If (GetAsDate ( Date1) - GetAsDate ( Date2 ) < 0 ; Date1 + 28 ; Date1 ) What i need is to turn it in to a loop so that 28 is added to Date1 until Date1 is higher than Date2 I have tries and testes let function and loop, if any one could help Many Thanks Meir

Hi, I'm very new to Filemaker Pro, and am just writing my first basic scripts for a project. With a button, I'm trying to filter my results to show me the records from the current week of the year. My records are set up with a "Week" field that auto enters the current week number when new records are created. Now I want to have a button that shows me all the records from the current week and then display them on another layout. I have this script working properly if I specify the week number in the Find request step, but I can't figure out the syntax to make it compare the current week number with the "Week" field in the records Thanks in advance. Dana

Hello everybody, I am a newbie in filemaker and this is my first script. I have 2 tables: artist and ebookartist. First table contain name and surnames of artist, second table contains eboo titles of artists. What i want to do is create a script where you type the name of an author on a filed in a layout and you get a list of ebooks of this artist. Thanx in advance!

I have a series of Applescripts that are incorporated into scripts and that interact with MacBulk Mailer and which worked flawlessly up until FMP 13. Now they generate a series of errors and sort of half work. Â However when I run the script from Applescript editor, they are still OK. Here's an example script. tell application "MaxBulk Mailer.app" activate SelectList "PG" AddRecipient SaveList end tell And here are the error messages I get as it functions. Â Â Â Would anyone know what's wrong ?

I have an existing Filemaker script that Saves my contact list as a PDF and it is set to execute when I open the Filemaker file. The script works fine when I double-click the file to open it; however when I use a shell script to "Open print.fp7" via an OS X cron job, I find that many times instead of opening my file and running the script, instead the Filemaker icon is just left bouncing in the OS X Dock. When I click on the bouncing icon the Filemaker window then appears in the foreground and the script executes normally. Is there a way to ensure that my cron job "Open print.fp7" script executes without any user intervention? Thanks for your feedback.

Hello, I had previously seen a thread (I believe it was here), that gave an example of a script that would allow the user to choose if they wanted to save as either an Excel document or as a PDF. I had just seen it recently, but forgot to bookmark it and can not find it again in my browser history. I have also tried searching for it through Google, and the search here but can not seem to find it again. I really don't want to repeat the question and start another thread for it as from what I remember it was already answered. I just wanted to know if anyone else remembered such a post and if so could it possibly be linked? Thank you for taking a look at my…

Hi there, I am trying to work out how to print as pdf a database layout (a certificate of attendance actually) and then have it automatically attach to an email address specified by a field in the same record. I found some code on the net but can't get it to work. I won't post it as I think it will just confuse the issue. I know how rot Save Records as PDF and Send Mail but the Set Variable stuff for working out the file path so that the fuel attaches to the email has me stumped. Any assistance gratefully received.

Hello! First off I would like to apologize, I've taken a rather long hiatus from developing in FM and have picked it back up recently(within the past two weeks or so). So if my question seems "noob-ish", it probably is, as I am not really reacquainted with the program yet and am still trying to find my barrings. So some simple things are simply getting by me. With that being said I greatly appreciate the time anyone takes to try and answer my question an explain things to me. Now, down to my question. I'll try to be a little more in-depth encase whomever is reading this is not really familiar with Amortized Loans. I have recently created a section in a database fo…

i having trouble getting FM to dial on google voice i can get it to my SIP Softphone thru windows, i can get it to skype with this : "callto://" & "+1" & Browser::Company Phone does anyone know of or can figure out a one click solution for this?

Hello I am stuck here. I would like to play a music mp3 file while my user is in a certain layout. When they change to another layout I would like a different file to play. I would like it to loop and play as long as the user is in a layout. Ideally if it is somehow possible I would like it to fade in when it plays the first time. But loop if the user remains there. I am assuming it could happen in the background by a script trigger. Could I ask for you help here please? Thanks

Hello, I'm using a popover to enter a new record. can you please share your script to avoid closing it when accidentally click to the background layout. Thank you.

Hi Board, My latest UI is for barcode scanning. Firstly, the user scans their barcode and a script triggers and sends them to the next field when the input has reached 32 characters. In the second field, it automatically puts a carriage return. When i scan my second barcode, the script craps out because it needs the field to be empty. I have tried using GoToField commands, Clear commands, Cut, Select, commands, everything i can think of and nothing gets rid of the carriage return in this field, nothing except the backspace key on the keyboard. How do I stop the carriage return showing up or delete it once it's there? I need the barcode reader to put …

Hi. I have a field with a script trigger that passes 2 parameters to a script; 1) the name of a related table (as literal text), and 2) a field's object name. I use this script for different fields on different layouts and have so far been using "If" statements to decide what to do, e.g.: If [Get ( ActiveModifierKeys ) = 16] If [$relatedTable = "People » Projects"] Go to Related Record [ From table…etc.] Else If [$relatedTable = "Company » Projects"] Go to Related Record [ From table…etc.] etc. End If End If This all works fine, but obviously breaks if I change the TO name. I know I can pass the field as an actual field name (…

I have a Container Field called "Picture" that holds PDF files for my cabinet shop drawings. I am able insert PDFs into this container field but cannot get the PDF's to open for viewing. Is there a way to script this? I am using Filemaker 13 on a hosted platform if that matters at all.

I have a database that is hosted on a remote server. I would like to be able to open this database without having to key in the address each time. Can I develop a one click button to make all this happen upon opening a file from the desktop?

Hi All, Weird behavoir. I have tried to delete a script in Manage Scripts but the script name still remains with zero content in the script. When I try to delete the name and select Delete I get an error message that says "The Script can not be found or has been deleted" This is in FMPA 11.0v4 Anyone know of a fix ?

I have a Layout with a Portal on it. When a new record is added to the portal, I would like the Record Modification timestamp for the main Layout's table to reflect that this parent record has been modified -- but technically it hasn't been, since no data in this table has actually been changed. I figure the way to do this is some sort of Script Trigger "ON OBJECT MODIFY" being applied to all the fields in the portal. Yes? But I'm not sure what action would be most appropriate for that. Suggestions?

I tried unchecking Save Automatically' on layout but then person gets the message evert time they accidentally click the layout. Can I use trigger to stop someone committing but enter info on a new record. Then commit or revert by a button? I know I could create a lot of globals but if I can figure this out I won't need all of that. I tried OnRecordCommit and and then ask if they want to cancel new record, save it or keep working but my custom dialog still pops up too often. With modal window I would prefer a Save button. Not let it commit until button so if they change their mind it can still convert?

This one has stumped me. I am writing a sort of html editor in FM 11. So I went ahead and built a set of buttons just like TinyMce and started to replicate their functionality. Using the Insert Calculated Result I can select a a section of text in a field and add the html tags at the beginning and the end of the selection depending on what button is clicked. To view the result I use a web viewer on another Tab. All good for most of it until I needed to leave the field to replicate the TinyMce functionality. 1. H1, H2, paragraph etc. come in a drop down menu in TinyMce. 2. Special characters come in a window popup in TinyMce as they are too numerous to display. S…

I have a checkbook journal with a calc that figures the balance. I know this should be easy, but I am having a hard time figuring out how to capture the balance daily (the end of the day) and do a simple report, list, or portal that shows the daily balance. ((kind of what you see when logging in to your bank). Any ideas anyone? Than you in advance. Amy

We have many Filemaker databases hosted on server, but have one database that is giving us issues. On multiple occasions a staffer has entered a new file, and a few minutes later the record is gone. You know its been created because we use an automatic serial number for each file and that number is no longer there. When you perform a find, it cannot find the record for that serial number. I have already confirmed that there is not a script written for this. Has anyone else had this issue with Filemaker 13 and Filemaker 13 Server?

In my database, I have a table named CLIENTS. One of the fields is named 'Active' and has a numeric value of 0 for inactive, or 1 if the client is active (boolean format) On most of my layouts, I must use my CLIENTS table only showing the records that are active. So it is a filtered list that I must use almost everywhere. How can I generate a found set of active clients AND be able to invoke it anywhere in the application, knowing that many of my layouts are NOT based on the CLIENTS table? I tried self join with a new TO - making a filtered list also using a global field with the numeric value '1' to match the content of the 'Active'…

Hello, First I would like to say thanks for taking the time to read over my post. I appreciate any tips anyone can give me. If I have placed this in the wrong section apologies, I wasn't sure if this would be a scripting question or a conditional formatting question. A quick explanation of what I am trying to achieve: I am currently working on a project having to do with properties (just to give a better idea of how I wish to use this). I have created a merge fields/text area that will display when annual taxes are due for a particular property as follows: "Taxes due <<TaxDate>>. Estimated amount due: <<TaxEstimate>>." This area is s…

I am looking for the cleanest way to duplicate a given number of sub records from one table records from table into a different table. As an overview Order table is related to PlateMaterial table and PO table. The PO table is in a different file. The PO table has related records in a table called lineItems. I am being asked to script automatic POs that are populated from the records in PlateMaterial. They should function as a look up and duplicate the data. So from the perspective of Order. User presses a button and all related PlateMaterial records are used to create line items on a new PO. I need to know the best practice for handling this. My RUFF …

Windows XP Filemaker 11 Advanced The following is a script "Send Event": "cmd /c COPY " & "C:MarinaPro v14.0MPDMSMPKey.fp7" & " " & "C:WindowsSystem32MPDMSMPKey.fp7 /y" If the Options setting is "Text", all is well and the file is copied. However, if the same event has an option setting of "Calculation", the file is not copied. Why? Also, if I re-structure the Send Event as a calculation, thusly (using a field entry as the directory name): "cmd /c COPY " & "C:" & Marina DB::MP Folder Name & "MPDMSMPKey.fp7" & " " & "C:WindowsSystem32MPDMSMPKey.fp7 /y" I get the following Filemaker intercept, "A number, text constant, field na…

I have a database which has records of audio files which live on our network. One of the fields in the database is the filepath for each audio file. I would like to create a script which will play the audio file which is named in the filepath field. I do not want to put the the actual audio into a container field as this database has over 40k records and will only get larger. I have tried the Send Event script step and i have gotten that to open VLC media player or Quicktime (although even that doesnt' seem to want to happen now), but I then have to go back to filemaker and copy the path from the filepath field. Is there a way to automate this whole proces…

Here is what I am trying to do. I have two tables. the 1st table shows software names and a generic product name that I gave it myself. Ex. SOFTWARE NAME PRODUCT NAME I GAVE IT CONTROL-M/Agent 6.4.01 Control-M Agent Microsoft .NET Framework 2.0 Service Pack 2 .NET Framework Microsoft .NET Framework 3.5 SP1 .NET Framework Microsoft Windows 2003 R2 SP2 Windows Now the above is just a very small subset for an example so you know what i was doing basically. Here is my new problem. Now tha…

Ok, I posted on this subject a long time ago but for some reason I can't find my original posting in my content. So please don't be too harsh on me for re-posting this. I have an E-mail script that I have been working on that I was never able to get fully resolved. Many records contain duplicate E-mail addresses. The reason for that is we have several recurring customers that come to us to do a lot of different little jobs. Since we bill monthly, we can have as many as 20 different records for one customer. The only thing I can't get the script to do is send one combined .pdf file (one attachment, as I know that FileMaker cannot send mutliple http://help.filemaker.com…

Or how do I make my scripts more reusable. Perfect example; Phone number formating. Here is the essence of the script: Set Variable [$AreaCode; Value:Left ( Get ( ActiveFieldContents ); 3)] Set Variable [$digits3; Value:Middle ( Get ( ActiveFieldContents ); 4; 3)] Set Variable [$digits4; Value:Middle ( Get ( ActiveFieldContents ); 7; 4)] Set Field [Tutor::HomePhone; "(" & $AreaCode & ") " & $digits3 & "-" & $digits4 ] Rather than hard coding this script to every field; creating a new script for each instance; how can I make a general reference to the active field? Thus alowing me to have ONE script that can be reused for many similar f…

Is this a common practise? I way toying with this idea because really after a while records should be filled in and not prone to the old accidental edit.

Good Morning all, I need to come up with a way to make an item and total qty be auto consumed by a value that the user enters. example item abcde has 152 qty's. if I type 10 into a field I need the script to create 16 lines. each line will have abcde 10, except for the last one that will have 2 as the qty. Any ideas of examples I should look at. thank you

I am working on a timesheet and have run into a snag, the timesheet works great when calculating AM to PM. But when i try to go PM to AM i get negative result any help on this issue would be greatly appreciated......Thx Lou

I am new to FM scripting and I am seeking help to program a button to open a different pre-determined website in each record, not just the same website in all records.

Hello All. I am trying to write a script (in FMPro 12) with a Loop which does the following steps: (1) copy the content of a textfield in the current record called "code_text" (2) Go to the next Record (3) Check if a textfield called "matches" contains text "yes"; only if it does, do step (4) (4) Paste that content into a field called "accumulated_code_texts" in such a way that any existing content is added to (and not overwritten) (5) go back to step (1) Can any kind person please give me the script steps to achieve this. Thank you.

Hi all My solution is used over a network, and depending on network activity sometimes the system takes a second to respond to user commands, one in particular is creating a related record. If the system doesn't respond IMMEDIATELY I have some users that repeatedly click the button until something happens, creating many redundant records that I have to go through and delete. The data this part of my solution is tracking only needs one child record creating a day (if that). I need to restrict this particular script to only execute if 5 minutes or more has elapsed since the last related record was created. I would actually prefer to only allow the user to execute this s…

Hello I've got a script which saves a PDF to the user's desktop. Or at least that's what i want it to do. Does anyone know if there's a standard output file path which will save it to the desktop of whoever happens to be using the script? The users in this case happen to be using PCs. Not sure if that makes a difference, versus Macs. Thanks. Philip

Hello Board! I've nearly completed the overhaul of my FM app thanks to your help. It's looking great. One step that i'm stuck on is a validation script. I have the user scan a barcode into a Custom Dialog Box. FM sets this as $UI and then runs a IF [Length ($UI)<>10} Exit Script Else.... to make sure it's only 10 digits long. I also want to reject (exit script) it if that $UI barcode has been scanned in the last 7 days. I'm sure this is possible. I would have to run a search for that $ in the table, then do something like 'GetTodaysDate' and then do some sort of match against 'TodaysDate' - 7Days??? I have no idea how this would work. …

I like to use "save as copy" a file and then delete the records that don't have a check mark. How can I do it because right after I use save as copy the script cannot run anymore on the copy file. Thanks. KC

I am printing ID cards 4-up on a page. I have many hundreds of cards to print and putting them in order individually takes a LOT of time. I'd like to print them so the pages do not need to be sorted separately, but can be outputted in stacks. With a normal print, 16 cards would print on 4 pieces of paper like this: 1 2 5 6 9 10 13 14 3 4 7 8 11 12 15 16 I want to print them so the stack of output can be separated and have them already in order, like this: 1 5 2 6 3 7 4 8 9 13 10 14…

Hi all, I'm fairly new to FM after only using FM PR012 for a short time now However I have managed to get past the basics OK but I'm having a hard time learning script steps. Question: I really want to learn more about script steps etc but I'm not having much luck finding books that go in to detail about the correct way to write scripts. I welcome all comments

Hi I have 3 tables in a Fpro 12 file: Jobs Clients Partners I'm trying to do something that I always found quite simple when I kept files separate, but which I'm finding difficult with the 3 tables in 1 file. Namely, include a step in a script which brings another table to the foreground. What I'm finding especially difficult is: 1. Avoiding duplicate windows. So, if I'm in 'Jobs', and want to go to 'Clients', I ant my simple script to say, "if there is already a window called Clients open, bring it to the foreground, but if it's not already open, open it then bring it to the foreground. 2. Going to related records. I'm finding that when in Jobs I ru…

Hi All - I have a problem with one computer at one of my customer locations. I know it's an environmental problem, but I was hoping some of you might have some tidbits to share that would point me in a direction to resolve it. I use the Open URL script step to open a file on the local computer. On this one computer, the Open URL script step will not open a file on the local computer at all. It will, however, open a website in a browser. Here's what I have done in testing it: I created a test script: Open URL["file://C:/Test.txt"] Show Custom Dialog[Get(LastError)] When I run the script, the file doesn't open and the dialog box sho…

I have only been working with FileMaker for a couple of months now, and it seems pretty daunting. The most pressing issue that I need help with is finding the duplicates in my contacts database. I've followed the instructions found here: http://help.filemaker.com/app/answers/detail/a_id/3441 And here is my script: My "UniqueID" field uses the contact's last name and email address to calculate a unique id. I followed the instructions exactly... slowly figuring out how to accomplish each step. I am fairly confident that every step is correct except for "If [$id = Scratch::UniqueID]" because I didn't know how to enter the variable into the calculation. I just…

If my memory serves me well, these are: Enter browse mode Go to Layout (Current) Show All Records. Now my back to basics question is, to what extent is everyone including them? I am particularly curious about the layout step which I really can't see much value there.

I am using Troi File to generate a rather long list of files. This Plug in however radically slows down the entire Filemaker application. My question: is it possible to disable/enable Troi File with a script?

I am preparing to move some data from an old legal calendaring system to a new one. I'm using FMP to assist in the reorganization of some data to make exporting from the legacy system easier. In the old system, attorneys related to an event was tracked using a text field on the event record. The field lists the attorney's initials separated by a comma (Event 1 ABC,DED,MMS, Event 2 DEF,BBD, Event 3, FKD,....). The new system is structured differently, related attorneys are actually a related table to the event table. so, I need to be able to get those attorney initials in separate records and include the eventID field. ABC,1 DED,1 MMS,1 DEF,2 BBD,2 FKD,3 DPW,3 NZ…

How can i make a time stamp field automatically update based on when i change the value of another field. For example lets say i had a field called Ticket Number. Can i have a mother timestamp field automatically capture the time and date i changes that Ticket Number field? I want this time stamp to be its own separate field though and not inside the Ticket number field itself. Thanks guys! Erik

I have attached the below script as an OnObjectTrigger to a field for storing email addresses. The logic works correctly. However, when exiting the field to go to another, even then it exits true, the active field will not change to the next one I tried to put focus on. The field does not have validation on it at the define database level. Any ideas? If [ Let([content = Get ( ActiveFieldContents )]; If(IsEmpty ( content ) or IsValidEmailFormat ( content ) ; 1 ; 0)) ] Exit Script [Result: "True"] Else Show Custom Dialog ["Invalid Email" ; "You have entered an invalid email. Fix it, or remove it."] Exit Script [Result: "False"] End If

Hi, Its been a long time since I had to create a FM db. I don't know how to make an automated copy and paste work. Maybe it is renamed or changed to something else now in FM12. I just want to make a General Journal type file for small business to reconcile checkbook for tax preparation. It categorizes the income and expenses and tells the user how much they have spent in each category for the year. I know, pretty boring. Here is my problem. I can't remember how to make a value list automatically copy data upon selection from the "Amount" container to its corresponding category field. I have tried what I thought was right and have failed. I was searching th…

Ok, I'm stumped. I have a script that on occasion, results in the following message in FileMaker Go: "this item cannot be modified here because it is already being modified in another window" Here's the catch: 1. I'm not using any portals 2. I'm not opening any new windows. (I only have one window open.) 3. I only see this when I bring my solution to FileMaker Go. I don't see this message when using FMP 12 Advanced on my desktop (Mac) with the exact same solution. 4. Also, when I open this solution on my iPhone, I don't get the error either. I only see this on the iPad, and I have the latest iPad Retina (iPad 4) I've done searches which say you need to…

Hi I need to clean up a large text field in an FM database. This is prior to transferring it to an SQL database Basically I need to get it like a .txt file. At the moment it has all kinds of rubbish in as these text fields were populated by crawling large websites - so all kinds of funny symbols in there and mysql won't have anything except clean text The limit of my thinking is to run a script which only leaves the basic keyboard characters - there can be no tabs as the export is to a tab delimited file Please bear in mind I only have access fm 10 pro and fm 9 pro adv Many thanks

Hi Guys, I've been trying to get this one sorted for a couple of years now! Anyway, i more or less got it sorted via a script by Fenton Jones here. It is: Perform Applescript: Let ( [ info = GetAsText ( Contain ); vc = ValueCount ( info ); FM_path = GetValue( info; vc ); Mac_path = Substitute ( FM_path; ["imagemac:/"; ""]; ["filemac:/"; ""]; ["/"; ":"] ) ]; "tell application "Finder"¶" & "activate¶" & "reveal "" & Mac_Path & ""¶" & "end tell" ) So, it works fine apart from when the file's name has a space in it, ie "blah.txt" works but "blah blah.txt" doesn't. Does anyone have any suggestions as to how i can get thi…

Does anyone know a way to suppress the dialog box that pops up when Insert File fails to find the file in the path? I'd like it to just die quietly. Set Error Capture On doesn't help.

I want to use "get (device)" to switch to a layout customized for iphone. However, it doesn't seem to be working. At the start of a script, I'm setting a variable identifying the OS using "get (device)." At the end of the script I have an if statement that if the variable = 4, it should go to the iphone layout. The script works fine if I set it up to recognize the PC ("2") but it's not working for my iPhone 4S running iOS 7.0.6. Any ideas?

Hi All, Hoping somebody can help please or just point me in the right direction. Is there a way to refresh / update calculated fields on a layout. I have tried a 'Refresh Window' script, 'Refresh Object' script but neither appear to work. At present I am leaving the field's browse mode on in Inspector, as I have discovered through trial and error that when I change/add data then click in the calculated field it activates a refresh..... well in most cases it does. This isn't ideal as on one particular layout I have 2 calculated fields, plus two portals each with a calculated field (Four calculated fields in total). The alternative is to come out of the layou…

Hi! I have a client database with two tables: Client, Contacts. Each client can have many contacts attributed to it but each client can have only 1 'Key Contact' which I would like to show in a list format based upon the Client table. What I have tried to create is a simple check box on the new contact layout to highlight which contact is the key contact and then be able to show that key contact field on the client list layout. As a newbie I can't determine if this requires a search, a validation to ensure no two related contacts have the 'key contact' field checked, or something along the lines of a if calculation. Any help would be much appreciated. T…

Hello I have uploaded a sample file of what I am trying to do. I would like to have a portal and add as many photos as I want (up to 30 from my loop script ) , then using a script be able to export the photos to my iPad. I have the scrip working for the first photo but then it stops. I know I need to have a loop function but I can't seem to get it working correctly. Thanks for all the help. Photos.zip

Hi there we have some records with the modified name / date / time etc fields set up to autoenter so we can track who last modified a record... thats fine. We also have a script that runs which loops through all the records every so often performing various tasks. The problem is that the modified fields now are updated because the script has modified the record! Is there anyway to prevent this from happening? I want the modified fields updated only when a user has modifed the record, not the scheduled script.

Hello All, I am running into a strange situation when opening .fmp12 files. I just installed FileMaker Pro 13 Adv on my Mac and now all my .fmp12 files open with that application, which is to be expected. Although, this isn't exactly what I wanted so I select a .fmp12 file and changed it to open with FileMaker Pro 12 Adv and selected change all from Get Information. This doesn't actually work, so I am not sure how to get my .fmp12 files to still open with FileMaker Pro 12 Adv while FileMaker Pro 13 Avd is still installed. Does anyone have an ideas? Thanks, Rich

Hi. I'm trying to figure out how to make a global menu selection (up in the header) and that selection populates a field with the contents of whichever field was selected in the menu — know what I mean? Sort of like this: Furthermore, I'd like to be able to possibly script this such that the result field in every record in list view gets altered simultaneously by the global selection. I'm unsure whether this is a script-able thing or something else, like a calc. I'm reasonably clever, but I probably need you to spell it out for me. Thanks for your guidance.

I have what appears to be a simple problem, but don't know how to address the solution. To keep it somewhat simple. I have two [2] tables. 1. A primary table that contains a layout that contains a container field. I use this container field to hold an image of a client logo. 2. A logo table that contains the client logo, the client URL and and expiration date for the client. [in actuality, there are multiple container fields and multiple client logos] When I open the primary table, my opening script determines whether the client logo should be displayed or not [based on the expiration date]. Depending on the date, I either display the client logo or…

I am tring to select multiple newly created & old created records for printing on a daly bases. These records will change constantly. 1. I have to first find my record in my database. 2. Next add it to the databse. 3. Then I need to some how select it live to be placed in a holding place or que, for printing after I have selected many more records that all need to be printed after all data entry and calculations are done. 4. These records will be changing all the time. Will scripts allow me to take the data from FM Layout screen I enter in and should I use radio checks boxes to put only those records to a print que for printing? Scripts are what will…

Hello I created a portal table which i want to enter some data of a person in it. I see the tables are there, I set "Allow to change" in relation table. whenever I click my script, instead of creating a new record in that portal, my script goes to that layout and stays in. here is my code, (LAB is the portal table)

Hi! I need assistance with a v11 file (attached). Structure: I have a table called Cables, These cables have two ends ( EndPoints) which each have different information and must be summarised separately so they are related records - two related records for a cable. Process: User will add Cables in table view (it must be table view) then type into yellow field to create one EndPoint record then type into orange to create the other EndPoint. The User will perform heavy data-manipulation on this table. User can change values in the orange field but they cannot add a new record through OppositeEnds relationship because it uses <> which I do not wish to …

Inquiring as to whether or not this is actually possible with filemaker, and if so, what would be the best way to go about it. Can filemaker log on to a web site, enter in user name and password, enter in certain data, perform a search, then download the data back into filemaker?

I have a very simple, single-table FMPro12 database, with text fields called 'quotation_html' and 'serial_number'. There are about 500 records in the table. What I need is a script which: -- for each record exports the content of field: 'quotation_html' as a tab-delimited file -- naming each file with the content of field: 'serial_number' for that record Therefore, I would finish up with about 500 files in a folder called 'desktop/quotes' each one named 1 to 500 (assuming that was the sequence of text in 'serial_number') Thank you to anyone who can help me by providing this script (MacOS 10.8.5)

I record all of my personal account details in a database that I started in 2000. I have my three separate accounts in different databases. I have routine income and expenditure items that occur on the same date each month. I have created scripts and buttons to enter these items on the due date. Is there any way that I can program the database so that it recognises the date and automatically makes these routine entries.

Is there any way to send multiple email attachments without a plug in? I know this question has been asked before but now with FM13 have they fixed this? Any thoughts? Thanks!

I am creating a timesheet db for work. I have a start date field and an end date field I would like to create a script that when start date and end date are entered portal rows will populate the dates from the start to end date. I can do this setting fields I am a beginning to scripting any help would be appreciated ......Thx Ljr

Hi, Hoping somebody can explain why this happens. If you have a basic script attached to a button as follows: - If [IsEmpty (Projects::Client Name )] or If [Projects::Client Name = "")] f you place the cursor in a field and hit return then click out the field, so field is still free of any text but has a return in it, the script fails. If I go back into the field and take the return out, the script works. It's as if the return is acting as an entry even though the field is still blank/free of any text/data....... confused I came across when asking a colleague to test a layout and he must have hit return to exit the field after entering txt. We…

Database contains a container field. I want a script that exports the field content to a desktop folder as a jpeg. I have this working on my test machine just fine. However, if I go to another machine on the network it won't work because it's trying to look for the folder on the desktop of the machine I created the script on. So how do I set the file path so that a new folder will be created on the desktop of the logged in user regardless of the machine they use? This is the relative filepath I'm using: filewin:/C:/Users/sjhmcgivernj1/Desktop/S6 as S1 or S3/$test1.jpg Thanks John

Hi everybody, I am doing a POS system and I have 2 databases. The first one has the barcodes and descriptions of the products and the second one has the ordered products. I have a layout from which I would like to read the barcodes of the products and then add their information within the other database. To do it, I have a field through which I want to introduce the barcode. This barcode can be introduced handly or with a barcode reader. I have some problems to create the script to read the barcode. Handly: I write the barcode numbers, strike the enter key and a script "1" is started (when strike this key) to capture the barcode. Barcode reader: I click …

Hello FMForum World, I apologize for my first post being a bust right in there, and help me out question, but, I thought I would see if it was ok. I am not the most database oriented person, admittedly. I am fairly sharp, but this is not my native background. (so warning, there on the explanations!) I work on a MAC V.11 database, sharing off a windows 64bit server, that I picked up from another individual. It was set-up to routinely import data. As part of that process, the person was cautious, and broke out the steps of import into 11 scripts steps. Since the process has been 2 years without much of an issue, and the script steps are lengthy, I was wondering …

Sometimes when I open my database in Filemaker Go, it won't load and I get this message "An installed OnTimer script could not be found or could not be run with current access privileges" I then turn the Ipad off and on again, which clears the problem until it happena another time Anyone any ideas? thanks pixeleen

In a client database hosted by FMS 11 in a Windows environment, I have a script that aggregates records and then uses the Save Records as PDF step. Recently the client has reported the error: "[FileName].fmp7 could not be created on this disk. Use a different name, make room on the disk, unlock it or use a different disk" I'm familiar with this error from past development. I have seen it come up when there are filenaming issues, mostly. However, it began happening in this client database on records that had been saved as PDFs before (with no error) and with the same filename. The PDF script uses these script steps to generate the path and filename for …

I would like to create a script to open a popup window with information and freeze that window, until the user closes it. I saw a post on this forum a month or so ago detailing best practice for just that but cannot find it. Can someone please help. Freeze window does not work, unless I pause the script. If I pause the script, do I need a second script to exit the script and close the window? Thanks, Bill

I need to have a link in each record in my database that goes to the corresponding link with the pdf.

I have a database that contains an Ancient Greek dictionary in XML. The Greek is encoded in Betacode (an ASCII encoding system for Ancient Greek) and I'm converting Betacode Greek into Unicode Greek. My script works, but it takes more than 12 hours on a very capable MacBook Pro (middle 2010, 2,66 Intel Core i7). I would like to optimize the script, but perhaps the size of the file imposes the more than 12 hours of processing time. The features of my db are as follows: 1) 118.115 records. 2) One field per record containing the xml: from 1 to 7595 tags per record. 3) The script contains two loops: 3.1. The first loop takes from the first record (1) to the last (11…

I need this expression modified to create a folder in C:images "cmd /c md " & Quote ( "W:""& SES_SESSIONS::id & "Previews")

I'm currently using Script Parameters to pass a parameter of TriggerType so that I can tell a particular Script to activate only on a particular Script Trigger. Right now I have to manually enter the TriggerType parameter and I'm wondering if there is a Get Function that would allow me to do this as if I want to change when a script is called, I have to manually change the parameters across all of the fields. I've looked through the docs and I can't find anything, but I just want to make sure that I haven't overlooked a Get Function that would do what I want.

Hi. I have 12 fields with the names Phone1, Phone2, Phone3, .... I have go through each and do some work on it. Obviously, I don't want to recreate the same procedure 12 times. I like to use the field by the count I'm on. Here's the start of the code: set variable [$PHCount; Value: 0 ] Loop set variable [$PHCount; Value: $PHCount + 1 ] ##### here I'd to set a variable to field Phone and whatever $PHCount is on ##### so if $PHcount is equal to 1 the variable is equal to Phone1 End Loop TIA. Boyd

Hi, I am trying to write a script that when a user selects a value from a predefined value list, if that value has already been used it Undoes/Removes that value. This script applies to a portal by the way. It works in that if I select say the value '2014' then in the next record I select the same value '2014' it removes it. But if I select '2014', then in the next record '2015', then in the next record '2014' it doesn't remove it. It's as if it's only checking the previous record for a duplicate and not all the records yet i'm telling it to loop through them all to check for duplicates. Here is my script: - Go to Portal Row [Select; First] Set Variable…

I have a database that when i click on a button to go to a report layout based on a table that contains 120000 records it literally takes about 10 minutes to sort through before displaying the results. While 120000 is a lot its seems like a computer in this day should be able to sort that instantly. Anyone else have this issue or know a resolution?

Welp - probably not my best choice of first posts... but I play the cards as theyre dealt. I accidentally set a field to not be able to be modified and always be validated. Needless to say I am now stuck and fielmaker wont let me do anything. How can I access the the database manager so I can change the properties of the field?

I'm wondering if its me, or weather its filemaker. I'm trying to scrape the HTML contents of a page into a field using the insert from URL script step. The url I'm trying to insert from is "http://www.renshawbaking.com/gb/blog.html" and its failing. Is it just me?

Hello, this problem is driving me up the wall. I have 3 fields that all have onObjectEnter and onObjectExit scriptTriggers enabled on them. I am validating the contents of each field in accordance with other complex rules and I want to prevent a user from progressing to the next tab object if a validation fails. The problem that I am running into is that no matter how I terminate the OnObjectExit script on the current field, filemaker ALWAYS progresses to the next field after the completion of the script. I'm trying to avoid having to add additional scripting to check what field the user has come from and wether the previous validation has passed (obviously this is do…

I have developed an English language learning application using FM12 PC version. For example, the left panel displays the reading passage and the right is the answer panel. I hope when I switch from the reading passage panel to the answer panel, I can still read the part of the reading passage. However, it does not work. Whenever I make a switch,the scroll bar of the reading passage panel will automatically reset, which means the cursor goes back to the beginning of the text. This is really inconvenient for users to do a reading exercise, especially when the passage is very long.  Is there any solution?

I run a mac desktop (v 10.9.1; 3.4 GHz i7, 27 in) with a 2nd apple screen on its right. I would like my filemaker database to open on the right hand border of the second screen. I have wrtten a scrip which opens it on the right of my laptop but the same script only positions the filmaker window to the right border of the main screen on my desktop. The script is: Can I only solve this issue using the "bounds" property in applescript? Can I even solve it using that method.

I have a container field and I was trying to write a script to automate multiple file inserts. I noticed that I when I assign a result of a global field (in this form C:Apache24INSTALL.txt ) to where the file lives the dialog would pop up with an error that tells me that it could not find the file. The thing is that it was chopping the directory off of it every time (leaving off the drive letter). Currently to test it I am only trying to insert one file. After trying to get some help on the FileMaker forum I want to ask if anybody knows of this as a bug. I am using FileMaker 13 Advanced on Windows. I tried it on FileMaker 12 as well it does the same. I know that $Path is …

I tried to search for this but couldn't find anything. If I'm in list view and my names are sorted by last name is there a way I can have an alphabet at the top of my list and by clicking on any letter go to the first last name that begins with that letter. I don't want to perform a find on everyone that begins with a certain letter, I just want to go to the first record that begins with it.

Hey Guys,  Struggling a little bit with FM Go 13 - integrated barcode scanner, my understanding is that you use the "insert from device" function to grab the barcode and insert it into a field.  How would I go about, scanning the barcode and saving it as a variable in my script, so that I can then run a find to see if the barcode already exists in the database ? I only seem to be able to insert it into a field.  I've attached an image of the script that doesn't work which should give you an idea of what I'm trying to achieve.  Thanks  JamesÂ

Hi fmforums! It's been a long time since I last made a post, as just searching through the available content here has usually answered my questions [if I search long enough] I'm currently reworking my scripts so that they become universal in my database - less maintenance you see… And I would like to know whether anyone can shed some light on a rambling question I have? In all of the underlying tables, I have some regular number fields, such as: flag, delete, marker… Dependent on their auto-enter calculation at record creation, they’re either 0 or 1. I’m trying to change my script steps so that a script created is independent of any table, for example: …

I am trying to write a script which will copy the privileges from one file to another. I set up the accounts and have them in one file now I need them in the other one. Is there some place where it shows every single setting in a privilege set? Or do I need to take screen shots of every option and sub-option? It took me probably 20 hours to set up. I do not look forward to repeating it. Also I want script to do it because if a file must be replaced then its back up file would only have older accounts and passwords. It would need to be updated anyway. Also, I read up and can find nothing which answers this. If I could get a list somehow then I could use…

I work with FM 12 pro adv, FM Server adv12, Outlook2010, Windows 8.1 ------------------------- I am looking for a... Script ..or...Addon... to attach/link the contents/body of an email ( with date) to a contact/record. I mean coming from [email protected] stored under Johnson company with the same email address. I tried 360W and Dacons Mailit, but these are for receiving/sending not attaching to contact. Any ideas ?? William