Script Workspace and Script Triggers

Hi, I'm aksing myself how I could make the trigger functionality of the fmstandards package work. When I call the CF TriggersAreActive, I get True(1) as a result (in the Data Viewer or inside a Set Variable script step). When I call TriggersDisable and then TriggersAreActive again, I still get True(1), so Triggers are still active. I could simply use a $$ variable to save the trigger state, but I don't want to, because that can lead to problems using subscripts. What am I missing? Thanks a lot for your help, Gary

Hello FM community, I'm VERY new to FileMaker and i have a daunting task i put upon myself. I know what i want to see but i dont know how to get there in the end. Well i have some ideas but its not working so i thought i'd ask for help. I'm building an employee check-in/out system for our front desk and i have the basic GUI designed, and i've tried about 20 iterations of coding this thing to work the way i want to but i'm so lost. What i want to do is to be able to have a pull-down list of employee names and tie them to 2 buttons a check-in button and a check-out button. Once you select an employee and a check-in/out button there will be a tab thats called STAT…

Hi All, Apologize if an answer exists already...did some research to no avail. I have a script running a 2D array on a single table of records which has worked fine for me in past projects, but this time the "key" is a simple number field as opposed to a text field. The problem is that the numbers range from 1 up over 2000. The Array seems to lump some of the single, double and triple digit numbers into the 4 digit number keys also affecting the totals. Basically, as a result instead of 1744 records being reported the array is lumping everything into only 818 records despite the "key" being unique and records with 4 digits are reporting inflated totals. …

Hello, I have more than 10k executable files, each EXE export data to a single table, inside of an unique MySQL. I created a FM database to manage all data (ODBC), but I didn’t solve how to trigger a script from an external EXE, without looping for new data each minute. Questions: #01: There is way to trigger a script in an open database, without looping ? #02: Runtime solutions can be used with parameters? My best idea, at this time, is to create a runtime solution and a relationship, and call it from the EXE. I do think is a "stupid idea" and there must be clever solutions out there. Thanks for all …

In one of my layouts I have created an ID Card like view that has a persons image and layered over the top of it I have some fields. Is there a way to export that composite as an image? I was thinking something like if I grouped the composite and gave it a name I could export it as a script step but searching came up with mostly how to copy layout objects to a different layout... Currently it works to screenshot the composite but I would like to automate the process a little bit. Thanks for any help

Hi all, First, I'd like to thank you in advance for help. I'm having some "newbie" troubles, please don't beat me up too bad. I'm writing a script that I would like to accomplish several things, however, I am having trouble with the easy part. I'm trying to have a custom dialog box to popup and have the user to enter name of a facility, which then attached that name to a global field. (ie g_CompanyName) I also have a layout (receivables) with a field that is a dropdown box that is referring back to a list of facilities and their contact/address/numbers data. (ie facilitiesIDfk) At this point, I can go to that layout (receivables), I can click the d…

FMP 15. When the scrip step Go to layout executes, I get the error “The script cannot be found or has been deleted”. When I click ok in the dialog, FM goes to the layout. What could cause this?

FM won’t create a pdf file. When I use File/Save records as/pdf I get the error message “File 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 have no trouble creating files from other apps and the disk has many GB of storage available. Further, the disk is not locked. I try different file names, but get the same error.

We have multiple vendors and each vendor has parts / materials / components we purchase from them. Issue is the value list for our Purchase Order forms is now has so too many entries, too the point its not useful. Is their a way to create a script that pulls up a different set of value list based upon the vendor selected? Or is their a different way of handling this for creating purchase orders?

Hi, I have a list of about 400 keywords Im looking for from a free form text field. What I am trying to accomplish is to find the number of occurrences of keywords from the list of keywords in the txt field where i have many paragraphs of text. I have one field where I have all the keywords stored, all lower case Another field where I have free form text, all lower case. I am trying to see how many times keywords from the list come up as pattern matches from the text field of free form text. For example here is a short list words im looking for : bob went store and the text field has "bob went to the store, then…

My webshop server has changed from the default ISO-8859-1 to UTF-8. My existing scripts in FM11 Pro Advanced says: <xsl:variable name="CRLF"> <xsl:text>&#x000D;&#x000A;</xsl:text> </xsl:variable> What codes should I write to change it to UTF-8?

I have two tables: People, Programs Fields in People Table: Name, InterestTimestamp, Program, Enroll Date, Completion Date, Rank There are (4) programs: A, 1, 2, 3 (where A is a pre-program) I currently have a script that will rank all people who are not currently enrolled, (based on each Program, quarter and timestamp). Because the programs are all 4 quarters in length, the completion date is calculated based on the program entry date that I select. all of this works really well...but: What I need is for this to be done dynamically. In Program 1 I have 20 enrolled. However, the each may be completing different quarters. Instead of me picking an enrollm…

Is it better to have 1 long script with 5 different if statements or 5 different scripts? (the 5 scripts would be assigned to 5 different buttons, the long script would be assigned to every single button)

