Script Workspace and Script Triggers

Hi All, Here I am again, Im trying to copy the script in the starter solution into my work but I cant make it into work. The script that Im trying to copy is the trigger script (Create Product in List) if Im on the list view I tried to make a new record but its not working for me to go to the main data entry of each device, how can I make this script work into my solution.? Thanks to any guide you can give it to me. please find attached file. karenjoy trial.zip

I need to automate ope N URL to go to Firefox instead of safari. How can I do this ?

Hi,  I've got a script which creates a new record in a layout, creates a record in a linked table and then copies text (same text for every record) into some text boxes (so the text can be highlight (bold/italics) during a lesson observation.  So I have a few questions  1   When it creates the new record it always comes up with a Filemaker message to save the record in the linked table. is there a way I can stop this from popping up as it will get annoying to teachers if they are asked to save something before they have even entered it.  2  The Set field trigger isn't giving me the option to tell it what I want to set the field value to. Has anyone…

Hi, I was just wondering what everybody considers best practice in the following scenario: In layout 1(table:invoices) on record 10 Go to layout 2(table:customers) and perform some finds and some field updates Return to layout 1 # IS THE NEXT STEP NECESSARY? Perform find (record 10) When we return to layout 1, do we need to perform a find to make sure we are back on record 10, or can we rely on Filemaker to take us back to the last record on that layout? It just seems that there might be an performance advantage in leaving out the find if you have a lot of records. Thoughts, advice needed! Thanks, Christian

hi everyone, I'm new to filemaker, looking at different video tutorials I've seen the possibility to create custom functions to simplify and optimize the script of my database. in particular it would be useful (not only to me) to create 4 custom functions to control trigger scripts: triggerAreActive triggerDisable triggerEnable triggerReset can anyone help me?

Hey all, Need some advice please. I have three fields in a flat file called, Mobile, Tel, Mail, and I would like to store the values of these in a multi-dimensional variable along with their type (Mobile, Tel, Mail). Is this possible with FileMaker 13. I need to store them in a multidimensional variable so I can process them further in other scripts. $contact[type][1] = Mobile $contact[data][1] = 0123456789 Thanks Jalz

I have an .xml file and corresponding .xslt file that I am using to import data. I am able to import the data using FM client with no problem. However when I attempt to import the same files by running a script on the server I get error 718 - Error is parsing XML file (from Xerces). I can confirm that the server is seeing the correct files within the Documents folder on the server machine ( I had it exit the script and report back the file paths it was attempting to import ). I tried the same operation having the files come from the Temporary folder as well. Error 718 every time. Suggestions?

Thanks for checking this out!  Anyone know a real simple and straight forward way to script the creation of a Parent record along with the creation of a Child with a Grandchild? The biggest hurdle I need help with is this creation of a record set.  So when ran, script would create the flowing set:  ParentTable-Project  >  ChildTable-Assignment    >  Grandchild-Milestone  I have all the match fields set up. Script would be ran from a sorted Grandchild list layout. Project and Assignment data is shown in a sub summary part.  If interested, some files along with demo attached to help illustrate my problem.   THANKS for any help! …

I was wondering, if it would be worth opening a separate forum for this functionality? I has a huge potential, could completely transform the performance of the solutions we build, but at the same time is challenging to take advantage of. This is an excellent article on the subject: http://buzz.beezwax.net/2014/04/04/an-introduction-to-perform-script-on-server It covers all the basics. It also correctly states, that the server can't be aware of the user's context (found set, variables, sort order, etc.). It would be great, if there was a space, were we could discuss and dive deeper, exchange ideas and concepts on how to utilize this powerful function. For st…

Hi, I'm new to Filemaker and I'm working my way through it. I've created a form layout to add data. I've created a script that takes static data from a template table and loads it into specific fields on my layout. When I trigger the script to run from the scripts menu it runs fine and does as I need it to. However, I need it to run automatically when someone creates a new record using an ipad / computer. How do I get this to happen as I can't seem to figure it out and I can't find anything on here that tells me either. Thanks Ann

For the life of me I can not figure this out: I am trying to extract some meta data from a Wordpress MySQL database and I want to create a script that trims before the data and after the data I want to extract. I have been able to create a script that trims data from before the data I want to retrieve and after the data I want to retrieve, but not both. Thanks in advance for your help

Hi folks, I have an assessment database. There's a class layout with two portals, one for assessments, and one for a list of pupils in the selected assessments. When an assessment is created, all the pupils in the current class are linked to it through a join table using a script. Occasionally, new kids are added to the class, so there's a button on the layout to add missing kids to the assessment. This works fine. If no assessment is selected, (i.e $$CurrentAssess is blank), there is an error message and everyone lives happily ever after. If just rolled the database out to someone else, and they've managed to circumvent this error trap by navigating to ano…

Hello, I have a simple if statement (simplified): If [myTable::Value < 0] [result 1] Else [result 2] End If The thing is, I get [result 2] even if Value is less than zero. The only thing I could think was that on the current layout Value is displayed as part of a text box (i.e. "Some text <<myTable::Value>> some more text"), but testing this by adding a field for Value doesn't seem to fix it. I am completely stumped.

Hi, I've expanded on the Contacts start solution and added a Projects table. I have attempted to duplicate the List layout for the projects table. However I am having trouble getting the sort list to work properly. I have tried to understand how the original layout was working with the calculation sort and status fields but I feel I am missing something. The project list layout is still being affected by the contacts list layout - probably due to me copying scripts and trying to edit them to my purpose. Any help would be greatly appreciated. Alex

