FileMaker Pro 17

Forgive me for my poor english language. Also, so that I'm used to the french version of the software there are somme functions that I don't know the english name in the english versions. I have several global fields in a specific layout called "Calculation" where I put all the fields containing datas that change year after year. They act as variables to manage the results of multiple runs for a season ranking of the participating runners. I need to send a personalized email to every runners at the end of the season to invite them to a celebration party. The fields of the "Calculation" layout (all customized) have their own specific format such as date mm/dd/yyyy…

Can i set a portal to show a set of records / data that is not actually related to the page it is set on? so it might be I want a list of records shown in a portal filtered to show what I want on a layout that shows data from other related tables etc....

When I try to insert a PDF I get a "Missing plug-in" error. See attached. Where do i find the plug -in? I can't find any guidance on this. Thanks

In my music database I have a Date Created text field. I have, for example, many records from the year 2013, in the format of 2-1-2013. However, when I do a search for 2013 I get the "No records match this criteria" error. Any ideas? Thank you.

Hi, I am trying to better familiarize myself with Custom Functions and am going through some very basic exercises to get an understanding of how they can be used in calculations, and also make use of global variables as parameters. Along the way I've run into what to my eyes seems a bit odd. I'm hoping a more experienced developer can help me understand why. I've created the following: Custom Function: name: TESTFUNCTION Parameters: PAR1; PAR2 TESTFUNCTION( PAR1; PAR2 ) = PAR1 + PAR2 Calculation Field: = TESTFUNCTION( $$PAR1; $$PAR2 ) *Calculation result is Number Script: (to set the variables $$PAR1 and $$PAR2) 1. Set …

Hello all, While I'm not exactly new to using FileMaker (17, in this case), I am quite wet behind the ears with a lot of its functionality, and the proper way to do things. I've put together a few solutions that seem to work, but they aren't pretty, and I'm sure they are quite inefficient. I'm not really sure how to ask this question, so I'll lead with a simplified example: Let's say I have one table that is the focal point of a relationship (Table X). In that table, I store foreign keys to smaller tables (1-5) that just provide options for the main table foreign key fields (via value lists based on the 1-5 table fields). Is it necessary to connect eac…

A google search reveals that FMP not recognizing modifier keys is at least a decade old problem. It's hard to resist making some kind of a comment but I will resist. At any rate, it seems that restarting the computer, at least on a Mac, resolves the problem, (until it pops up again). My question is this: Is it understood what is it in the restarting process that corrects the problem, and if it is, is it something that can be imitated with some kind of script, command, etc? Thanks

Hello, I was hoping to get some help with a Sales database. I have a table called "Worksheet" that the user will be working from. There is a portal that pulls up items to sell and allows the user to select different options for that item. The table that has the items as records contains multiple items of the same name, but different options. For instance, there are two items called 1" Flanged Nozzle. One of those items has a 50 PSI option and one has a 150 PSI option. Each option has a different price. In the portal on the Worksheet layout, the user can pull up the 1" Flanged Nozzle and then they need to be able to select whether they want the 50 PSI or 150…

Hello, I am wondering if there is a way to do a lookup that has to reference more than one source field to find a matching value. For instance, I need to lookup a price of an item, but the item has various options such as size, thickness, and material type. I need the price field on the related table's portal to lookup the item price based on whatever the user choses for the three options mentioned earlier. I am not sure if there is a way to do this with the Lookup function in a script or if I have to approach it differently.