Perhaps I'm tired...but I would like a refresher on the subtle difference between these two triggers. In my use case, my script enters find mode, sets fields, and finds the target record (a scripted gtrr). Now that I found the record, I'd like to set all the default button bar $$active_segments, and perhaps nav to certain panels. At first I tried OnLayoutEnter, but apparently that doesn't fire in Find mode. I could add all the setting of stuff to the script that does the find, but it occurs to me that perhaps OnRecordLoad is the better approach. Thoughts?

Hi. I hope this is in the correct forum: I would be very grateful if anybody can give me a script I can use to achieve the following in FMPro 12 on a Mac. -- I have a table with fields "serial_number" and "export" -- I want to export a separate tab-delimited file containing just the content of the field "export" for every "serial_number" in the table, named "serial_number.php", all going into a folder called "EXPORTS" -- The serial numbers are all unique to each record in the table, starting from 1 up to an unknown value (new records can be added at any time) but some numbers are missing from the sequence where records have been deleted and so we need…

Hi guys you may have done this before but i cant find it so i was wondering if you can help. I wish to create a button that when pressed creates a new record in a portal . I then wanted to go to this new portal line and copy from the same field in the previous line to this new line and so on. I tried this and couldnt get it too work so i did this. I created fields in the customer layout with the names and serials of the equipment on that site. I then created the script to do a new portal row ( works fine) then copy from the customer field to the new portal row field . Basically im trying to duplicate the record . but with the new date. im probably going about …

I use filemaker 11. I like to take each picture file and match it to the filename and insert the picture in a folder. My logic should be as followed: Loop for each picture in a folder, set the variable x as a picture filename. Search x(picture filename) Insert the picture file to the container End I have problem look to set variable and set it as a picture filename from a folder. Can anyone help me to look for the right function or command from filemaker 11. Thanks. KC

Hello, I am working on an older FMP 11 database and trying to create some new features while we wait to migrate to FMP 14. I setup a layout with some basic data collection, where some of the fields are simple YES/NO drop down selections. The data gets populated into another layout for printing and exporting, and I have a few fields where the visibility needs to be based on the result of the YES/NO response. That seems to be available with the inspector in FMP 14, but all of the users are on FMP 11 for a unknown amount of time. I assume this needs to be created using a script trigger on the layout, to run at OnRecordLoad. Something like If table::record = Y…

Is it possible to set a trigger on the tabs that sets one global field/one variable? For example: I have seven tabs: Monday, Tuesday....Sunday. Clicking each tab would set a variable: Mon, Tue... and so on accordingly. But I can't assign script parameter to each tab - it sees it as one script with one parameter. I can name each tab as object, but how do I extract object name and use it for changing data in the field/variable? I hope it's clear...

Hello Am trying to clean up the email field on a filemaker database. At the moment there are many records that contain more than one email address or an email address and text. what I want to do is delete everything in the field apart from the first email address In the vast majority of cases the required email address is the first thing in the field. So my thinking is that the script would have to read along until it found an "@" symbol and then truncate the text at the next space comma or backward or forward slash as they are generally the methods people have used to separate the email addresses. Apart from that am struggling - I would be delighted…

I am seeing if this can be done via a script / global fields . I have gotten blood from a stone, by using my head. I have two issues when the category is empty yet set to print lower left, i get duplicate output, second extra return at the top line of the last category

I have a group of students in my class that are all working on different subjects. Each student has unique key id field as so and each student has a subject they are taking which is another field. What I am trying to do is see which subjects each student has not taken yet. So if the key id has records for (history and math) but not reading, I need to have a new field that tells me that I need to have the student take reading next. I bet this could be done via a script but I just do not have the FMP skills to build the script to do this. If possible I would like the script to be able to output as a spreadsheet the key id and the subject missing for each key id. I hav…

Hi, Some wisdom please .... For some reason, when we duplicate a record initially we get a delay; Canada timed it on their end and they say 1 minute. With me, it was 15-20 seconds. After initial duplicate script runs, when the user selects the script it runs instantly. Please see attached pic. Could somebody explain what might be the issues ?? Any insight what might be going on. Thank you. DuplicateScript.pdf