im a new user and have been pulling my hair out for a week trying to accomplish what i feel should be a simple task. i am hoping someone can point me in the right direction before i go bald…well, balder. i co-teach several different classes at several different schools with several different teachers. i have set-up two tables, a “schedule” which will tell me my daily classes and lesson plans, and a “schools” table that contains the names of the schools, the classes i teach at each, and their respective teachers. they are related by the school. in the “schedule” table, when i select the class for each period (which is a generated value list based off the school I've…

The best way to pose the question is to fully describe what I want to do. I have an application that documents board meetings for an association. The base table for the layout is "Meetings". There is a related table named "Attendance" and another related table named "Trustees". On the layout is a portal to the Attendance table with Trustees Names and a checkbox to indicate if they are present or not. What I want to do is when they create a record in Meetings for a new meeting, I want to populate the Attendance table with records for each Trustee for the current meeting. Then all they must do is, for each trustee, indicate if they are present or not. So how do I rea…

I'm trying to use the Set Field By Name step in an effort to extend coding and simplify a script. The script is called by a button that passes the name of the field into the script as a parameter. In the calculation to specify the target field I'm using: GetFieldName(Evaluate(Get(ScriptParameter) The script is finding the target field as it should. So this side of the script step is functioning as I'd hope. The stumble is on the calculated result side of the script. The calculated result is based on a test of which field is being acted on. Basically, I'd like to use a Let statement to specify the field name to check in a case statement. Something like: …

I have a total newb question... I'm trying to use TrimAll function. Where do I actually place the syntax trimAll(... etc. ?? I'm guessing I have to make a new script but then what do I choose in the left column of the Edit Script box? Sorry but I'm somewhat lost and thanks for suggestions

Total Newbie. I have created an inventory database from the template and have added one more field. It is about a stock inventory for a bar. The issue I am having is: When a bottle of 70cl is taken out of stock, it is being sold at the bar as glasses(calice), 70cl=20 glasses. Only after the 20 glasses are sold that I want that one bottle removed from stock. Please help me with how to write the scrip or calculations to the "glasses" field to reflect the removal of that one bottle from stock. it is the 1st time that I am using FM and I have done research on the issue and have found no solution. Thank you for your patience and understanding. I have attached a screenshot of t…

Hi there, can somebody help please, I have two layouts Console & Weekend plan, i created found set on console layout for records whose start date field match a defined date range, returning found set of 37 records, now i would like to match another field on console layout named "Vehicle" to a field on weekend plan layout named Reg.No, if the match then script should add to weekend plan layout TourNr field information from console layout TourNrID field. As at now, i can find the records matching the date range and can not go on from there......i need help for this script to work please and i thai you in advance.

Need some advice... can FM 13 integrate an executable program/software directly in FM/not outside it, or is there a script than allows this to happen, anyone??

Is there any solution to send email through FileMaker a link ( Hyperlink ) to open the special record such as ( fmp://192.168.10.10/test.fmp12 ) . What I want is send that link as hyperlink to make easy to users to open the filemaker from outlook or any other email even if they are already closing the filemaker , and also I want to switch them to special record what I want to action on it . thanks

I've added a field called SearchField within a Customer table and samething into an Invoice table. When the user click the find button a script is triggered which detects the type of Search to be conducted. If the user enter a 10 consecutive number, the script detects it should perform a find on the customer:phone field, if it 6 consecutive number, it detects it's an invoice:invoiceNo. The script behaves as expected. However, when two user are using the search in the "Customer Layout", the second user must wait until it's unlock. Samething with the invoice:InvoiceNo. Also, the other users sees the caracters I've entered for my search criteria. Is there a …

hello,  I have a button ('pod' = proof of delivery) who creates a mail with a pdf in. The PDF is not created by a lay-out but a scanned document. every record must have a document (POD) This functions works good  question When I push the button he goes to a map and takes the file... What I don't see (before pushing the button) is if the scanned document for that record is in the map. so I want a checking script for each record that tells me if the document is already available. I wanne work with colors Not available = button green available = button red  attachment = script of 'POD'

Hi guys, me again. I've solved this issue myself already but found it aggravating enough that I thought I would post it here and see if anyone else had any similar issues. I have a complicated script that builds an Estimate after the entry of some base information. It is quite fast for the work that it does and has been in use for a couple of years without any problems. The script builds a multi-tiered Estimate for printed materials based on discounting for different quantity levels. The user builds an Estimate from materials and work centers plus markup for the base Quantity then the script creates duplicate estimates for all of the higher quantities desired. …

Hello can someone help me when i enter a information in a new record and came back another day, the information entered disappears but the record still there. I can't figure this out because in the other record it seems to be fine and i don't have any function that can clear out records entered.

I'm ready to pull the trigger, just don't know which ones! I have a text field with a value list of the following checkbox'd choices: All Average Count Std Dev Total I want it so when a user ticks All it nulls the other values (clears the field, save for All), but if a user changes his mind and wants to use any of the other value(s), when they click the other value(s) I want All to be untucked/cleared. It sounds simple enough--and it probably is--just that I'm having trouble wrapping my head around which script trigger to use for when; when I use OnObjectModify and PatternCount to test for "All", I can get it to work so when ticking All it clears the f…

Hi All, I’ve got a dilemma, which I think a multidimensional variable would solve but I’m not too sure how to implement it. I’m using Virtual Lists for the first time and I’ve split my VL data into Columns – 1 to 8. $$Column1 stores the primary key of an object, in this case a customer, $$Column2 would store the customer name, $$Column3 would store the sales for that customer in month a. I would then do another find loop through and store sales for each customer in month b in $$Column5. Again I would doanother find for month c and so on... I'm sure you get the point. That seems to be fairly straightforward as I have customer table related to sales just loop though rec…

I have a script that uses "Save a Copy as" to save a copy of the database to a specific network drive. this is working great....but I want it to happen at a specific time every day automatically. I've been reading up on onTimer but I'm still missing some important pieces to make it work. There are also some some questions I have about it. If I assign a timer to a layout and there are 7 people in the database, does the back up happen once or 7 times? What's the best way to do this? Jason

Hi, Questions. I have a customer that want to close the current window using the command key and some other letter key. I know the "Command Key" and "W" closes the app. And I will need advise the customer on certain keys. However the issue is I can not see the "Command Key" when using the "get ( ActiveModiefierKeys ) I can see the "Shift" key as 1 but I can not see the "command" key as 16 ( mac ) according to "Filemaker's" Get(ActiveModifierKeys) instruction page. I've pasted the entire thing, so can someone please explain why I can not get the 16 in my message box Message box: "Modifier Key :"&Get(ActiveModifierkeys) "Key : "&Ge…

I want to remove certain field names from a text string. The company needs the ability to specify the fields to exclude in a sync process on a per table basis. I do not want to hard-code the field names for obvious reasons, nor do I want to preface each field with 'EXCL_' which is currently required by EasySync so I created a cf which allows management to insert the field names and then get the object IDs from them. The same cf is a toggle, switching from the object ids to the names and back. What will be stored in a field is the field object ids. Then during sync, I need to take the field names and append them with [1]<field> to create the identical match t…

Hello, Maybe I've been searching using the wrong searchwords but I can't find an answer to my question. I only seem to find answers about catching keystrokes and not sending them. I have a button which should send the 'ctrl+shift+z' keyboard strokes when clicked. This keyboard shortcut makes our phone dial the selected phone number automatically. We are working on windows FM 13. How can I script this? Thank you for reading and eventually answering my question.

Hello is there a way to open a file from a FMP database? I have a field with all the Path Info How to tell the Finder to set the FMP field and open it? Thanks a lot Dan

Hello, I am new to File Maker Pro and i a trying to find out how to do some simple reporting - i searched all around but could not find even 1 example that simply and straightforwardly explains how to do this I have 3 sample relational tables and i have some data in them ( all relations have been set up ) car_make ( id, make_name ) car_model ( id, model_name ) car ( id, car_make_id, car_model_id, color ) I need to set up a report with 1 dropdown list DropDown list = Car Make This should auto populate with all the entries in car_make table When this changes, I need to find all related records in the car table and display all data ( all columns …

Hi Guys, I'm trying to create a Virtual list, so far it seems to be working great. I populate a global variable called $$MyData and display the results via a VL. Is it possible to to inset a value into line 24 of $MyData using one of the commands or do I have to write a custom function to do this. I've seen there are a couple of custom functions which can extract a line out based on a line number, but Im interested if my $counter says 24, the value goes into line 24 of $$MyData. Many thanks Jalz

Hello, new here... I was hoping someone could help me with this simple application of AppleScript within FileMaker. I'm trying to grab the value of a field and have it as a variable in AppleScript set myVar to cell "Index #" This works fine. Index # is a field on current layout and while in Layout Mode its name displays exactly like this. But when I attempt to grab value of a field which in Layout Mode displays as ::Name then I get Object not found error. This field is still on the current layout but orignating from related table "Personal Data" How do I reference this related table and grab its field value?

If logged in under a privilege set without rights to modify a field in another table, I want to run a script which can modify that field. I thought that I could check 'run with full access' in the script but that does not work because when looking in debugger the field displays 'no access' and the script will not change the field. Do I need to re login as full access developer before I can set that field? I think I am unclear on the purpose or meaning of that checkbox 'run with full access' and I searched and can not find anything on it. Can someone explain a bit more for me? Thank you for listening.

I have separation system and I do not want people to see the data file so its opening script uses Adjust Window[hide] I even tried running it as subscript from the interface file but the data file still shows in the menu bar under Windows. How can I keep it from showing at all? Ideas appreciated.

Hello All, I'm using Filemaker 13 Advanced and have a solution in which we use a barcode scanner on a laptop running window 7. The barcode scanner is wireless and we are checking in products that have a model number (field 1) and serial number (field 2) into our database. The person checking the products, scans the model number, then has to go back to the computer and tab to the serial number, scan the serial number, and then go back to the computer and go to the next field. I'm looking for a way that when the first barcode is scanned, filemaker just automatically goes to the next field. So the person barcode scanning does not have to keep going back to the co…

I have a three layouts in my solution. Staff, student and Admin. And these three layouts correspond to Three privilege sets i have.. Now, I want to script the layouts such that each redirects a user (from a privilege set) to his/her appropriate layout once access has been denied.. I have already configured the security accounts and privilege sets, a student accout gets access denied message when entering a staff layout.. Etc.. But now, i want the layout to automatically redirect the user to his/her appropriate layout once it checks the privilege set.. Please how can I do that?

I have a slight problem with some UI that I am hoping someone could help me with. We have a small bit of UI where the user is supposed to pick a 'type'; if that 'type' is 'book', then we want them to enter data into a 'book_name' field. However, if the 'type' is not 'book' (there are 5 other options), then we don't want them to be able to interact with the 'book_name' field at all. Now, we have accomplished the functionality of preventing this by putting a 'onobjectentry' script trigger on 'book_name' that checks the 'type' field, and if type is not 'book' then it moves them to another field. However, the user is still able to click on the drop-down arrow for the …

Hi All, I have a fairly large suite of FM solutions that I host for a whole department, and I'm looking for a way to manage users more efficiently. I've explored a couple options, and was hoping for some insight on managing users remotely, from a 'stand-alone' FM solution. First off, I realize I can do external authentication via LDAP ... and am currently working to incorporate this into solutions in the long term, but have run into some road blocks with our internal LDAP authentication. I'm exploring a 'stop-gap' solution for now, which is what I've attempted to outline below: Concept: I currently have a solution which receives requests for access, a…

Can anyone offer an explanation for this scenario. A script on the client creates a new record in table A. Within that same script, Perform script on server is called with two parameters. Parameter 1 is the serialized id of the record just created ( the id is created upon record commit.), and parameter 2 is a global field from a different table. The Psos script goes to a layout for table B. Parameter 2 is used to find the correct record. A field in the found record is then set to parameter 1. The problem is the field set to parameter 1, has the value of parameter 1 and a carriage return. I don't know where the carriage return is coming from. Parameter 2 …

Earlier this year I added a feature to MBS Plugin. Just by installing plugin on Mac OS X in FileMaker, the script editor shows a new button to copy the text of the script. This is very nice to paste it into a forum like this one. just to let you know Christian

Any way I can make Gmail (webmail) recognize the fmp protocol? If I send an email that contains: fmp://domain_name/Database.fmp12?script=open_case&param=serial Gmail strips off the fmp therefore users cannot click the link. If I put "http://" before the entire string, it just strips off the semicolon after fmp, therefore, still, rendering it useless. FYI the emails are sent from server, not that it makes a differemce. Any ideas here? Please don't tell me snaphot link because that's a 3-step process and I'd rather not clutter their desktop with files. Thanks, Agi Mac OSX 10.9.4 FileMaker 13 v3 Chrome

Hi, I'm stuck on something that seemed so simple before trying to implement. Here is the scenario: Each record has 6 container fields for product images. 3 non-watermarked and 3 watermarked (the watermarked are just copies of the non-watermarked) I only display the 3 watermarked on a layout. I often manage very similar or even identical product substitutes, therefore I like to "share" the images rather than take new ones. By share, i mean copy/paste or duplicate. The issue is this: Ideally, i would like to drag an image (the watermarked file) from one item and drop in the container for the substitute item. However, I need the non-watermarked image to also get …

I need help figuring out how to write a script for this task. I have a very large database (8000+) of members. There are two fields for their names: first name and last name. After their last name, there are some appended letters designating their certification. I need to write a script to remove these appended letters from all the inactive members. So for example: First Name: John Last Name: Smith, A.B.C. I need to have the script remove the ", A.B.C." part from all the members flagged as inactive. How should I go about doing that? Any help or resources you can point me at would be fantastic. Thanks!

Ok so we have a company table with only one record for us. We put our address and phone in it as well as our fiscal start date. I want to use script to allow certain privilege set of manager to change this value from wherever they are and I did this company::fiscal_date has auto-enter "replace existing value" and all that is in the calculation is a single global field called g_fiscal_date Now it is my understanding that changing a global will change the real record it is in but only that record and that if the manager runs script to set this g_fiscal_date to a new date that the single record it is in will change the real fiscal_date. It works in testing…

Each record I create has a unique ID. When I create an new record that ID automatically increases by increments of 1. When I create a record in error, and delete the errant record, I need to reset the next ID so it retains a linear progression. I have created a simple script that allows me to reset the unique ID of the next record Go to Record/Request/Page [Last] Set Next Serial Value [Visit::Statement No.; Max (Visit::Statement No.) + 1] The above script works, except for one thing: I want the reset ID to read: "00000X" or "M0000X". In each case the reset value increases to the next value, as required, however the FULL ID is ignored. For example "00…

I was puzzled when a test for a script error failed in the following situation: Set Error Capture [On] Go to Layout ["Billings" (Billings)] Enter Find Mode[] Set Field [billings::InvoiceDate; Date(1;1;1900)] Perform Find [] Set Variable[$error; Value:Get(LastError)] If [$error > 0] Exit Script [Result:TRUE] End If The problem was that in some cases the Find found no records, but the $error variable remained empty. The problem was traced to a trigger script attached to the layout Billings, which was set to trigger on Record Load. The trigger script has the effect of 'swallowing' the error code generated when the Find fails, and by the time control retur…

Hello, I am now trying to run a FMS script using XML. I've never done that and I am totally new to this type of operation. The script I've created is very simple it only write a new record onto a table using the layout fmsProduit. The purpose of this script is not to change anything but to only write new records. Here is the syntax. I've copied the line down below in Safari and nothing happened. Could someone help me with this? This is greatly appreciated. Daniel fmsXMLINFO.pdf testXMLcall.pdf

My cable company asked me to track programming to troubleshoot a problem. I have a single table file with just 29 fields and two very simple custom scripts. The "loopy" script that's a problem: Go to Record/Request/Page [First] Loop Duplicate Record/Request Insert Calculated Result [select TVSeries::Date Show; TVSeries::Date Show +7] Go to Record/Request/Page [Next; Exit after last] End Loop Go to Record/Request/Page [First] The purpose of this script is to create and maintain a unique list of shows for each week. The previous week's shows are duplicated and the newly created week's list of shows gets modified manually. The list is printed weekly for the cab…

Hi all I need to have a script to simulate Microsoft's Word "File->Open URL" command and paste my file's URL there. I need to open my file from server, without downloading, using WebDav. I've tried to use following script: tell application "/Applications/Microsoft Office 2011/Microsoft Word.app/Contents/MacOS/Microsoft Word" open file "https://www.myserver.com/webdav/MyDoc.doc" end tell but i got error: "execution error: Microsoft Word got an error: file doesn’t understand the open message. (-1708)" Thank you for any help.

I'm trying to compare part of one string to another. If the sub string matches the string then I need to copy the item code for that lens from the table it resides in to a line item on a transaction. An example of the data for the code I've written: Items::CL_Include[1] = Focus Dailies 8.6 Items::CL_Include[2] = Items::CL_Include[3] = Items::CL_Include[4] = Items::Item Code = c8 Trans::ContactLensR = Focus Dailies 8.6 some contact Rx info here The problem I'm having is that SET FIELD doesn't copy the data from the Code::Item Code to Trans::St CL store OU field Can someone tell me what I'm doing wrong? The existing script uses SET FIELD [ Case( hardc…

Hi there, We have a hosted file on a shared FM13 server. (triple8.net) I am trying to import data between 2 tables of the same file, but keep getting error 100 - File is missing The import script parameters I'm using for the source file are: fmnet:/fm.Triple8.net/filename -(filename is replaced with the name of the file) Are the are special settings / steps that need to be taken to import between tables on fm server 13? Mark

Hi there,  Im trying to get the hang of setVariable and am having trouble getting variables acquired in one file to be set in another file. Can setVariables  be used across files?  Â

I am trying to use an OnObjectExit script trigger to validate if a field is empty. If the field is empty I want to show a custom dialog message and then send the user back to the field if they choose LastMessageChoice 1. I have create the following script but it's not working: If I execute the script from the Scripts menu it works. But if I execute it with the OnObjectExit trigger it displays the custom dialog message but it's not sending the user back to the field.

Wondered if anyone could help me? Right now, I have a layout based on a table where if a person presses the "Submit" button, they commit the record and also start a new record. In addition, I created a script trigger that when the layout is "OnRecordLoad" that a new record is created and the AccountName of the user is set to this record's foreign key. The problem is that now I have way too many empty rows in my data. Whenever a user just loads the layout and exits out (even without entering any data), they end up leaving an empty row.

I recently moved a database from a server to my local mac. Opening the file when it was hosted on a server, it always opened to the same record. Now that it is local, it opens to the last modified record. Not sure why the database on the server acted the way it did, but I would like to have FM open to the same record every time it's opened. How can I do that?

Hi , I am really new to FMP 13 I wonder if someone can help me to figure how to put the TEXT in a Layout like in the picture I attached, by SET VARIABLE. I want to put it appear on the screen (print text on layout).  Can I make a script single script to get all those data or I need to make every single variable ?  Please help my seniors. Â

How we can get an warning popup message on every data field to avoid incidentally editing or When we go for editing any data field(Once data have entered). Thanks

Hi there, We use FM go in multiple locations, which is using a file hosted on a remote fm 13 server. At each location we have a number of users logging into FM go on 1 ipad - Currently we have them switching between users each time someone picks up the ipad to enter a new record. Our current process is that before they enter any details they click a login button which runs a "Re-login" script. They then enter their username and password and login. I'm getting feedback that the process is a bit 'clunky' - often there are a number of people standing at the counter and our users need to get the data loaded as quickly as possible. they don't want to have to re…

I have just downloaded a trial version of FMP13 having been away from the forum for a while. I want to create a 'links' style segment on my client contactsl homepage where I can quickly access web pages / information that are relevant to the client in question but not on the client's homepage. Whilst I can obviously use the URL script step to access the client's homepage, I would like to be able to have a portal with several different url's that can be added to without the need to script each web page individually - a kind of dynamic button that would link to the web by clicking on the URL listed in the portal / URL table. I wondered if this is do able - I am…

Hi everyone, Wondered if someone can help me? I'm kind of new to Filemaker and I have created a database that works off of Filemaker GO so that users can fill out information on a table called Diary from their phone. My question is, is there a way to create a script that can send an alert to a particular email address if the user of the phone app doesn't fill out information from their Diary table for a certain amount of time (if they haven't filled anything out for the last 24 hours)? On a similar note, if such a script is too difficult, is there a way to create a report that shows that user's answers for the day, but can this report be sent out automatically…

Is the Location a blocking function ? I tried to put the Location in an OnTimer Script but then I could not click on any button when the Location had to search for the satellites. What I'm trying to do is to "activate" the GPS (without 3G or Wifi) in the background while the user is preparing to get his location later. As you know it can take a few minutes without 3G/Wifi so it's why I want to do this in the background. Launching the script Install OnTimerScript ["GPSActivate"; Interval: 2] The Ontimer script Install OnTimerScript ["STOP"] (I want the current function to run only once) Set Variable [$$Location; Value:LocationValues (200;250)] Any help…

Hi,  My client has photos stored in a container field in a table. There are a few thousand, so obviously I need to script it. There are some examples for scripting an export from container fields out there, but I'm getting stuck with an 800 error "filename could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk." I'm trying to write to my /tmp/ folder, so permissions shouldn't be an issue and I don't see any other obvious problems. I've attached a screen shot of my script. Any ideas?  Once I get past this, I guess I'll see if the looping actually gets me through all the records in the table.  T…

I have a layout that has many tab panels. We are using Filemaker 12. There is one tab panel that only a couple people should have access to, I thought i could assign a script to OnTabSwitch, so if you were a member of a certain privilege set you'd get a message and be redirected back to the tab you were on.  I get the message to come up but it won't Go To Object, I'm somewhat frustrated, it seems like it should be rather simple.  The script is attached, I have  a few extra steps because I have been messing with this issue for a while today.  Any help would be GREATLY appreciated! Thanks Â

Afternoon Guys, I could do with some help with following code: Set objFM = WScript.CreateObject ('FMPRO.Application')¶ If objFM.ScriptStatus = 0 then¶ Set objFMfiles = objFM.Documents.Open(‘Database.fmp12','un','pw')¶ objFM.Visible = True¶ objFMfiles.DoFMScript ('OpenQuotationScript')¶ End If¶ This code basically opens a word doc after it has had it's bookmarks populated and closed. The code works fine until a different user other than the one I used in the 'un' & 'pw' is logged in and then I get a WSH error. So is there a way of using the Set objFMfiles = objFM.Documents.Open(‘Database.fmp12','un','pw') without needing to use a username &…

Hi When in the scene details layout and using the pop out for the all unit report, when you select dates it still generate a report that includes all dates even though I have asked it to go between the dates selected? It also shows up all the dates as well whether you select them or not. Can anyone help and see what I am missing as I cannot see what else in the report sort button trigger script I need to make it sort the between selected dates, or to make it work with selected dates. thanks Crowd Breakdown Template backup copy 5.fmp12.zip

Hi there, I appreciate any help, I have two tables and I need one of them filled with the info from the other one ID Name Subject 1 Subject 2 Subject 3 23 John 34 Tom Id Name Subject Order Subject 23 John 3 Math 23 John 1 Bio 23 John Geo 23 John 2 Reading 34 Tom 2 Math 34 Tom 1 Geo And I want to populate the first table as this: ID Name Subject 1 Subject 2 Subject 3 23 John Bio Reading Math 34 Tom Geo Math Is it possible with any kind of lookup or if function? Thanks

Hello FileMaker Pro experts, Would appreciate your help for the following: How do I sort data in a row of Fields? For example: Fields A=300, B=100, C=600, D=200, E=400, F=500 I have to obtain the following results for the above data in Fields: P,Q,R,S,T,U sorted in ascending order as: P=100, Q=200, R=300, S=400, T=500, U=600. How do I formulate the calculations in Fields: P,Q,R,S,T,U to obtain the results in ascending order? Many thanks in advance. Lawrencex

I'm stuck on how to configure a script and I know I must be overlooking the obvious... I use FilemakerPro as my CRM in a sales business. I make notes each time I speak to my clients. I have a script that will automatically begin a new note with a date/time/contact_method stamp notation in my notes field followed by a space and then the curser for me to begin typing the notes. Simple so far. Currently each new note begins below where the last note left off. What I want to do is script the starting point for each new note to begin at the top of the field so as I add more notes I can always see the most recent notation without having to scroll to the botto…

I'm working on a database that was created in an old version of FM. There are several files, one per table. It has since been upgraded to FM7. There is a file for Jobs and one for Invoices. I've created a script to create invoices using a number from Jobs. The script copies a number from the Jobs file. It then opens the invoice file and launches a script. The invoice file's script creates a new record and pastes the number in the proper field. The problem is that if the number already exists, I end up with a blank record and "INVOICE NUMBER” is defined to contain unique values only. You must enter a unique value. How can I tell the script to end if the number alread…

I am running FMP 13 Advanced on Windows 7. I've just been through a very frustrating exercise trying to open a PDF file with the default program, Adobe Acrobat, using Send Event. After extensive testing, what I've found is this: Send Event for a .TXT file results in the application associated with .txt being launched for the file. This works fine. Send Event for a .PDF file with the PDF file association set to Adobe Acrobat Reader results in Send Event returning an error 3 and Acrobat does not start. Send Event for a .PDF file with the PDF file association set to FoxIt Reader works fine (FoxIt Reader opens the PDF file properly). My test case consists of a one-li…

Hi - I have a single file runtime solution, and working on an upgrade that requires conversion from pre-FMP12 format. I'm using the Convert File script step. I've run into something very strange. My solution uses it's own file extension .fhc. So I've set up the Convert step with no dialog and with a specified source file - namely 'fhcm.fhc. The first several times I tried this, the output file was named fhcm.fmp12 - as expected -- and the original file was left unchanged, since I specified no dialog. (It does not get changed to a fp7 file extension. Somewhere along the way, the Convert File step started naming the output file FHCM #, where # is a digi…

Hi everyone, On Filemaker Pro 13 I'm trying to run a script that performs two Import Record actions (both from an ODBC data source). The script is performing the imports into the same fm database. The script gives a completion message with no errors, however only the first import works. The second import does not process any records. When I run the imports separately, only one at a time, either scripted or manually (File>Import Records>ODBC...) they both process records successfully. My problem only seems to occur when performing multiple scripted imports. Does anyone know if there's a script action I have to perform in-between the imports? Any a…

I have a 'home page' that is meant only to have a greeting image and a few navigation buttons, so I don't want it to display in any mode other than 'Browse'. I have an 'OnLayoutEnter' script trigger set up to Enter Browse Mode and Hide ToolBar . . . but if someone enters Find mode on another layout and navigates back to this home page, the layout appears in Find Mode -- I assume because the script trigger doesn't fire until the Find is executed? Maybe I'm going about this the wrong way -- what's the best way to have a Layout behave like a 'Home Base' (rather than a Table with Records) -- should I be creating a dummy Table for it? THanks!

I have created a script that gets the layout count and then loops through to get all the layout names. The script works fine except I need it to get the layouts from another window. So, in the script I move to the window name in question and begin the loop but it gets the values from the original file not the currently active window. I guess this is the way it works, so is there any way around this? There is not relationship between the files nor do I necessarily want one but if it is the only option I guess I can go that way. I know with databases like SeedCodes SQLExplorer it can be done and in this dbase you do actually add the remote dbase to the relationship …

I need to hide the Status Toolbar so that my users do not get distracted by it. I do not want to use Kiosk mode as the users do want to be in Full Screen mode. I have done some extensive digging but can't find this option. I know I'm missing something really simple. Thanks! Jason

Hey Everyone, I've been doing a lot of Pause/Resume script steps in a solution and I've got somewhat of a hack for the task I'm trying to accomplish, but I'm wondering/betting there is a simpler solution. For example, the work flow works something like this. There are Three tables Invoice, InvoiceItems, and Products. The user is looking at the Invoice Layout and adds a InvoiceItem. Then, they need to pick a reference Product. From this point, I have a button on the InvoiceItem record that says "Add Product". I run a script that shows another "pop-up" window with a List View of Products with pictures. The Script is Paused. Each record has a button that says "Selec…

What is the easy way to have a script copy a found set of records and then manipulate some data in the copied set? Specifically, I have a table that has date field and has a bunch of other fields that basically tell me how much inventory I have on that day. I then want to run a script that will pull the ending inventory on the last date in the table, copy that information and create a new record with a beginning inventory level on the new date (the date the script was executed). The catch is that this has to be able to run using FileMaker go. So importing/exporting the found set isn't an option. Any help would be appreciated.

Hi All, I am getting a weird record creation error on occasion and I am struggling to find the source of the error. I have an Installation creation script that is straight forward but on occasion the record is being created but the Key Field data (Contract_No) is not being entered and therefore the related record lookup data fails. In the background of this on the system that is acting as the server a backup script is acting on an On Timer trigger. As the creation script is fairly simple I am wondering if the On Timer script may somehow be interfering with the creation script. Create_Installation # #CHECKS THAT A CONTRACT VALUE HAS BEEN ENTERED, IF NOT EXITS …

I have a cell named "BurnDVD_the_list" in a table named "@Preferences" SCRIPT Set Variable [$$the_list]; Value:"01020804"] Go to Layout ["@Preferences" (Preferences)] Replace Field Contents [No dialog; Preferences::BurnDVD_the_list"; $$the_list] Perform AppleScript ["display dialog"bSET" "set FMPrec to cell "BurnDVD_the_list" of current record "display dialog"bSET"....] RESULT the variable $$the_list is set to "01020804" the field BurnDVD_the_list is set to "01020804" a dialog box appear showing "bSET" en error cannot find the object is displayed, I click OK an unknown error : -1728 is displayed the dialog box "aSET" is never displayed The error is then a…

Obviously, it is possible to export records that are grouped by particular fields. But I have to import that exported records to create new table. So it means if I'm making it automated by the script, I'll need to do something like this below within script Assuming there are 1000 records here, and there are 3 fields such as FirstName, Gender, and State So something like this => Mike, Male, CA 1. sort by Gender field and State field for grouping 2. set a variable for export destination path. 3. export records (gropued byGender field and State field) to the variable above. Assuming it became 200 records for total after grouping as result. 4. impo…

I was very happy because of this new script step but I can't use it since it's change a well formatted URL in something else automatically. This is part of the url request correctly formatted (if I paste it in a browser or I use scriptmaster, it works) (1) %09%2B393397186745%09Gentile%20Comandante%20Carlo%20Maaak%2c%0a%0asiamo%20felici…. this is how the Insert From URL Script Step submit it (2) %09+393397186745%09Gentile%20Comandante%20Carlo%20Maaak,%0A%0Asiamo%20felici…. You may notice, for example, that %2B that is a "+" correctly URL encoded in the url (1) is "+" in url (2) %2c that is that is a "," correctly URL encoded in the url (1) is "," …

I have an input text box to search for records in a portal. I use OnObjectSave -trigger to add the found portal row into my data set. How do I put the cursor back into the search field to allow for quickly entering a new string? Think of it as sitting and punching in details, one after the other.

Hi all Possibly 2 questions here. I have a script that occasionally slows down if I run it locally, this is due to the fact that some layouts sometimes (I have no idea why - any suggestion why?) display the 'sorting records' dialogue box of which the script waits for. Is it possible that this problem would occur when the script is run on the server? Thanks

Hello everybody, I have a database where the very first step is to add a new patient. When the button is hit, a custom dialog box pops up asking for patient last name, first name and social security number (ssn). The SSN is validated so to be unique and to show a warning message in case inserted patient has the same SSN as a previous one (i.e. the same patient has been created twice). When everything goes well (that is, SSN is unique), the record is created in the current demographics table and also new records are created in related table as appropriate. The whole procedure is script driven. When the same patient is inserted twice (i.e. the user is trying to inse…

Is it possible to use the set variable script step more than once in the same script? I'm firstly using it to determine the number of pages in a report header ( 1 of 4, 2 of 4 etc) and then I want to use it again further down the script to name and save the report as pdf. If there isn't a way to do this in the same script are there any other ways please?

I've been using FM for decades, so when I decided to do a KickStarter project using FM to build a custom database to track all the backers and fulfillment was a no-brainer (especially since KickStarter's toolset is non-existent and 3rd-party solutions are expensive and limited). The database has actually gotten sophisticated enough that I'm strongly considering releasing (unleashing?) it as a FM application, but I'm having an annoying issue with the Import Script Step One thing I'll have to do for the application is provide an "upgrade from previous version" feature that imports data from an older version into a new one -- I expect that once other people start usi…

I want to trigger a script on another client machine from an iPad. A counter-person with an iPad submits an order, and inventory office sees their screen refresh with the new order. I've been doing an onTimer script, but it's a little buggy and *not fast enough*! ( I've set it for 20 seconds, more often and it gets *really* buggy. ) It seems like Troi Activator *may* be able to do this, but it's not clear. I'm not sure if the plug-in needs to be installed on the source device, target machine, or both. Any ideas on whether this is possible with Activator or something else?

I am trying to do a quick find script that only shows records where the Company Field Matches the CompanySort Field, which is a global variable, preferably with only that exact match. Both fields are text fields. I am also having this problem with finding records between two dates, which are also global variables. It says "No Records Match This Find Criteria". I have the drop down for CompanySort populated by all the values for the Company field. Date, Start Date, and End Date are all set to be Date Fields. None of these Company searches work. The second one for the Company, "Exact ( Budget::Company ; Budget::CompanySort )" will pull up records, but they are com…

I've researched this pretty extensively and all of the sources I've found say that you should be able to call a Script Trigger from a script by using the 'Set Field', 'Set Field' by Name', and 'Set Web Viewer' script steps as they interact directly with the Layout. However, I have a script with the 'Set Field' script step that is definitely not resulting in a Script Trigger being activated in FM13. Did this behavior change in FM13 or this perhaps something else afoot here?

I’m working on a Mac OS X 10.9.3 and have a FileMaker 13 Pro developed app that I’m trying to implement a SMS solution in. I’m getting an Error 3 message – Command is unavailable (for example, wrong operating system, wrong mode, etc.). and will be implementing on iPad as well. Can you give me a hand on what I need to do to get this to work?

Hello all, I have a strange problem that I have not been able to work out over the past few days. I have created a popover search bar for my layout and am using the default Asset Quick setup. Within that inside the Asset Details window I have created a popover button that exposes a search bar. The odd part happens once a quick search has been done. The search provides the correct assets in the list, however it ALSO includes what ever asset was currently selected. For example If I have 3 items, each in a category of "Laptop, Desktop, and iPad" and the Desktop asset is selected, when I perform the quick search with the word "Laptop" I'll get the laptop item, …

Hello I have a script that creates an indesign file with correct measurements, and it stores it perfectly when I set a fixed filepath in the AS. I need a filepath that is calculated to a folder on a server. If I put the path in as text, in AS, it works fine, but when I insert a $$VAR it somehow does not understand what it... I am using the following (wich works but is not calculated) save document 1 to "MC Kranten:Weekproductie:WK03:H24997188_POLDER-EN_2.indd"¶ I have tried to create a calc field for the whole path+name and use that in a $$VAR but that does not work. This down not work: save document 1 to" & $$DOCPATH & ¶ Is there anyone th…

I would like to have the user be able to re-login without closing the database. I don't know how to create that re-login script.

I have several older databases (not designed by me) that do not have unique key/identifiers in each table. I would like to run a simple script that loops through every record in the table and adds a serial number (which would then be incremented in the future automatically). Is there a way to disable the auto-enter options during my script, so that I do not alter all of the "last modified date" and "modifier" fields in every table? I know that I can do this during data import, but I'm not sure if it's possible via scripting? Thanks!

Philosophy of Scripting FileMaker 13 Training Course Chino Hills, Calif., June 18th, 2014 -- Well known FileMaker author John Mark Osborne is teaching his intermediate and advanced scripting courses titled the Philosophy of Scripting. These two courses will be taught in a remote setting via GoToMeeting at half the normal cost. Remote classes are taught twice a week for a total of four hours per week. This allows for better absorption of the material as well as the advantage of homework assignments. - Philosophy of Scripting 101 (9/16/2014 to 10/22/2014) - Philosophy of Scripting 201 (10/28/2014 to 11/19/2014) - Philosophy of Scripting 101 & 201 (9/16/2014 to…

Hi Everyone, I'm trying to write a script that will generate a rather large and 'nested' report from my database. I haven't gotten very far yet- I'd like to know if what I'm attempting is feasible, and if anyone has suggestions for the route to take. My database includes records of products ordered, when, who by, and many other details. The report I need to generate will contain many pages, with smaller reports nested amongst others. For example, the first page would be a list of the companies which have placed orders in a time period, and the total cost of the products they ordered. Following this would be another page for each company, each breaking d…