Hi everyone, I'm trying to get attaching files go mails generated using FM17 to work. The idea is to attach a variable file to a mail-message generated for a specific record. The filename for the attachment is specific to the record and I've got a field that generates that filename (fileNamejpg01). I'm using the send mail option in a script (which is working) and the option to attach a file by giving a file path. That file path looks like this: file:../../../Desktop/werkmap/Beeldmateriaal/instagram/$fileNamejpg01 The variable part is "$fileNamejpg01" and I'm sure I'm doing something really dumb ... but don't find anything that solves the problem (or that…

Gents, I use self portal on my Clients layout to serve two things: 1. display all the records and 2. quick navigate among them. This portal is not displayed in Webdirect. Is it possible to make it work?

Hello, I've come upon a strange phenomenon, and wonder what could have gone wrong: In layout mode, I select gray solid coloring for a couple of fields and their labels, but in Browse mode (both list and table views), the colors fail to show in some instances. Only in form view, everything is displayed as expected. Neither restarting FM nor the PC (win10) helped. I assume that the solution is simple, but somehow I can't come up with it, therefore: Many thanks in advance for helpful comments!

Hi Group I can't seem to be able to print QR codes on a label from filemaker is this possible?

I'd like to be able to export a text file that would contain several fields from a single record, with each field on a separate line. Here's an example: John Q Public 111 West First Street New York, NY 10001 How might I do that? I know how to export csv or Excel files, but they don't satisfy my need.

Several forum contributions quoted "position" formulations containing variables for occurrences. I am at a loss why my simple script (FM 17, win10) containing a loop (stepwise increasing $i) which includes Set Variable [$colon[$i]; Value: Position ( Filme::Besetzung; ":"; 1; $i)] doesn't yield any result - unless I use numbers rather than the variable, testwise. (I wonder how to paste lines from the script here.) I assume I made an amateurish mistake and am looking forward to receiving advice of someone more experienced.

Apologies if this has been asked before but I couldn't find an answer to my problem. I am importing a list of stock items from various suppliers using a CSV file provided by the supplier. The CSV file contains various fields but my query relates to the 6 individual fields for image urls in the file: URL1, URL2, URL3, URL4, URL5 and URL6. As a key, I am using the field 'Handle'. When I import the file into FM, everything works fine. My issue comes when I try to export the file to an Output CSV file which I will be importing into a web page. I need to e…

My question is pretty basic stuff I think. I am using 360Works to Sync Salesforce as my hub database and FM as the spoke database. During the configuration of the spoke database, MirrorSync config dialog states that MS is not installed on the FMS. I ran the installer on the machine but from the documentation I assumed it didn't need to be listed as a connected plugin like the 360Works email plugin for example. I'm on FM17. Has anyone else experienced issues like this?

how to get last record/field from a portal and used or copy that data in to other layout? for more clearer view!

To try to explain the setup as succinctly as possible: Database is running on a FM17 Server (on a Windows virtual(?) machine... Our IT department handles that part). The FM database does a number of imports every morning from our primary (4D) database, using an ODBC driver, but I have not found a way to have those imports run successfully from the server, so I have them running on an instance on a secondary user account on my desktop computer. The scripts are triggered by adding a record to a table, which is checked every five minutes using an OnTimer script. I run a separate instance of FM17 on my user account so that I can use the database even if there …

I have a field called Price. I need to create another field called calculated price that will add a percentage depending on the value of the original Price field. Example: If the Price is $100.00 or more Subtract 10% from the price If the price is $10.00 or less Subtract .25% If the Price is between $10 and $50.00 Subtract .5% If the Price is between $50 and %100.00 Subtract .75% and so on and so on... So if I have a record with a Price of $1.00 the calculation will fill in the Calculated Price field with $.75

Hi, I am using the Base Elements plugin Execute SQL command to select SQL on a table in another FileMaker file. For a file with many fields and quite a lot data in some fields, this times as about 1 minute just for SQL SELECT command for 1,000 rows. I haven't used MBS (monkeybread software) plugin yet, but I wonder if anyone knows if it is significantly faster? I.e. BE_FileMakerSQL vs. MBS(FM.SQL.Execute..) - is one significantly faster? Here's the code to select 1,000 rows for reference, $timer_seconds comes as about 60 seconds here. If I export same table internally in FileMaker using the menu export to Excel, it takes 29 minutes for all 41,000 rows, so timing…

In my file I have two related tables and 5 unrelated tables. I have 5 layouts. In the header I use: <<$$Title>>: <<$$LayoutName>> to display the script results. The scripts are 1. Set Variable [$$Title; Value: Get(FileName)] And 2. Set Variable [$$LayoutName; Value: Get(LayoutName)] Both scripts are combined into a single script that is triggered when "Entering" the layout. The problem: Some layouts return the Layout Name incorrectly. eg. Layout = Futures Studies returns Futures and Layout = Contract Information returns Contract. Thoughts?

I have a layout calculation that looks like: Round(If($$NoGPABump = 1;Classes::GPANoBump; Classes::GPABumped);2) In most instances, this rounds the appropriate value to 2 decimals and displays those two digits. But on occasion, it displays only one decimal as in this one: . Instead I want to see 4.20. If I round to, say, 4 decimals, it works properly: . Rounding to 3 digits gives 4.199. How do I get the trailing zero to show up? This seems to be consistent for all data that rounds to a last digit of zero. Is this a bug? Is there a workaround? Thanks,

I have been working as the developer/designer for our FMPro databases for many years now for a real estate company/rental agency, and this is the first time I have seen this happen. There is a record (a rental home) that is able to be "found," but once found, does not display any data. None. The fields are blank. You cannot tab into individual fields, but perform a find for their data, and the blank record mysteriously displays. When I try to delete it, it doesn't delete, yet the record count for the actual existing records is accurate. Display all records in list form, and no blank record displays. Go to a related table of homeowners, and the owner of this property appea…

Hi, We have a text field in our database that usually has punctuation characters "," ":" "-" "." and so on. The issue is that sometimes de search in that fiels does not work as expected. To improve the search in some cases when a user try to search in that field we transform the sentence changing the punctuation characters to " ", but sometimes it is not enough, so we have tried to do the same changing the puntuaction character to *, but the result is not good. For example if the field contain AGENTE X-17, OPERACION OCEANO and we search AGENTE X*17* OPERACION OCEANO we find nothing. Any idea why it is not working properly? Thanks.

I have a layout with a number of button bars, all with the same style. Each button is set to have an inner shadow and a white fill on Hover. For any of the buttons that call a popover, after the popover is closed, the hover shadow no longer works, but the fill still changes to white. I've tried adding a refresh object script trigger when closing the popover, but that doesn't work. Some of the buttons are currently placeholders, which just call a script that exits itself so I can test the hover state. Those work fine.

Is this at all possible? I want to have two buttons that will each do the following. Have one button to ‘Strike Thru’ text that is highlighted before. Means not all the text in the field will be changed. And one button to change the text colour to Red, again highlighted before. Means not all the text in the field will be changed. Any tips how to do this? Please bare in mind I am a FMP beginner. Thanks.

I want to print a Legder, but I want to print just the last record or last row of my ledger. is there a way to print like a bank pass book?

Hi Everyone I am a new filemaker programmer (that's a stretch!). I just learned how to link three tables (Assignments/Rubrics/Levels). I created a drop down menu from a portal (based on levels). It shows two things (level and descriptor) in the portal. Yeah I am trying to get to print the level and the descriptor on a report. What level did a student get? What did the level descriptor say? Like a mini report card. I am able to get the Level to display correctly based on the drop down menu on the report. I cannot ( and I have tried many things) get the descriptor to show. It is only a text box inside a portal. When I do get the descriptor showing it is onl…

For about 12 years, we've had a FileMaker database import external data from a .mdb (Access) database that has data that is downloaded from some equipment. The process has survived several computer upgrades (Windows XP and Windows 7) and FileMaker version upgrades (created in 7 and currently running in 16). It broke when we moved into the Windows 10 environment. The script is set up to retrieve the data from the .mdb file and it says it can't access the file. So when I dive into the script and try to specify the ODBC connection it now asks for a username and password. We've never had a user name or password tied to either the .mdb file, the ODBC connection, or the F…

Hello Guys I have over 20 client that require FM17 client to be installed on windows computer. I was wondering if there is a way i can remotely install FM17 on the clients machine .

Say I have a 2 page letter pdf in a container. I want to make a 1 page pdf that is 11X17 of this PDF. Do I need a plugin to do this? If so what? Or can I achieve this natively in FM?

Hello Guys I am pretty new to FileMaker and I have inherited the administration of a FileMaker DB that was written by someone else. Users of the FileMaker DB complained that they no longer have the ability to create a folder/Subfolders to a network file share by click the button. After investigating i realized that my predecessors used the productive computing File-Manipulator plugin to create folders/Subfolders Could someone assist me to re-write this script using the Send Event function. If you have any questions please feel free to ask

I need to replicate similar to this. Basically my database will compose of parts portal / stock / and result. I only use length since i only cut steel bars.

Hello Guys I am new to FileMaker 17 Server recently updated. Took really a long time to update to version 17 because of organizational BS. I understand stand with new Admin console GUI doesn't' allow for the progressive backup intervals to be changed. After several FileMaker support searches I found an article that states it has to be done via the command line interface. Does anyone know how to change the progressive Backup with the command line. Please show an example for window platform

Dear All, I am trying to put a conditional formatting validation which turns Red when the value is entered wrong. Basically all my tries have failed so I would like your help here. The criteria of entering a value is xxxx-xxxx-xxxx-xxxx 1111-2222-3333-4444 1. Length of value is = 19 OR this should be a 16 digit number, in groups of 4 separated with dashes 2. Non-Digits characters are not valid. Please could you help me with this and I will really appreciate. Many thanks Regards Lutfi

I am using Filemaker Pro 17. I have created a container field with 'interactive content (PDF, MP3, etc.)' checked in the Data tab in the Inspector. PDF's won't upload. I've uninstalled and reinstalled Adobe Reader DC. I've tried other PDF files and they just won't load. What am I doing wrong? (I've done is successfully in the past with Filemaker 15 with the exact same PDF files). I'm using a MacBook Pro with MacOS Mojave Version 10.14.2 (18C54).

I have filemaker server on virtual server, I have a script that exports emails and or names i cannot get the file to be saved to the local desktop it tries to save to server with an error when i do manually it works fine so i am doing something wrong... Thanks in advance

I have been using FM17Adv for some time. I am on a MacPro 12-core tower and I had been running macOS Sierra. All the internal scripts I had in one database worked perfectly. I recently updated to High Sierra and now I am getting script errors I don't understand. And this is from the same exact file I used previously. I have one script where I want it to open a folder in Dropbox so I can access files there. But I am getting this error: Can’t make "Dropbox" into type integer. Then I get a -1700 error dialog immediately after that. Can anyone explain how I can fix this. I have not been able to find anything online. The script is a native AppleScript, and I…

Hi Guys, I new in FM, and i trying to create a application that i need 2 tables with same records to make a look up search. However i not getting duplicate my table, once i duplicate it my table is Pasted only with fields but without records. How can i duplicate mu table with records? I Tried export and import also, without success. There are any script, or method to duplicate table records? Thank you guys.

I'm trying to use a script to Insert File from a specific AFP share into a container field. Every time I try, I get a 100 error (File is missing) from Filemaker. If i change the path to a local file, it works fine. I've tried hard-coding the path; using a variable; using a global field as a reference. I've also tried all the permutations of the path according to filemaker's requirements... filemac:/<path to file>, file:/<path to file>, using /Volumes, /ip address of the share, etc. For example: "filemac:/Volumes/Folder one/Folder two/filename.pdf", etc. No matter what I try, I get the 100 error.

Hi Guys, There are any logic or resource that i can use to make like a "text to columns". Make text from field one flow to another fields but only with in the middle of coma regarding your sequence, like a excel? Full text with Comas Text1 Separated Text2 Separated Text3 Separated How,Are,You? How Are You? Could please help me, i need a lot of this resource.

I don't really know what I'm missing here. I have two windows next to each other. I want to activate a Script Trigger on Record Load (I have tried On Layout Enter as well) , and it does that fine as long as I'm only having one window open. But not when I'm switching between the windows. Ie, I want the script to run when I enter the Window. Isn't this supposed to work?

With the plugin from BaseElements I'm trying to append two pfd files which are located in container fields and put the result in a third container field. There goes something wrong. I think the reason for the problem is the pdf document in field container 2. Can someone see what the problem is ? I made a test solution where you can see the problem import url V4.fmp12

Hi, I have a page layout containing 5 images stored in container fields with "Crop to frame" If I send this page as PDF the photos appear blurry. If I insert the same pictures directly in the layout, as objects, they look perfectly sharp. Any idea why? Thanks

Hello, I have a long text fields that's been calculating a lot of things and put them in one large text field to be exported. I want to calculate the lines of the text field with ValueCount function but I want the result to be in the same field as the one it's calculating. I tried to create a different field, which I got the number of lines, but when I try to insert that field in this long field, it shows a "?" and doesn't show up anything else in the field. Does anyone know how to calculate the number of lines in a long text field and put the resulting number in the same field it's calculating? Hope this is clear. Thanks anyone for assisting in advance!

Excel and Filemaker calculates the difference between two dates differently. I always thought that when you subtract two date from one another, the result was the number of full days between the dates. For example: Calculate the difference between 1/15/19 – 1/9/19. There are 5 full days between these dates (10th, 11th, 12th, 13th, and 14th). However, FM and Excel calculations do not result in 5, and they don’t even agree with each other! In Excel, Difference = 7 In FM, Difference = 6 It seems that when you subtract two dates in Excel the result includes the starting and ending dates and therefore it is not the number full days between…

Hello French user of FM14 I'm looking for a sample of getting infos for a book through Google books API in a FM database (tile, author...cover picture...) Thanks for your help Noël

Hi everybody, looks like I do have a sort of rookie problem here. I created a subsummary report which is sorted by a break field and all works fine. All is fine in layout and preview mode. Just in browse mode I seem to have a problem. There is a large grey empty area just underneath of the subsummary part showing. Anyone with an idea what it is I messed up here? I already googled but just found 1 similar report from 2010. Sort of optically annoying. Any help is highly appreciated.

Hi everyone I am working with filemaker on and off for the last recent years but, no doubts about it, I am still a rookie. lately I have created a db similar to a booking engine for shore excursions for river cruise ships. Lots of modules, layouts, scripts etc. As I really have to work with my limited knowledge, it took a long time and is not really constructed in a way any pro would do it with a lot of workarounds and probably sort of unorthodox. However, it works just fine for me and I am sort of proud, to have gotten to the point where I am. However, I am afraid, that I corrupted the whole thing somehow. No I am trying to integrate a sort of an accountin…

Hi Guys, There is any script who request user and password of user after click in a button. I have a check box in my solution with get username for log register and validation, i want to request user and pass to allow user enter this option. Thanks for all.

I need to design a sales/purchase and product database to handle the following. Purchase order: record lengths of different shaped steel with cost price,description,quantity and length being the main titles. Sales : record sale price,description,quantity and length. The lengths sold are usually less than the purchased length. Product: to show full lengths along with any that have been reduced by sale. Example: 10 lengths at 6.00 mts are purchased and 2.00 mtrs cut and sold from one length. and 5.00mtrs cut and sold from another. How do I show that I have 8 full lengths at 6.00mtrs ,1 length at 4.00mts,1 length at 1.00mtrs? Any help with how to show the…

Hi Guys, As i told in my previously topic, i new in FM. I working in a solution that i need user type a qty to populate a table. However i not getting create a input field to user type, i only able to create fields related with a existent table field? This is a FM rule, or i able to create a field to user type according your necessity? Thank you.

I have a Filemaker Pro script which writes a text file in GPX format. The resulting text file works correctly when running on Filemaker Go (on an iPad or iPhone) BUT when the script runs on MacOS under Filemaker Pro 17, the resulting GPX file won't work correctly with several applications which use GPX. The file looks identical but just won't work. The file written under iOS on an iPad works fine after being transferred to MacOS. It appear that the same script creates a different file under iOS than under MacOS. The script uses "export field contents" from a single global record. I'm guessing that "non printing" characters like CR TAB LF may be the is…

I am trying to use a Global field as a variable to generate a look up list, (rather than creating separate CV table occurrences). I have set up Global Table (Table A) with the necessary search field and created a Table Occurnace for the lookup field (Table B). All works fine. Problem is the delay caused by the script trigger, (I've tried all the before processing triggers) which all seem to run after I have selected the dropdown object. i.e. the list displayed doesn't update until after I've selected, or clicked away etc... It occurred me that really I'm asking the dropdown to act like a button, so I've tried to set it up as a button to run the script immediatel…

Hi, hope someone can help. I am a relative novice to Filemaker, so any assistance would be gratefully received. I am trying to develop a simple database where you have a startup screen which would prompt the user to enter a unique 5 digit number. Either by pressing return or by a scripted button, the user would be taken to a different layout with a record that corresponds with the unique 5 digit number. Just don't seem to be getting past this first hurdle. Again, many thanks for any response. Alistair

This is a problem I frequently have. I can't custom format a date in the Inspector. I can't make a selection because the drop down menu becomes a long vertical blue stripe and selections are not available. I wonder if this is a FMP problem or a Windows 10 problem. Does any one else have the same problem?

Hi, I hope you having a wonderful day, Currently I'm traying to create a dashboard with Filemaker, the idea is show several portals and grafics of differnets databases but with specific criterias. The case that i'm trying to resolve is the next one: There are three database related, one is for clients, another is the contract of this clients (services) and the last one is client's tickets, so we have the next relationships: tickets DB ------ Clients ------ Services (I didn't create that DB distribution). The idea is show in the dashboard which tickets were created for clients who have certain services. The first thing i did was create a self join rel…

I used to be able to host a limited number of clients with FMP. With FM17 it now says "The host's capacity was exceeded, try again later." and the file shows 0 clients connected. Is the only way around this to get FMP server?

Good morning. I have a solution that generates a PDF from a series of tables, appending various pages to the report. Sending it via email is fine, even saving it to a fixed file location, but I am experiencing difficulty in being able to save it in a container field so the user should be able to click on it and view this PDF on the screen. How do I save this please? I don't get an error in the solution (or script debugger), it just doesn't appear in the field. Any suggestions please? Many thanks in advance too. Greg

I have this little app that uses google sheets as its base for the data. When the app starts, it runs a script that downloads via insert from url a google sheet and stores it in a container field. it parses it all out into fields etc. As you can see in the pic, the bottom line in yellow shows the current dance. done by comparing current time against another table via join. This value is derived by a InsertOnTimer script that runs every 15 seconds and flushes the join to keep current dance value at the top. My problem is, when there is a change in the spreadsheet (btw this is the clients choice of storage) I need another timer to run in the background that checks eve…

Hello Friends, As such any script which can close the popover portal when a certain field have value ''No'' and if ''Yes'' it remains open. Popover portal is also open by script. Applying the following script steps but not succed Thanks

Hi, Is there anybody here familiar with the OFBiz solution from Apache ? I have a customer who wants to migrate thier data from FileMaker into OFBiz and I am wondering if there is anybody familiar with exporting of FileMaker's data into OFBiz solution. After we import the historical data, I want to build additional scripts in FileMaker so when a new record is created, I export / import this new record directly into OFBiz. Just trying to get some insight how a script like this would be designed / developed. Thank you.

How can I count the amount of lines in a text field? And is there a way to get a live update of the line count while typing in the field without it slowing down or interrupting the typing?

How does one create a dashboard of different templates/layouts. for example, I am using the contact template and now would like to add Asset template. so rather than adding a new layout can we not import another template layout. New user, I am afraid hence the question so please be kind. thank you

Can anyone describe how to set up a layout for center fed #10 envelopes?😠 FM help says that after creating the layout you must verify margins and other settings before printing. How do you do that? I've tried everything I can think of, but the script print step prints 2 or 3 envelopes when the print dialog is set to 1 copy. I've tried adjusting the header and body dimensions (by guessing), I've tried deleting the header and keeping the body, I've even tried just keeping the header. Everything looks normal in Preview.

I have a flat file database with only one table. However, I cannot not delete records. I get the error "This operation cannot be performed because one or more required related tables are missing". However, I can create records, just can't delete them. Obviously, I don't have a related table.

I have a couple of questions before I take the plunge back into Filemaker after a long absence. When purchasing the annual contract can someone explain what a user is? Is it the number of people that can use filemaker at one time or does everyone that will want to get online need a separate licence? For instance would I need one licence when I access from at home and one from work. I might have many people sharing machines etc. Also there is a limit of "2 GB outbound data transfer per user, per month — tracked annually." What is this telling me? My databases will tend to be quite large as we use thousands of hi-res photographs.

I want to build a filmmaker solution where multiple employees/users could be able to send text messages via SMS from their file maker database – does anyone know an efficient way to do this? Or what plugins or SMS services are available?

Hi, My solution opens an Excel file and loops through 3 tabs in it, importing and processing the contents of each. What I really need to do is get the user to specify an Excel file (preferably by opening a script generated default directory and filtering to only Excel files...something I can't seem to get to happen) then, in a loop, import data from 3 separate tabs in the file (tab names are fixed but import mapping is different for the different tabs) and process that data. When I'm running locally I can get the input file name by using Insert File into a container to hold on to the file name and can set up the imports specifying the filename, tab, and import …

I want "Continuity Header Calc" to take "Group_Header" if it exists. If it does not, take Scenes:Scene Header I tried making the calculation with this: If ( IsEmpty ( Group_Header ) ; Scenes::Scene Header {; Group_Header} ) But it gives me the error: "The specified field cannot be found" I think I'm missing something... Thanks in advance!

Hi, i am trying to find a position of new window so that new window opens on each record's line. is there a formular that can give pixel position of an object ?

Hi, i am having a problem when i try to set a transparent color for the portal. previous version - fmp 11 , i never had this problem. is it disabled in fmp 17 ?

I'm experiencing an issue regarding on my database. Every hour 1 I see perform find popping even I just scrolling through records. I already check if there's an On timer script but nothing. This issue happens every day.

Hi. I had a really weird problem last night that was pervasive through all files I was working on, served, local, and even a new file I created to try to test the issue. It was totally crippling and driving me crazy. I had gone into a script and selected the Go to Layout command, but when I tried to select a layout, none appeared, even though there were plenty of layouts in the table. I dismissed it as a temporary glitch and tried a Set Field command, needing to set a field to a calculation, and again, found the system locked up in such a way as I had never seen before. It would not let me enter a calculation! I closed and re-opened the file. No dice. I restarted Filemake…

Is it possible to put the empty blank new record line on top of the portal view? Currently it shows up on bottom, and I'd love it to be on top if possible. Thanks in advance!

These two filters work on their own: Edit Notes::Edit Phase Short Name = "EC" Edit Notes::Completed = 0 But when I try to combine them, I tried using "and" operator.,., maybe this isn't how you use the operators in the filter window, but I tried: Edit Notes::Edit Phase Short Name = "EC" and Edit Notes::Completed = 0 But then nothing showed up. there are most definitely records where those two things are true. I'm used to && from programming, so maybe I'm just not using it correctly in the filter window. SOLVED, nevermind... The fields were blank, not 0... My "most definitely…

Using this for tv/feature film tracking. I have a bunch of scene card images I want to relate to scenes. I have an images database with just thje image itself and the filename (auto filled on import of folder) I have an images table because i want to us it for multiple things, such as SCENE CARDS, and also THUMBNAILS for each shot in the database. Scenes related from Scene numnber. Ex: 19.jpg (this would be scene 19. Scene "19" is stored in database matching that name) Shots relate from TAPE_NAME column in database. Ex: A003C003.jpg (would be TAPE_NAME A003C003) I'd like to see if there's an easy way to relate without having to du…

I'm looking for advice regarding strategies for storing photos/scans within my database. Currently, I'm of the mindset that I would prefer to have a single 'container table' that is used throughout the database where needed. This table would have a few identifiers, which autofill based on where (as in from which layout, or where on the layout) the container is populated. Then, there would be a single layout where all photos/scans could be browsed/filtered/etc based upon those identifiers. First question, is this design good practice or should I reconsider my approach? Please note that for my purposes a container is not always necessary for every record (i.e. some re…

Hello all. I am new to FM and have not worked with database in years when I used Access. I was wondering if anyone has a sports trading card database template? I have over 500,000 trading cards and I am trying to come up with a way to track what I have. Thanks for any help someone can give me.

I am working on an inherited system. It was originally just a single file. I split it into the separation model by duplicating the interface file to create a data file and then repointing all the interface file TOs to the tables in the data file. The External Data Source is called DATA. It contains the path $$PATH.DATA Within File Options, the interface file is set to open on a temporary layout built from a table occurrence that has no relationships and no records From here I then set a value into $$PATH.DATA before heading to a layout that references data from this file. https://community.filemaker.com/docs/DOC-8174 This is the default metho…

Hi, people! I'm pretty new here and in filemaker. I'm actually only helping my research group creating a database and have just started learning about filemaker. So what I need is a portal in a participant that will display the studies that exist and whether or not they are eligible. The problem is, I need a second page to update the studies, so once I insert a new study it should show in a new row for all participants. I did others portals that worked ok, but I'm having the problem in updating the study displayed in all participants. Does anyone knows how to deal with this?

Hi all, I have 2 repeating fields, Turnover last year & turnover this year, each with 12 repetitions. I would like to compare the year to date turnover with same period last year. EG If the current year has 3 months of turnover, the 3 first months have to be compared with the 3 first months of last year, and so on. So using the COUNT function, I can determine that 3 months of this year have Turnover. How can I dynamically make the sum of only the first 3 months of last year although all 12 repetitions cells have a value? I was thinking of using the let function to avoid a lenghty calculation, but I don't grasp how to make the recursion...…

I can't get find a range of dates with a script. The following script is supposed to find the last 12 records on the layout. The Perform Find results in the error that the provided find criteria is not correct. Even if I use Enter Find Mode and insert the variables, I get the same error. What gives? Layout [ “Log” ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Log::Date; ascending ] [ Restore; No dialog ] Go to Record/Request/Page [ Last ] Set Variable [ $End; Value:Log::Date ] Set Variable [ $start; Value:$end-12 ] Perform Find [ Specified Find Requests: Find Records; Crite…

Hi. I have a database that lists grant applications. I need for my user to be able to view the records in a number of ways according to certain criteria for analysis purposes. These records are displayed in a List layout. I need to be able to: 1) see only records where the submission dates are between x and y then 2) filter these records according to what is selected in 2 dropdowns - Outcome and Status. The Outcome field dropdown value list is : <blank>, granted, unsuccessful, unknown. The Status field is dropdown value list is: <blank>,submitted, in progress, finalised. The <blank> is where that dropdown criteria are not requi…

Hello Everyone, I have an issue I'm trying to solve in a function. I have a join table that has 5 country ID's from a foreign table (UK, France, Germany, Spain & Italy), I want to look at the one that is France and read the value of certain fields in the record associated to France. How do I get Filemaker to cycle thru the country field until is finds France ID, then read the field value I request? So for clarity there is a join table that has 5 country ID's. And the thing is in that table that country can be there more than once, but only once in there for a certain product with a unique price for the product in that country. Example Join T…

Sorry if this is evident as I am a new to FMP, but I haven't been able to find a 'how to' for this So I have some large data tables that I have uploaded from Excel to FM with Primary Key (pk) and Foreign Key (fk) fields. All the primes have UUID data. and I create the relationships. Now in order for it to work I have to copy the pk data in the parent table into the related fk fields in the child tables. It works, but is there an easier way to do this? The only way I can see is to do it manually which will take ages. There must be a better way that I am missing. Sam

Does anyone know about a plug-in for Sales Force?

I want to be able to import data from an Excel worksheet into a FM runtime solution. How do I open a runtime solution to set it up? How do I use the binder key? The runtime has a script to import, but from from the desktop. But apparently I have to place the Excel file in the solution folder?.

Hi everyone, Is there anyone that can help me fix this problem? I created a 3-page report template that I want to use to print all the records in my database. Each record should begin on page 1 of the template, so that in printing record A will be pages 1 to 3, record B pages 4 to 6 and so on. However, when I print, at the bottom of page 3 I can see the beginning of the following record, which should be instead at the top of page 4. I hope you'll be able to help a beginner like me out! Silvia

When I insert a Word file into FM17 Pro, all I see is an icon of the file. How do I display the file?

Hello All, The attached file is the simulation of my excel worksheets. I have three (3) accounts Admin, John & Lola all the three (3) accounts has no password. In my layout "ReportsEquipmentTime", I want that If I click the "project x equipment" button I will see only the record of the current account that is login. The script that Im using is Set Error Capture [on] Allow User abort [off] Set variable[$_columns; Value: ValueListItems ( Get(FileName) ; "Equipment" )] Set variable[$_rows; Value: ValueListItems ( Get(FileName) ; "ProjectCode" )] Set Field[Users::RELOGIN; Get(AccountName) Enter Find…

Hi there - I need to create a simple crosstab report and wondered if filemaker 17 has this functionality built in ? If not can somebody point me in the right direction on this please. It would be very much appreciated. Also once ive created a series of reports how can i combine them so they appear at the press of a button in a single document ? Any help would be much appreciated. Peter

I have a runtime solution that was created in FMP 12. This no longer works on High Sierra or Mojave. My iMac just gave up the ghost , but Mojave would not have run on that machine anyway. So Instead of sinking money into a new Mac, I am looking to see if there is anyone here on the forum that I could hire to render the runtime for Mojave (from the previous fmp12 file), do a simple runthrough to verify that everything works well and then create an installer package/DMG to get me (and my customers) back up and running. Thanks for your time and consideration!on in this matter

FileMaker 17 is launched with the purpose of letting the users do more without spending much time. The new version also works towards its goal of letting the users do more with the FileMaker platform while they are on the go. To know some of it's most popular features read this article. https://www.metasyssoftware.com/blogs/filemaker/5-popular-features-introduced-filemaker-17

Band Solution Design I am trying to create a filemaker solution for my band. I have been unable to find a pre-made solution that does everything I want, so I am going to try and create my own using filemaker. I am looking for advice on what tables and structure I should use, before I start. Entities Band Members - I need contact info and a history of money I have paid them from any gigs Clients - People that hire us for gigs. I need to send them a press kit in hopes of getting hired. Invoice them, and send a receipt. Fans - Marketing to these people , email, text, social media, etc. Can a fan also be a…

Hello -- I would like to open pdf files that are stored in a secure external manner. Only the first page of multipage files show in a FM container window (if I';m not mistaken) so I am wondering about using Preview (Mac, of course). I can retrieve the file path to the secure file by processing the text output of the container file, and then use it as a variable filename in a Send Event script step, but Preview cannot open it. Any suggestions?

I know. Don't use them. But There is a simple task and a repeating field would be a quick solution. Field 1: a number Field 2: a calculated repeating field, each repetition adds the repetition number to the value of Field 1. Can it be done? Thanks

Hi, I am looking to move some functionality away from BaseElements (4.0.3) and into Filemaker Pro's native functions. There are three functions that are used that I need to migrate. Could somebody please help me 'translate' the following line away from using BaseElements (BE) and into Filemaker's own functions? 1. BE_HMAC_Deprecated ( $queryString ; $$_API_Key ; BE_MessageDigestAlgorithm_SHA256_Deprecated ; BE_Encoding_Base64_Deprecated ) As I understand it, the new function would be: CryptAuthCode( data; algorithm; key) yet the BE function has four parameters, and Filemaker has only three, and I'm not sure how to "translate" the third and fourth …

if we want to develop a solution that runs locally on the machine and we want to sell them we should give them the solution and client must have FileMaker full version which the client has to buy. But many clients aren't having FileMaker installed on the machine, is there any solution for this problem to run solution full-fledged ???? apart from making runtime which has restricted functions hope u got my point