Predict Future dates Good day gurus, I am in dire need of assistance with a formula that would allow me to calculate future dates based on five fields for a service database, e.g. There are five fields; Field 1: Frequency_of_the_service (e.g. monthly, quarterly or annually) Field 2: Date_sold Field 3: First_service_data (30, 90, or 365 from the date_sold) Field 4: Last service date (based on field Predict Future dates Next Service dates (based on last_service_date) Based on these five fields I need to populate a portal by adding a record for servicing every month, quarter or annual. The portal can be a separa…

Not sure if this is the relevant area however, I couldn't seem to find a scripting section What I would like to do and I have had no success so far is the following scenario. I have database which stores references to files in container field located on a folder on a shared computer. What I want to do is have a script which when run populates the database with the names of those files located in the folders on the computer and create a new record for those not already present and if they are already present ignore the import. I have tried a test script which gets the documents path and loops through each record however I get file unknown when debugging…

I want to create an image of the clock, with round dial, numbers as buttons (from 1 to 12, maybe even half an hour numbers). So here is the challenge (for me...): 1. Each button changes color on a corresponding slice of the clock, if you click once - white, click again - original color and so on back and forth between those two colors... Multiple colors would be nice too. 2. Using two buttons to select a chunk/slice of the dial, for example click on 12 and 4 will turn slice between 12 and 4 numbers into white color automatically without clicking on each number in between. OK, changing colors - conditional formatting - easy. Using one script for doing it - s…

I read in help: "OnRecordLoad Triggers a script to run after a record is made current or entered, such as after a user or script switches to a layout, switches records, opens a new window, creates or deletes a record, or performs a Find operation." How do you find this Script trigger, and how do you apply it? My aim is to trigger a script for each record I look through. What do I do, to see it available when I choose Set Script Trigger?

hello everyone i'm newbie in filemaker, while I'm exploring the uses of FM12 i also started making FM12 solution (sales invoice). i bought a barcode scanner to test it in FM12 solution i made. the problem is i don't know what script will i use once i use the barcode it will display the item name,price and description in the fields. or otherwise just type the SKU/ product code to display also the price,description and prod name, hope you can give me sample FM solution. below is the draft FM solution (sales invoice) i made. thank you in advance God bless everyone.. sales_invoice.bmp

above image shows my patient record regarding previous prescription ..... i made button with plus sign above assigning duplicate record request ...... problem is when i am clicking button nxt record is showing like below ... showing me incomplete data only few fileds data is visible why is this happening someone please help me thanks please

Would like to give user the choice to "Close" or "Publish" report after viewing. What is the best, and most straight forward approach for this. At the moment, I have two scrips, one called "Prieview", and the other called "Publish". Would be nice to have ONE script that first "previewd". then published if user chose to. With the preview script, I have it so it just builds a report in preview mode. With the publish script, I have so it builds this same report, then saves .pdf, then emails it do noted contact. When a report is build in new window, in preview mode, via script, and script is set to pause... you get a "continue" option, to, obviously continue the s…

I had a previous solution in Windows using Sendevent to select a folder, then create a text file of it's contents, then import that list into a field, one tabbed item per record. "cmd /c cd " & $importdir & "&&" & "dir /b > filelist.txt" Moving to a OS X, I'm trying to use the excellent BaseElement plugin. I've used BE_ListFilesInFolder to get the list of files in a folder and have it dropped into a text field. The output is tabbed, one item per line. I can't figure out how to create a script to get the contents of that field, and populate each line into a field, one per record. Any ideas?

Hi all, i have a pdf stored in container field. Is there anyway to convert it to jpg and export to desktop? I need solution for Windows and Mac. Best regards,

Can you script curser entry into a field? I know you can [navigate to field], but what if you have the field "checked" as "no entry;browse mode"? I always thought a script would over ride, and allow entry, even when not marked as such. Reason for the question is, i want a field on layout to be modified, but only through a script. THANKS!!! =)

made solution made scripts to export data and import automatically into customised folder but i dont want the export file to be in that folder i want it to be deleted through script is it possible if yes someone please guide me to script please

Hello, I need to create a script to search all records in a found set and if a particular field for each are all the same value (0) then 'do something'. To illustrate what i need see the attached. Record 1 there are 32 in total, 27 have been delivered and 5 remain Record 2 there are 3 in total, 1 has been delivered and 2 are remaining When the script runs to reduce the delivery remaining count I want it to check if all records for this field are now at 0 and if they are 'do something' I suspect that I need an IF statement and a LOOP through the records but it is the "IF DeliveryRemaining = 0" for all records which i am confused at. Hope t…

Hello, New to the forum and a FileMaker novice. I'm working on a solution at work that contains multiple portals and I'm trying to work out the best way to filter them. Currently I'm filtering the records in the portals by creation date and completion status. I have buttons which toggle the state of global fields "FILTER_DATE" and "FILTER_COMPLETE" and that works ok. It filters the portals successfully but it sorts all the portals on that record and I'm afraid having multiple users browsing the same record on different layouts will mess with the filter settings for each other. As I continue to build the solution I feel like this method is going to get cumbe…

I have a solution to track employee expense reports which contains a container to store a pdf of related receipts. Currently, I create a multiple page pdf of receipts in Apple Preview, then paste it into the container. Was wondering if it was possible to create a FM script or AppleScript to drop a single, additional pdf into the container and "automatically" create multiple page pdf with the existing container contents? Thanks in advance!

Hi all, I want to create an action as part of a script that operates if the result of a calculation produces an integer such that: If[ Field A / Field B = Integer ] Show Custom Dialog [xxxxxx] Exit Script Can anyone assist please

