Search the Community

Showing results for tags 'scripts'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Categories

  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 16 Discussions
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Server 15
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 52 results

  1. I have two tables, A & B, with similar fields. I want to write a script that will search table B for records that match the fields that are entered in table A. I am not sure how to do this. Any suggestions?
  2. Hi. I'm using FMPro 12 Advanced. Creating a database for our community centre and I need to add a membership number to contacts - but not all of them. I've created a separate table for Membership numbers (as not all contacts will have one, so serial numbers aren't appropriate). Each membership has a number of details fields. It's probably a REALLY logical and stupid problem I'm batting against - but I need to: Select a contact>go to their details>add a membership number (go to a floating window layout, enter the details to the serial-number-derived membership) and have the details including the number show up in a tab on the contact's details layout. I've created a relationship between my contacts file and my membership file via the Contact_ID>Contact_ID_fk and have played around with other relationships. I've also created a simple script from a button on the Contacts membership tab to go to the Membership Layout window and create a new record. But it keeps creating a new record in the Contacts, not Membership - even though the relationship only has to create new records in the memberships side. I'm now running around in circles - please can anyone help me out here?????
  3. Hello, I have a weird issue that just started happening when I use the 'Print to PDF' script step in a loop. I have a script that passes through and prints out a set of pages. When I use the script Debugger and when I reach the spot I am having issues with, I can see, during the preview, that it is in the correct record; showing the correct page, but once it is done and saved as a PDF, it is showing the first record that was browsed. I have attached a snapshot of the script I am using. If you notice, I have it go to the layout First, Performs a Find based on a Variable - It finds the proper records. Then it goes to the first record, (for this example, lets say record # 36) Starts a loop and saves the record being browsed to a PDF. Then it moves on to the next record in the found set. The Custom Dialog which SHOULD show the next records ID, does not. It still shows record #36. I have no clue as to why. Even though as I go through each script step and I can visually confirm it is moving to the proper record in the FileMaker client, it does NOT save the proper Record. If I switch the option on the 'Save Record as PDF' from Current Record, to records being browsed, it saves the proper records to PDFs, but it duplicates them 3 times and does not set the proper page numbers. Attached is also the end result The Observ ID: should be 36, 37, 38 but all three pages stay at 36 showing the exact same record. Thank you all for your help.
  4. I have a number of scripts that have worked perfectly for years in previous versions of FileMaker, however in FMP 15 they causse FM to crash. They only way I have found to avoid the crash is to use the debugger and to use the "step into" button. That of course is a very cumbersome workaround. You can see one of the culprits below. Anyone have any ideas what's wrong here?
  5. Hi all We have a web based tickets portal which creates new messages in our filemaker database - this is for customers' use. It does this using the PHP API (the website was developed by a third party). We would like the owners of tickets to be notified when the customer has added a message to one of the tickets that they are in charge of. Is there a way for filemaker/filemaker server to trigger a 'send email' script when a new record is created via the web portal? Or would it be simpler for this action to occur on the web side? Many thanks
  6. 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 INFO: I am using windows 10 | FM Pro 15
  7. I am running a server script periodically (every hour lets say) which does some database maintenance, uploads some files, etc. I do this on a number of Filemaker Servers (latest server version running on Windows machines) without problems…except for one server. On this server I use scriptmaster to up load some large files into containers as they are generated from scientific instruments. The problem is that the server runs seems to run out of RAM memory after a "few" days. I think this is the only thing that this server does differently than the other 4 servers and feel that this is the problem. My question is…is there a way to "flush" memory used by the plugin or by the FM server. Has anyone else experienced something similar or am I barking up the wrong tree? Thanks.
  8. Hi all, I know this should be easy but I am not getting it right. The mail gets sent but no attachment
  9. Hello, I have a tab control panel with four tabs, and I would like to achieve that when I change tabs a script is triggered and would set the value of a global field called "zzz_g_collection_type" according to the tab name which is active. I need this field to dynamically filter the products that are shown on 1_row portals that I have put into each tab panel space. I have followed Elishree Dey tip on http://burnignorance.com/filemaker-pro-tips/trigger-a-script-when-user-changes-the-tabs-in-filemaker/ but I cant make it work, it only changes the value of "collection_type" field once and only to show that the first condition is not met. I have attached the picture of my script. My initial idea was to place on each tab space a picture-field of a product as a 1 row portal and then duplicate as much as products I have so when I click on the picture a script is triggered and the product is added to the invoice. Morever, I have set an Object name to each tab Control so it would work, and also the desired value for zzz_g_collection_type comes from another related table with only one record that I use as preferences, this is on Preferences Table I have three fields called "Product_Type_Short_#" and those match on Elishree Day script tutorial. Any ideas what I could be doing wrong?
  10. Hello, It always go to "Default segment button bar", set on the button bar setting, when reenter to layout. I need to go to same segment when user was working on before he left the layout. I know how to get back to last tab panel used, and I wonder if there would be similar for this. Thanks a lot! Luis.
  11. Version 1.0.0

    26 downloads

    Being unsatisfied with solutions I found on the internet and wanting a solution without plugin I created a set of custom functions that can read a path out of a json-string. Syntax: json_path ( json-string ; path ) examples: json_path( $user_prefs ; "Privileges/Modules" ) json_path( $json_data ; "Menus/Menu[10]/MenuItem[5]/Label" )

    Free

  12. 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 AU AU AU AU IN IN IN IN .......etc
  13. Hi all not sure if this is the right area for this post however,any Help appreciated in a design that i am working on for a small point of sale i have an issue (or challenge) the normal price is set as a Retail Price (all good) however I have been asked to now fulfill this next part. A Multi-buy concept. so e.g. a bottle of wine would normally sell for $12.99 however there is a promotion where you can get 2 for $20 ea (or a breakdown of $10 ea) Now I have put a field in inventory table for multi buys i.e. fields 1. a checkbox for whether it is a multi buy item. 2. a field which indicates the qty of item that is applicable as in the above example 2 3. a field which indicates the multi buy price. 4. A field which calculates the individual price as in the example above $10. (multi buy price / qty) and just to throw a little more into it there is the possibility of a situation whereby it could be 2 OR MORE. so I have created a field which is a further checkbox which indicates whether OR MORE is applicable or just the base qty. I guess the question is how does one tie this into the POS where an item would usually under normal circumstances be scanned and price picked up from the inventory table I am just a little lost on this. I thought of a script that checks for multi buy applicable then pops the qty and price into variables which could somehow be used back at the POS screenoveriding the "usual price". Then the issue of OR MORE came into play and that is just for me draining my limited grey matter. or am i looking at this completely wrong and is there a possible better way ie use of a related table etc. Any Ideas would be appreciated. I hope this makes sense.
  14. I am new to FM, coming to it from a SQL Server/Oracle/Access background. I have created a database with layouts and while there is certainly much more for me to learn it generally is working as I desire it. However, I need to perform a task that I do not understand how it would be done in FM. The example below is not my actual problem but does exemplify my core issue and hopefully is easier to understand than if I described my project. I have a table of Users, a table of Entitlements, and a join table of UserEntitlements. I want to execute SQL that, for a given User, will read from the Entitlements table and insert rows into UserEntitlements for this user. The query will read from Entitlements, insert a row for every entitlement for this user and, based on data in Entitlements take, will mark some of the entitlements as 'active'. Ideally, every time I created a new user this SQL would be called (I'd have it as a trigger in a SQL or Oracle database, or I'd have a batch process that ran frequently looking for new users). Basically, as a new user is created I want to create their entitlements profile and activate standard entitlements. I don't need/expect a full answer - was just hoping I could get pointed in the right direction: is 'scripts' the area I need to explore? Is there a SQL capability to FM? I have not found it if there is. Thank you for any assistance you can provide, -Neil
  15. I am running FileMaker 14 on a Win 10 machine. I have a set of records that each have a field with a starting number and a field with an ending number. I have to perform a find that locates the record where the find criteria is greater than or equal to the starting number AND less than or equal to the ending number. I need to write a script that will just let the user enter the find criteria in a edit box and then go to the record. This will theoretically be only one record that would match from the dataset. Can anyone point me in the right direction with this? Thanks RDW
  16. Hello All, This may have been addressed before and I am very new to scripting in filemaker. Basically what I am trying to create is a script where I can find records from a carriage return separated list. I have created a field and a button to execute the script. For Example: If I have 50 records for every US State, in the field I could put: California Nevada Oregon Thus populating just the 3 records. Any help would be greatly appreciated.
  17. Hiya, 1st of all - I have personally refrained from posting for help on a forum as I wanted to try and read, learn and solve my problems using trial and error! I am learning the FMP platform from scratch and am currently in week 2 of it. My question relates to a file I have attached to this post - the products area. For each product I have a number of 'size options' within it and each with their own unique SKU (stock keeping unit). Each SKU needs its own barcode. My job now is to produce a method to easily assign an 'available' barcode to a specific SKU. Barcodes are purchased from GS1 and are globally unique. I have a table hosting a pool of barcodes that I have available to me. They can only be assigned to one SKU and once assigned, needs to be removed from the available selection of barcodes in this pool. Issues I wanted to set a placeholder text for 'EAN-13' field in the product layout (this is the barcode). This field is a button! When clicked it can perform a script to open a popover or window containing all barcodes that do not have a 'ProductOptionID' assigned to it. How do I structure this script? Click the EAN field button - this sets the 'ProductOptionID' variable globally (is this correct to do) - [$$productOptionID] The script then opens the object 'Barcodes'. This is a popover button with a portal inside filtering all barcodes from the pool that do NOT have a productOptionID value in the foreign key field The script must then pause whilst I manually select a barcode and set a $BarcodeID variable? Or should I script it to pick a barcode at random from the pool of available barcodes (i've already set a script to give available a figure of 1 and unavailable a figure of 0) Then the script must put the BarcodeID variable in the product option record Is the above the right way to go about it? I also need a way to un-assign a barcode from a product and therefore remove the value from the product option id field in the barcode pool I have one more query. I have a relationship between Product Option table and the Barcode Pool. This relationship is O2M the barcodeIDpk with a lookup for the actual EAN (barcode) value on the Product Option table. When I set a barcode ID in the Product Option table - shouldn't the ProductOptionIDfk field update in the Barcode pool with the ID of the product option that the barcode is assigned to?? I am convinced I had it working earlier - but not anymore and cannot see to figure out why? See my relationship graph below and the solution attached. Thanks, Luke CRM Trial barcode.fmp12
  18. Hi, Im in deep trouble I need help using scripts I am making a homework managing app for a project and i have created a few fields; date due, subject, task, and task type I need help on how to process this information and show computational thinking I need help in creating POP UPS!! I am looking for something, when clicked on, pops up a screen showing the outstanding work when the user clicks on button 1 which has a date which has past . AND I'm also trying to make a button 2 which shows entries that are close to the next few days please help as soon as possible and suggest any features i can add to the homework manager and how to write the script for the buttons
  19. I'm using 14 Advanced, and looking at the Script Workplace. The left pane has my scripts. Some are in folders, some not. How does one move an existing script into an existing folder? I tried dragging but that won't work. Must be a different way? Or perhaps they are moved someplace else in FileMaker Pro?
  20. I have a script that runs on open. It insists on selecting a non-modifiable field even when I end the script with a go to object command. How do you get a file to open in a neutral state - ie with no active field?
  21. Hello FM Pros Would appreciate some tips for the following script problem: I have a situation here where my scripts in FM 13 Pro Adv takes more than 5 hrs to complete a calculation. OS: This is Win 7 Pro. with 16 GB RAM (i5 Processor.) I have Field "A" which is a 7 digit code numbers FIELD, which most often are repeating numbers, from 200 different types. (And I have upto 80 million records, in this field.) Code examples: 1234567, 2345678, 5678012,... Fields "B" to "Y" (are global Fields) provides a reference number for each type of the 7 digit codes from Field "A". For example the code 1234567, as above, the reference is, eg. HH/2015/Jul/132, Code 2345678 the reference is, HH/2015/Sep/314,...etc Field "C" list the reference numbers from Field "B" in the order of the records from Field "A" I use the following scripts in Field "C" If [Field A="1234567"] Perform Script [Replace Field Contents Field C;Field B] Else If [Field A="2345678"] Perform Script [Replace Field Contents Field C:Field B] Else If (...until 200 lines of the references from Field) End If The script runs well. However, it takes more than 5 hrs to complete the entire 80 million records.) Would appreciate your suggestion to speed run the scripts. Many thanks in advance. Lawrencex
  22. Hi all, Apologies if this in the wrong place, but it seems like the best fit. Just wondering if anyone can help me out with a script I'm struggling with. The background: I have a button I'm using to launch a new window with another layout, then create a new, related record. This action will only happen if the user has completed a specific field in the original layout (__pkCollectionRef), step one of the script. With the new window open, the user will then make a selection from a checkbox set and close the window, which will put their selections into a field in the original layout. This part's all fine. What I want then, however, is for the button to be made inactive once they've completed their selection, so the script won't run if they press it a second time (this is to prevent the creation of redundant records - there is another button that will allow them to edit their previous selections if required). I've attached two screen grabs of the script steps. The first is the script I require help with, the second is the script run if the necessary conditions of the first are met (i.e the creation of a related record in a new window and layout). The _fkPickList field in the original layout will only be populated upon the creation of the new related record, so I had thought that adding the isValid calculation as a means of halting the script would do the trick, however what's happening is that it's preventing the script from running in the first place. As a side note, I've also added conditional formatting to the button so that when the _fkPickList field isValid the text is greyed out. This one discourages pressing the button a second time, however, not prevent it from working. Thanks in advance for the help. All comments appreciated. Franco.
  23. I've been doing merges for years using the "Merge Mail" script. It is a handy tool. To date, when I wanted to include a url, I just had the url be part of the e-mail. Currently, I'm trying to send a note with a *lot* of links, and want to hyperlink the actual text. But I can't figure out how to do it! Searching the web has proven fruitless. Any FM gurus out there who can shed some light on this?
  24. Hi All, I'm struggling with a script and count see what I'm doing wrong. The frustration is its a simple script. For some reason the script will not action the second option. If red it will run red script if blue it will run blue script, but if green it moves down to the blue if and runs the blue script. I'm so confused. The script is just a trigger to run another script all three of which are the same just with different layouts. Any advice appreciated.
  25. Greetings! Sorry if my title is vague, I am not sure exactly how to describe this problem. I have taken a look in the Forums, and haven't found this question before. (If I did, please point me there.) And of course I've looked through the documentation in FM extensively. I am a botanical garden curator, and this database focuses on two tables: accessions of plants (groups of plants received at one time, with multiple individuals), and on locations of plants (individual plants of one accession, but planted in different areas). For each individual Location (of a single Accession) I would like to assign it a unique qualifier for that accession. These qualifiers are based on letters of the alphabet, so-as not to confuse them with the numerical accession numbers. For instance, for accession 2002-0101: For the first Location record, I would like the qualifier to be "A" For the second Location record, I'd like for it to be "B" For the third, I'd like it to be "C" and after the last Z value, I'd like for it to assign them AA, AB, AC, etc. I don't imagine there will be any values higher than AZ. So I am looking for a way to come up with a script and/or assigned calculation for qualifier to do this when creating a new location record in the locations table. I've already assigned these letters to existing records in our database with a script. Roughly, the existing script runs by: Sorting the Locations table,If the accession number is a new, the qualifier is set to "A", If the accession number already exists, then based on the previous records existing qualifier value, assign the next qualifier value for the record. Capture the accession number and qualifier in a variable, for use in the next recordMove on to the next record.I know that the plant collections registrar can come up with the qualifier in their head (de-novo), but frankly they don't need that headache searching through the records and coming up with a new qualifier to create a new location. I know this is rather complicated, but let me know if I should come up with two tables to let you know what is going on. I am sure it is something simple that I am overlooking. And please let me know if I am being confusing, or have not laid out the problem in a logical way. Thanks, Tony