Hi All, I'm struggling with a script. I have three tables - Clients, Progress notes, and Add on progress notes. From a layout on the clients table I want to go to related records in the Progress notes table and if a field (Set AON) is set to "1" the script will print the progress note and then go to the add on progress notes table and print the related record(s). Then back in the Progress notes table, if the field (Set AON) is blank, print the progress note record. Below is what I have but it's not working as I expected. It is printing each of the records from the progress notes table first, then prints the record from the Add on Progress Notes (I'm actually not…

Hi Does anyone know how I can use the get url script to include a variable field data source. example.: my url is "fmp://[email protected]/" I have a field with variable numeric data e.g: "20" I would like the script to end up opening the url "fmp://[email protected]/20" Any guidance on the best way to do this would be appreciated.

Hello! My apologies if this is a newbie question. I've been tasked with fixing some issues with our FM database, which means I am trying to learn how to use it. I have not been able to find a solution yet and not sure which topic it would fall under. Our database: We are a vet clinic. Each appointment has its own record, but each client may have more than one appointment. If we duplicate the appointment to save time on data entry, mistakes are often made to update information for the new appointment. Is there a way to have the client's information (address, phone, etc) populate in a new record when we type in their name or some other identifying info?

Hi all, I know this should be easy but I am not getting it right. The mail gets sent but no attachment

Hi something pretty simple , just can`t seem to get it right , i would appreciate if someone could guide me on this. In my solution i give out jobs to my workers , they all see there jobs in there individual portals/logins. what i want to do is that 3 days after the end date of the job it should hide from the portal. How would i do that ???/

Attention: Before posting in the general discussion forum please review the other forums that would best suit your topic. If you cannot find one then you may delete this text and post your topic in this forum. Hi everyone, I have a table DEADSTOCK like that: ------------------------------------------ Product | Open | Close MER | $10,757 | $764 OBU | $6,590 | $78 PAT | $2,471 | $0 RAP | $9,253 | $261 RIT | $1,252 | $0 ----------------------------------------- In monthly sales report (associated table: ORDERS), I need query table DEADSTOCK to extract a summary data, I u…

Hello - If I run my script to insert a PDF from a saved PDF I get an error after the insert picture step saying "can't find the file" - I tried "insert PDF" but the debugger says it is a wrong file type. The data viewer shows - $temppath as filemac:/Macintosh HD/var/folders/bd/v_q7j9997d1dph_lz5m1x_mm0000gn/T/S10/Dec 2016-2077 UTAS Retainer.pdf the Script is as follows; Set Variable [ $temppath; Value:"filemac:/"&Get(TemporaryPath)&Project»DATA::worksheet filename&".pdf" ] Save Records as PDF [ File Name: “$temppath”; Current record ] Go to Field [ worksheet PDFs::PDF ] [ Select/perform ] Insert Picture [ “$temppath” ] Any help…

I would like to get the contents of a field before changes are made (for tracking). A script trigger "on entry" seems to work for regular fields but Checkboxs and Radio Buttons styles seem to change the contents before the trigger runs. any suggestions? Thanks John

I am not sure if I should be in this forum or the printing forum. Here is what I have. I have an inventory database. Everything is done but I need to be able to print a receipt for any inventory not turned in. It is a student database so the primary key is the Student ID. I have nine fields that are filled out with either: 1. Not, Received, or Not issued. I want to be able to print out a receipt showing the student what they still owe us before they are cleared. I am just not sure how to do that. I was thinking maybe a script that looks at the field and only picks out the "Not" , takes that label and puts it on the receipt for example: Geometry Book: Not …

Hello, I have a Script that takes an image located in a Container Field and exports it to a designated folder. I have tested this when exporting it to a local machine and it works. On the script, I have it exporting to our FileMaker Server. I have a field that is set to show the path of the export location. When I execute the script, it shows the proper path, but the file inside of the container is not being exported. *I have made sure the folder security allows the server Write access to the folder. *The initial script that executes the script on a server is working properly. Any help is appreciated. Thanks. …

we are trying to implement a solution where we use a shared solution (only two computers) setup. How would I need to distinquish sales (invoices) from each machine. I think the Get(persistantId) would work but I thought I read that this function doesn't work in a shared environment. Only local versions of the file work for get(persistantid). I tried to implement this and it seems to be that's the way it is indeed..I set up a script to capture the id of the machine when the program is opened on and it does capture the id on the (host) main file but upon opening the remote (client) the script does not kick in. Any Ideas on how to implement this. Is there a way to have filem…

Hi all, it's been a while... I'm trying to capture two script parameters by clicking a button. The first parameter is supposed to give me a key for looking up related line items by date, for example the first quarter of 2016, and I also want to capture this as a literal text. The script parameter I've attached to the button looks like this: "1|2016¶ 2|2016¶ 3|2016¶" & "1st quarter 2016" The problem is that the second line is interpreted as the second script parameter. How can I express it so that the entire block is interpreted as a single parameter and only the text blurb at the end is interpreted as the second param…

I have an FM flat file Club management database held in a Dropbox folder with one administrator and four users who work on the file. Tables include Members and Tuition. These are related. In the Members table there is layout records for members attendance at meetings. In the Tuition table there is a layout comprising records for tuition sessions and attendance. In certain circumstances we need to add member Attendance records to the Tuition layout. This is activated by a script. One of the script steps I "Import Records" within this "Specify Data Source" is set to Specify File "file:xxxxx.fmp12". The problem is that when the script is run it throws up an error me…

I'm trying to create a loop script (eg. pauses for user interaction and then continues via a button) that will allow the user to select one or multiple checkbox values in a single field. The field here will be "Fiscal Quarter" and will have multiple values (displayed as checkboxes) such as "Q4 15", "Q1 16" and so forth. I'm not sure off the top of my head how to generate new find requests from the user clicking multiple checkboxes within a single field. The goal would be to generate a new find request for each checkbox checked, and to remove the find request if the checkbox is subsequently unchecked. I'd like to avoid separate hard-coded fields for each Fiscal Qua…

The database has table1 with “Sample No” field relating it to table2 with “Sample No” field. Table 2 has a portal on a layout with Table1. Each portal row has the Category field with one of 3 values (MF,BP and CC). There are about 7000 samples. Each sample has from 1-12 portal rows displayed with 1 or more occurrences of the 3 category values one of the values shows the count of each value per sample. The question is how do I write a script so that every sample has all 3 category values (MF,BP and CC)? I have the following scripts for when there is only one value/portal - one for each of the 3 values (3 scripts are the same except that “Molecular F…

Hi guys/gals, Hope you might be able to help out here. We're working on Windows version of FM/FMS. When I create a client record I manually create a folder within our documents folder on the network and copy/paste the folder path into the folder field. It normally looks something like this: "\\SVR\Documents\CustomerName" When we create a job on the system an order acknowledgement PDF is emailed out to the customer and a copy of the order ack placed in the customers root directory (as above). This wasn't a problem when we first started with the FM solution but now we have hundreds of customers with dozens of Order Acknowledgements cluttering up the root…

Good Day Greetings from the Philippines Im working on a subject loading system for a community school, As illustrated below, I have two layouts the first one is the layout for data input interface. The second one, is the layout where the operator can choose a class schedule and insert into the first layout. My problem is how to implement a schedule conflict detector in case there is one and prompt the user of the conflicts. Can you show me how to implement either in scripting or calculation method. Appreciate the help thanks in advance. Best regards, Pele

Hi, I would like to know which is better: Using scripts trigger on layout enter Our through regular scripts that is attached to navigation button. I currently have a script set to go to a layout and sort all records. Would it be better if I put a on layout enter script to sort records so that it's always sorted? Would this slow the performance? I apologize for the text being centered. I'm posting from my phone and I can't find the option to correct it.

Through a scripted routine a client system generates a new contract and exports as a pdf as a temporary file (Get(TemporaryPath). It then creates an invoice, exports as PDF and appends this to the contract and finally it sends the whole pdf out via email. This year the client would like to have a sales related pdf that is not generated in Filemaker be the first document in the process, appending the contract to that PDF and finally the invoice to that, so that the client receives one pdf that first has the sales piece, with the contract appended and finally the invoice appended. This all happens in a looping routine, moving on to the next client contract after …

We have just migrated from Mac Mail to Gmail and the beautiful little script that we used to use to PDF Certificates of Attendance and attach them to emails isn't working with Gmail as it stands. We are using SMTP to generate the emails now. Set Variable was as follows: $exportPath Get (DesktopPath) & "/certificatesOfAttendance/" & "CCWTCertOfAttendance_" & StudentIDtoCustomer::First_Name & "_" & StudentIDtoCustomer::Last_Name & "_" & Course Registration::Course_ID_3 & ".pdf" followed by Save Records as PDF: file:$exportPath Is there a way to get Gmail to grab a newly created PDF and attach it via Send Mail? …

Hi guys. I have this faulty script with a "Run Applescript (calculated): "do shell script \"ffmpeg -i\" & videofile_field & \" -filter:v select=\"eq(n\,500)\" -vframes 1 thumbnail.jpg" I can successfully run the command in Terminal (without the filemaker field entry off) It extract frame number 500 of any video file and makes a jpg of it. I use my home directory for this because its easier. I'm hoping you can help me with my script. I think its difficult to make bash commands in filemaker but thats life i guess. (i'm running Filemaker Pro 13 on MacOS 10.12)

I have a simple Applescript that works in Script Editor tell application "Keyboard Maestro Engine" do script "Search the Web" end tell I add this same script (with escape chars) to my RESOURCES::A_SCRIPT field inside FM. The RESOURCES table is not connected to the other tables in the graph. "tell application \"Keyboard Maestro Engine\" do script \"Search the Web\" end tell" I've tried this with this field being defined as a Global Storage Field or not. Similar problems with both. I have an FM Script called EXECUTE: Perform Applescript (RESOURCES::A_SCRIPT) When I run this FM Script I get an error message: "Error: -…

how to copy a script written in notepad into script window can we paste external text in script window ??

dear experts i made few records with calculating sno filed with Get(RecordNumber) when i am deleting particular record serial number are not updating serially and looking awkward sum1 please help me to rectify this problem please REC CHANGE.fmp12

Greets all: I've read the FileMaker Help on this (http://www.filemaker.com/help/13/fmp/en/html/scripts_ref1.36.43.html) as well as some of the threads here and I just can't wrap my head around how to implement the Set Field by Name for a short script...assuming that's the correct command to use, of course. I've attached a screenshot of what I've done so far just so you can get an idea of what I want to do: For any field that has a On Object Enter script trigger attached, what I want to happen is that when a user clicks in that field it will toggle the result; if that field is empty the script will insert an "X" into the field; if it already has an "X", then it …

dear helpers i attached a file i want all the male people searched in a table and the found number of males number should be displayed in other table please need help please OP CLIENT.fmp12 tried some scripting in op client 2 my medical brain is heating up please sum1 help me OP CLIENT 2.fmp12

Hi All, I can never seem to get my head around file paths and even more so when we need to use variables. Can any of you help me with the following please? What I have is an inventory system that has been adapted from the starter solutions, I have created a new field called colour. I have a folder system set up with lots of different colour folders i.e. black, blue, yellow etc... I would like to add a button that performs a script that goes to the correct colour folder so that I can select the correct part. The folder path containing these colours would be "/Users/USERNAME/Documents/FOLDER/FOLDER/FOLDER/FOLDER/HERE ARE THE COLOUR FOLDERS" if that makes…

Hi All - I have a customers layout with two tabs, one is for the customer address and the other tab has the billing address. I want to have a check box with a label that says "Is Billing address the same as Customer Address?", that when ticked copies data from the customer address fields to information, as an example the CustomerStreetName field would be copied to BillingStreetName field. Could someone give me a basic example of how this might look please? Thanks

Is it always safe to delete a script when the DDR lists no Layouts that use the script and no other Scripts that call the script? I'm trying to clean up my file without shooting myself in the foot: I can't think of why I would ever need such a script, but don't want to find out the hard way that I could still need them. Thanks in advance, Guy

Hi! I'm trying to create a script that would automatically set value in the radio button field from the assigned value list when value from the other list is manually selected to a drop-down field. Any help would be appreciated.. TNX!

I've updated the Backup white paper. The article describes how you can set up backups with FileMaker Server, using just 3 backup schedules to produce an unlimited amount of date/time-stamped zip backup sets and move them across the network. Both Windows and OSX.

I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script: Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded: Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.

Hi, I try to put in a container an audio file with the text pronounced by FM from a text field. As I didn't see how to do it from FM, I tried to build my first Perform AppleScript [] using the terminal command "Say" On the terminal : (say "hello") works fine. and (say "hello" -o filename.aiff) => creates a file with the sound "hello". From filemaker, Perform AppleScript ["say \"hello\”"] : make the Mac pronounce correctly. But I can't run : Perform AppleScript ["say \"hello\” -o filename.aiff"] I have a error message "Identificator can't be after identificator". I couldn't find anyway out. Does any of you have an ide…

I have a food inventory database that has a month-end final report food-type category as it relates to how they are expensed in my accounting system e.g. Food 5001, Beverage 5002, Vending 5010, etc, etc. There are 12 expense categories altogether accessed by a Popup Menu. The month-end report has a Sub Summary field “CategorySubtotal” that provides a department total value based on a sort by the Category food-type field. Works very well as a printed report however, once my chef confirms that the report is an official end of month reporting of his inventory I am having a hard time determining how to save each of those sub summary amounts to variables for the pu…

I have two fields: Centimeters and Inches. I am trying to type in one (and vise versa), example (CM): 55-58 and then auto populate (IN) to 21.65-22.83. I was thinking using left or right function, but maybe there will be 3 or more digits in between the (-) symbol. What would be a good way to identify those digits in this case, so that I can apply the conversion vs script? Thanks

Hey all! I’m returning to FileMaker after many years away, and my brain is still dusty. I’m trying to figure out how to solve this problem: I have a table called Recipients, full of people I’ve emailed a drip campaign. Besides their name and email address, each Recipient record contains a set of fields that indicate the date when each stage of the drip campaign was emailed to them. These fields are named Date Sent 1, Date Sent 2, Date Sent 3, etc. When a person responds to an email, I want to manually enter the nature of their reply into a text field called Response. As soon as I edit the Response field, I want the Response Date field to automatically get filled…

XPOST Our company is switching to VPN for remote users to to connect to our FMS-hosted databases. So I want to incorporate connecting to VPN into our already established procedure for accessing those databases via a FileMaker script. Our VPN connection is up and running. And I found an AppleScript that works well making and continually checking the VPN connection. But I don't know enough about AppleScripts and how they apply to FileMaker scripts to make it work. From what I could find on the subject, I need to modify the AppleScript steps to work in FileMaker; such as adding a \ in front of each double-quote. But, apparently that's not all. Here is the raw AppleS…

HI! I am trying to create a script that will jump from one layout/table to the related record in another layout/table (if there is a related record) OR to the first record in the destination layout/table (if there is no related record). I know how to do this separetly but not as a part of the same script. Any ideas? I know I could create two buttons with different script but the idea is to have only one button that would perform either "Go to related record" or "Go to record first" if there is no related record in the destination table/layout. Thanks!

I created a script that creates a .PDF file in a specific location using a variable ($FilePath) to the file path: "filemac:/Macintosh HD/Users/me/Documents/Letters/" & "You_" & List::CourseFaculty & "_" & List::CourseQtr & List::CourseYear & ".pdf" This works fine and the PDF is created in the location specified. However, I am trying to figure out a way to script the Send Mail step (at a later date) to go to the $FilePath and attach the file created based on the employee name (same as above). I tried to simply list the variable $FilePath in the attach > file path, but with no luck

Hello all, I want to start out by saying thank you to everyone that takes time to answer questions on this forum... I've learned a great deal from Forum questions and problems posted by others and have been answered by the great folks in this FM Forums community! Cheers! My Question - Current Script is an If statement that changes my Maintenance_Task::status from "SCHEDULED" to "SERVICE DUE" when conditions are met in the Hours Field. Also an optional Checkbox to be used when task is completed. See script below: If (TASK COMPLETED = "TASK COMPLETED"; "COMPLETED"; If (Engineering Machinery::HOURS ≥ NEXT SERVICE; "SERVICE DUE"; "SCHEDULED")) I…

Hi, I am trying to trouble shoot a "New Record" script we run. I am not sure how to explain it properly but apparently me and the gentleman I am developing with when we run this script, the script creates the "New Record". However, when the customer clicks on the button and the script runs, the new record step seems to be ignored ?? I'v removed all restrictions on this user and they are now logging in with "Full Access" privilege, thinking that their privilege set / custom menu set may be the cause but even with "Full Access" the script still "Ignores" this "Create New Record" script step ?? I've turn on the "Set Error" step to catch the error but no erro…

I am using Insert From URL to send HTTP GET request to my server and get the result. I have a function PING that returns 1 if the server is online, but it cannot returns 0 if it is not so I am catching the error on filemaker : Connection timed out; the timeout value is 60 seconds. Is there a way to reduce this timeout value so the user does not have to wait a minute to know that the server is offline ? Similarly, if a process takes too long to answer, is there a way I can timeout the Insert From URL command ?

I have a Payments List View layout that can be opened from any layout using: New Window . . . Go to Layout . . . Except this one other List View layout. It just ends up as a new window of the same layout. New Window . . . Go to Layout . . . will not open any other layout. Driving me nuts. What causes this? FM15 Advanced

I have a database full of backgammon positions. Each poses a problem with a correct answer and I've set up a nifty layout with a global field for the user to enter his answer, and other fields that reveal commentary on the proper play once the user has entered the proper answer. I have descriptive fields set up that allow the user to Find problems on various themes that he or she might want to work on.So far so good! Now what I'd like to do is write a script that scrambles the order of the problems, or selects them randomly. I see that there is a "Random" calculation function that will generate a random number between 0 and 1 . . . but I'm not seeing my way to…

I have the following fields in a table (classical music): Category Category 2 instrument 1 instrument 2 instrument 3 instrument 4 I would like to make a script that export to the following conditions: IF "category" OR "category 2" contains "Instrument" then output the contents of "Instrument 1", "Instrument 2", "Instrument 3" and "Instrument 4". If I add two or more conditions the default is AND. How do I change this to OR?

I have a Layout in Table Mode as (partially) shown in the attachment. (Note: First row will have a Country Code in it - not shown in attachment) I want to "fill-down" the last country code in all rows (in the Country Field) UNTIL the country code changes. Then I want to similarly do it for that one. Until I reach the end of rows. My database will grow from 500 to 10,000 rows of text/number data. I am uploading in batches from Excel. Is this possible? I've tried various calculations and scripting without much success. Thanks! I'm trying to get something like this: COUNTRY IT IT IT IT IT IT IT IT ES ES ES ES ES AU…

Hello FM Mavens, I am in search of a script solution that would be the equivalent of a "Go to Tab X" in a portal. Filemaker.com has an old example file named EG6145.fp7 which can be downloaded but it does not work in FMPro 15. Any suggestions? Thanks

Hi I have a login that will not allow someone to sign in after the expiry date. The user is setup in the user layout and it has a start trigger script that reads if it is expired each time you open the file. In the user layout it shows the amount of days till it expires. But when you are in the time sheet layout when it is not the admin account it puts a ? at the top left rather then the days left. And if it is expired it still allows you to login. I have this in another database and it works perfectly. I thought I had copied everything over correctly, but cant get it to work on this one. Also when you click on new user in the user layout rather then adding a new lin…

Hi in my solution my customer has a list of all its projects in a portal. the portal row is a popover button where it displays limited related information to that project to the customer. i want to create a button in the popover which would fire an email requesting more information about the project. However i run into a problem , i tried to set varaible of the customer and project howeever of the project it does not capture the correct one just any / the first project created. How would i get my button to capture the correct project related in that poover button?

Hi all i require urgent help , i had added a on record load script to the front page of my solution , unfortunately i see the script is somewhat buggy , and i can`t get in to the solution it doesn`t not open. script just running and running , any idea how i can stop it from running

I have a dialog window with buttons. I open the window in a script, and when I click on any button a script runs with a single parameter containing text identifying which button was clicked. The button is set up to resume the original calling script. On resuming, the calling script closes the dialog window and acts on the text message, which is stored in a global field called message. My question is, how can one in effect create a default button? I want carriage return to cause the appropriate message to be added to the message field and then resume the calling script. Typing carriage return should be equivalent to clicking the default button. The layout trigger OnLayoutK…

Hello all, I have a a button bar that sort and unsort my material. What I would like is, I want the icons to show alternately if I do sort and unsort. Please see attached file. Thank you so much. Sort.fmp12

Is it possible to script to force the launch center to open? In our legacy system, we have a "menu" file with buttons for each database that open the files remotely using the Open File script step. The obvious drawback here is when we add new databases, a new menu file has to be created and deployed to each user. I would like to do away with this in favor of the native launch center when we upgrade to FileMaker 14, however IT is insisting that I still need a "menu" file, because that's how they've scripted the install of the software upgrade, and they don't want to rewrite their script. So I'm trying to find if I can write a script to run "OnFirstWindowOpen…

Hi, I'm not sure where to start on my script, but the plan is: I have 3 fields, Field A, Field B and Field C Each displays calculated data (in this instance dates) and each field is a button. I'm trying to get it so that when the user clicks one of the fields, it sets another field (or variable, but I don't have much experience with those) to that field's value. I could create 3 scripts, one for each field. I could also create a script that selects the contents of the selected field and copy and pastes it into another field. But both these methods seem a little cumbersome. Does anyone have any ideas how i can do this in a single script suitable fo…

Folks I'm having a bit of headache with a search script. I want to search a date range from today to 90 days in the future. Currently I've made a script with a step saying: Insert Calculated Result [Select; "date field"; ( Get (CurrentDate) & "..." (Get (CurrentDate) + 90)] Being in the UK, I'm working with a file that was created on a US computer - the month and day are the wrong way round. I've changed the text on the system to use system settings but that still doesn't solve it! Frankly, that's quite ridiculous! Surely a bug like this that has been around for a VERY long time must have been ironed out of the software code? From what I underst…

Is there a GET function or other method to retrieve whether another script is running or which scripts are running from inside a script? I have a script that will call a sub script, but I also use the sub script as a stand-alone in some cases, so I'd like to be able to check from within that script whether it was called by another script, so that I know how to handle things when the sub script ends (either go back to the main script with the Exit Script step or go back to original layout and Halt Script.) I figure I can use a variable to do this, but I'm wondering if I'm overlooking a cleaner way.

I'm trying to figure out the best way to create an images slideshow in FM15. I have a layout with a portal of images I'd like to loop through and copy each image to a global container which displays in another open window. I'd like to give the user a "stop" button to abort the slideshow. I can put a stop button on layout that unhides when the slideshow begins and tie that to a script that simply halts all running scripts. But, that doesn't prevent the user from tinkering with other aspects of the DB while the slideshow script is running which would really hork things up if the user shifts focus, closes the window, etc. I thought of throwing up a dialog window wit…

Hello, I have created a report in list view that uses a sub summary report and is sorted on a key field. I would then like this report to be sorted by two additional field (first one, then the other) in the body of each sub-summary report. I am new to filemaker and I cannot find anywhere a sort dialogue that will allow me to setup a default sort by multiple fields (such as the "Sort Portal Records" dialogue that will allow me to add multiple fields to define a sort). The solution I am in creating is targeted to non-filemaker users and they will not have access to the status bar - I need to perform the sort when the layout is first viewed. I can't believe the sta…

Hello Mavens, I would be interested in some tips and suggestions about setting up a functionality, not sure if it would be script or something else, that would quit FM after a period of inactivity, reset with activity. Muchas gracias

I need to export sales transactions from Filemaker 9 into MYOB. MYOB requires that each new sales record have a blank row between itself and the last sales record. How would I tell Filemaker to export this blank row between records into Excel?

I'm looking to place a button on a layout whereby it causes a given field to be filled with the value entered in the corresponding field from the previous record. e.g. I'm creating a new record for a client's consult notes, and the 'notes' field for the previous visit(record) need to be carried over to the current entry. This is not always the case, hence I don't want it to be copied over automatically when a new record is created. Hence a "Copy Previous" button will give me the option. Struggling with figuring out the right expression/s to use to build the appropriate script for the button. Any thoughts?

I apologize if this is in the wrong forum. I'm using a search script and it won't work with email addresses. I have found information about the @ being a wildcard, so it won't work when searching for emails. I understand why, I just don't understand how to modify what I have to make it work. Here is my script. Any help would be appreciated. Be nice, I'm learning. I've attached a screen capture here. Thanks for your anticipated help.