FileMaker Pro 18

Hi Guys, I'm back, with some final (hopefully) questions on Reporting. Assuming the Data looks like this: I can create Reports from the Item, Type, etc that's easy. What I'm struggling with is the following: 1. Making a Report which is sorted by Type, but only where the Qty is above 0. So where Bread, Cheese and Crackers would be excluded. 2. Making a Report which shows the 'top 10' owned, and 'bottom 5' owned - based on qty field. 3. Making a Report which shows me the 'best' month (a) per product and [which month did I have the most of all items] and (b) the same in year. I'd appreciate any help o…

As a beginner I’m working on a book database, comprising a table with several book specification fieldnames like e.g. title, author, editor, price, category, publication year etc. I would like to include some histograms on e.g. actual number of items per category, items per publication year. FMP help and internet don’t seem to provide distinct information. Unfortunately, many attempts later (using primitive calculation or summary scripts), still without any result… Can someone provide a solution? Thank you very much in advance!! With kind regards, Wil.

I am sorry if this question was already asked here, but I couldn't find the exact answer to it here or elsewhere yet. And I am new to the Filemaker administration so please forgive me the use of the wrong terminology. I am starting to work with a database that contains a bunch of sensitive data, so I am looking for a way to copy the database structure including tables, relationships and layout without the data content (records) in order to work on that "empty" database to include new tables, change the layout, implement new functions and scripts before applying changes to the original database. Is there a way to do that? Many thanks in advance!

I'm having trouble with FMPA 18.0.3.317 creating a runtime. Even with the simplest file, I create it and when it runs it immediately crashes with the following in the crash report: Exception Type: EXC_CRASH (Code Signature Invalid) Exception Codes: 0x0000000000000000, 0x0000000000000000 Exception Note: EXC_CORPSE_NOTIFY Termination Reason: Namespace CODESIGNING, Code 0x1 I did the exact same thing with FMPA 17.0.6.600 and it worked fine. Any suggestions as to what's going on here and how I might fix it? Thanks!

Hi Guys, So I am CLOSE to my near final question, until it comes to reports.....yay! This is possibly opening a can of worms, but I want to create a Date Calculation. The table will look something as follows: Type Buy/Sell Date Banana 7 10 April 2020 Apple 10 5 April 2020 Apple -3 9 April 2020 Bananna 4 17 April 2020 Apple 9 14 April 2020 Bananna -4 20 April 2020 …

So I compiled a runtime with FM18 running on 10.15. Client says it won't open on his machine with 10.14. My instructions were: 1. Open Terminal app 2. Type codesign --remove-signature 3. Drag the application icon into the Terminal window. This procedure made the runtime work on my machine, but it's a different OS. I really don't understand the ins and outs of this codesign stuff, but I would like to know if perhaps you know some trick that will make the runtime work. Thanks, Stefan

Hello, I am new to filemaker and using filemaker advanced pro 18. Im building a database for my patients who are admitted to the hospital. I would like help please with the following: 1) when I discharge the patient, the patient’s data are “archived” and not shown on the report. However, when the patient gets readmitted to the hospital, I would like to: 1) add patient by the hospital chart number 2) if patient is in the archive list, then activate and use the old data but under a new encounter to the hospital. whats the best way of doing this? Thank you for your help,

Hi All, So my ambitious database is coming on well, and in particular thanks to Comment in this forum! I'm on to the final chapter of impossibilities and the current one is below, which I don't really know how to start. So I have a table of information, which has what I would call an 'original' piece of data, a number. Each month, that number gets updated, on a monthly basis, at the end of each month - the idea being that you can see things in a shapshot of the present, and in the past if required. So when you add Record in the Numbers Update Table and select the Company, it replaces the 'old number' with the new number, and on it goes. There…

I recently purchased FM18, upgrading from 16. I find myself bemused by the "new" requirement to login again to a database, after a period of inactivity. Is there a way to adjust the inactive interval, make it shorter or longer? That dialog that flashes by in about 0.1 seconds when the last re-login is completed, what does it say? Thanks!

Hello Everyone, I got this file which need to be imported into FileMaker, but getting error while importing as the format is in XML. It pops up XML/XSL import specific dialog and when I choose to continue, it shows an warning saying that "XML/XSL information is not enough to proceed with import/export." Please help me to import this file or any other way to import this data into fields in FileMaker. Thank you for your reply. File.XLS

My main layout has a portal to itself that I've got a dynamic filter on so I can look for similar records and load information from them to the current record or load that record as the current record. All is good there. What I'd like to do is have a button to click on with whatever value is entered in the filter box, and have it switch the that trigger a find in another window. From there then I can use a similar set of options to load data from that other window / un-related table/portal back to the main layout/window. I'm using a separate database as a place to look up possible data from. This DB/table has a few hundred thousand records in it…

Hello, I'm very much new to filemaker pro advanced 18 and would love some help. I really have two separate questions, the first is what is a good place to go for text based tutorials on FMPA 18? The main concern I have is that I am trying to build an app for my company and basically what we really need is the ability to build an input form that anyone can use. I've done this by creating a form layout and adding the fields that I want data to be input. After that, we need a different layout or view screen that shows the data as a spreadsheet-ish entity that CANNOT be edited. You would be forced to enter data through the input layout and can view everything throug…

Hi Guys, I have two tables: - Companies (with Company Data) - Transactions (with Transaction Data) The Company ID (serial number) is liked to Transaction via a Foreign Key. So all good. I have a layout on the Companies Table, where I then have a Portal that lists transactions relating to that company only. Again, so far so good. Now, in the Transactions Table there is a number calculation/number, the Field is called Percentage Increase. What I want to do is in the Company Layout view have a field which is a Summary of the Percentage Increases. So if there are 5 records, the average would be over 5. In the Transactions Table I …

I would like to create a button next to my phone field so that when it is tapped, the number gets dialled (in FileMaker Go). anyone know how to do this? Thanks.

Looking for a filemaker alternative to https://www.receipts-app.com/en/ any sugestions? exploring options for a paperless office system using filemaker, which may prove the most cost effective. Ideally it needs to be FM server based supporting multi users suggestions and and ideas

Thanks Can someone tell me how I can get the Hebrew version of filemaker. Many thanks יצחק

Hi Guys, I may have gone about this the the wrong way, but I have a table that looks like this, with quarter data: Q1 Data Q2 Data Q1/2 Difference % Q3 Data Q2/3 Difference % Q4 Data Q3/4 Difference % 10 12 20% 15 25% 20 25% Each Record in this Table is the Year. So I have a Record for 2017, 2018, etc. This is all working perfectly on a snapshot basis. What I now want to do is add calculation field (I think?) which 'tracks' the Quarters.…

Hello everyone, I need to do the importing into filemaker, but getting an error with the filetype. Files are of .xls type. Is there any method to import this kind of files without any error ? Thank you for your reply.

Student has guitar class on Monday at 13:00. I have fields for instrument, day of week and time of day (time field). I can format the time field to show only hours and minutes, great. When I make a calculation field to show--- "Your (instrument) lesson is on (day of week) at (time of day)" --- hours, minutes AND seconds show up again in the time of day. How do I get rid of the seconds in this calculation?

Hi Guys, I have a bunch of company data based in Country: USA, UK and Europe. I have a table which has each country listed next to the company. I seem to have an issue in making a Pie Chart which simply shows a split between the records and the information I've added. I thought it was an issue of not summarising groups as records, but even with this pressed, I'm not getting what I thought would happen! Can anyone shed any light on this? Also, on the subject of Charts - if I have a perfect layout with a chart only, can I insert it into one of my 'Printer Page' layouts, without having to make a new chart etc? Thanks! N …

Pardon my brute force learning methods I'm using this from another thread here since it's pretty much what I'm trying to learn. My intention here is more to verify what I've got already in my database against the book(s) in my possession. But if there's something missing may as well grab it. (and FWIW, a lot of their data is hokey anyway, at least for books of 1980s computing, but that's for another forum/topic) I've got some general questions on Set Variable. I'm just not getting whats going on here with the script steps. Why some of these work, some don't. 1) Text leading up to the value you want 2) Text after what you want. 3) Settin…

I’m new to FMPA 18, and have been “playing” with it over the past few months after being asked by my supervisor to create a small database to keep track of our customers. Nothing too fancy, but just enough that we can search for a name/company, create a few notes and print a pdf/invoice when required etc. I’ve been creating a few test databases and have checked out hours and hours of online tutorials, but this particular issue has me confused & frustrated. I’m trying to figure out how to have many contacts (employees) associated with one company (many to one?). I created a portal in the “Contacts” layout which references only the “CompanyName” fiel…

I've got a tickbox field with values, (a,b, cr, tr, i, h, etc). Single and two character values. The data comes from an sqlite3 file that has each of those values in a seperate table/record with a key relationship to the main table. I'm wanting to set up a one way flow of occasional data into FM where I'll have those values in a CSV format. uuid,value but I want to store them in FM in a single field, as if they were value list items ticked off. I'm generating the CSV file with each value having a C/R (Cursor down), whatever the character that FM uses. The importing works like that and single values are showing: uuid,value 22424,tr 2…

I would like to create a button in my database, which would combine contents of fields into a URL, and then link to it in Apple Maps: http://maps.apple.com/?address=FIELD1,FIELD2,FIELD3,FIELD4 So for example, my database has: Address field: My Office Town: Cupertino ZIP: 90000 Country: USA So I would like my button go to Apple Maps, based on the new URL built from my record content: http://maps.apple.com/?address=myoffice,cupertino,9000,usa Is this possible? Thanks!

Good afternoon i have 2 apps and would like to merge one into the other as in import all scripts etc making it 1 App. Is this possible thank you.

Hello there guys, I have here a SQL Database. What I want to happen is, I want to transfer all the records from the SQL Database to Filemaker. So, can someone help me how to Import SQL Database to FileMaker Pro Advanced 18? Waiting for your reply. Thanks experts!

We have a table of Items. Each Item has a Category field. Each Item has a Size field. Depending on the Category, the Size may or may not be required. I am trying to use "Validate by Calculation" on the Size filed so that an alert is shown if it is empty when the Category requires that it should be completed but no alert is shown if the Category does not require it. So far I have had no success. I'd welcome any tips.

hello I have a puzzling problem that I can not get around. I am based in the UK. I have a API returning a date in the following format YYYY-MM-DD. when i set a date field with this it brings up a "?". this issue I think is that the feild is maybe no configured properly or a date sell will not accept that format. the for matt I want is DD/MM/YYYY. so I made a let function. the problem I am having is the MM is sometimes a single digit. I think I need sleep lol. any ideas. is there a simpler way of just formatting the field. hope this makes sense

I am trying to get my portal to filter by the last 2 values - it sorts by date created and thats fine but I would like to only see the last two entries in the portal - no more

We have FM tied in to our department notification systems. We are attempting to use an industrial PLC to trigger one of these notifications. We have written an in-house application to connect with the PLC in C#, now we are attempting to get that C# application to run a script on the FM server. Any thoughts? We have attempted to use the FMdotNet__DataAPI, that however, is not working because of an SSL issue, namely we are running the default certificate. Here are some code snippets for the integration of FMdotNet__DataAPI: var fmserver = new FMS18(server, testAccount, testPassword); // server is the IP address, however we can change th…

When I'm at home, it bothers me that I have to enter my password to wake the screen just to find FM ask for passwords for each open database (since I upgraded to v18). How can I defeat that? Thanks,

Hi, I am new to FileMaker - currently using Pro 18. I am currently developing a "surgical logbook" to keep track of operations performed, as well as the intricate details of each procedure (things like what equipment was used, what risk factors were present and what complications were encountered etc). For many of the fields, there needs to be multiple options and the ability to select more than one option simultaneously. It seems the only way I can do this is via a checkbox field? The trouble is that I want to take things a step further and create some automated reports that show me things like "how many operations did I perform where "X" risk factor was present?" or "ho…

I have in my small store, a sales system running on a POS with an extra display, for the customer to see what is being added to the invoice. How do I make the filemaker present on this small monitor the summary of what is being sold? how can I maker filemaker to display on the second monitor only the invoice.

Hi I need to show "incomplete" text next to my job price total on my summary report when the "Job Price" field on the customer job ticket does not have a price, Sample: in the Hide object when, I have: not isEmpty (JobPrice) but it's not working it only works for the fields that customers have no prices on the job ticket and I want it to show if any price is missing for the customer job tickets.. Sample: Sample: Sample: Hope I'm making my self clear, your help will much appreciated. Sorry, I did not know how to insert images so I'm using my google drive links for the images. Pio Soto

Hello, I am trying to download to our CRM all messages from Gmail account using the Gmail API. I have to do a first call to the API to get the first 1-100 messages IDs. With that call I get a nextPageToken that I can add to the url if I make a second call in order to get messages IDs from 101-200. So each time I make the call from Import from URL I get a $json in with the structure of: { "messages": [ users.messages Resource ], "nextPageToken": string, "resultSizeEstimate": unsigned integer } where [ users.messages Resource ] is a json array in the form of from [{"id" : "1" , "threadId":"1"} , ... , {"id" : "100" , "threadId…

I use ChronoSync to backup my hard disk form time to time. FMP 18 refuses to be backed up. It throws always an error. I have been in touch with the CS people but they do not know this either. I have uninstalled it an installed it again but that did not help. Is there anybody out there who can help?

We have an app that captures a photo using the iPad's built-in camera. Is it possible natively within FM 17 or 18 to export the photo file (as either png or jpg) to the file system of a Windows server? The reason Windows is involved is because the required printer (security card) only has Windows drivers. If FM can't do this natively, can you give me a general idea of an approach you might use to accomplish this? Thanks!

Hi everyone, I posted an issue about sharing a FMP file on my internal network a few weeks ago, and have now moved to the next level - I now need to share the same FMP file remotely. In the past I have used a Dynamic DNS service (No-IP.com) with Remote Desktop to access my home iMac, but is it possible to use this service to access my database when I'm traveling via my MacBook Pro? Thanks

Hi, I have been using Base Elements command BE_FileMakerSQL in FileMaker script to SQL select data, and return with '<c>' as field(column) delimiter, and '<r>' as the row delimiter. The below line worked before, I dumped a whole FM database with these delimiters showing in text files. But somehow, now if I run below line, it seems to have changed to ?only allow? 1 character for the delimiter, which of course doesn't make sense anyway with varied characters in the data: BE_FileMakerSQL ( $sql_select; "<c>" ; "<r>" ; $fm_file ) The string this returns now looks like for example: 352265<gwgwh<474848<<wegwgw<65755<gwgw .... …

Hi, We're a very small business of 3 people, and since 2015 have been curating our internal database on Filemaker 14 Pro Advanced. We have it set up as follows: iMac with Filemaker running, this is where the database file is saved. We have set it up with a static IP and can access if off site using the IP address of the office. It's still on an older OSX that can run 14. Macbook Pro x2 - these now both run newer Mojave/Catalina, and although they can see the filemaker database we want to open remotely (or via the onsite network), it crashes on launch. I'd say 90% of the time we work on the database from the iMac on site, but with lockdown it would…

Since I don't have enough English, I write with google translation. In the example that I present in the attachment; I have four tables, namely Homepage, Income, Expense and Cash. https://yadi.sk/d/LnkUypdQtie-8Q I entered the information for 2015 as an example to the tables. My problems are; 1- When I select a date in the homepage, Income, Expense and Cash information should come according to the date I selected. 2- When I select 2015 ... 2020 or one of the new years to be added; a- Department No, Name and Surname in Income Form b- Expense No, Expense Name should come …

hello I want to be able to sort a portal by clicking on the field names. after searching the internet I found this: https://www.youtube.com/watch?v=gCYqlgFflfI&t=33s I have implement it on a basic database and I can not get it working. I have put all fields visible in the layout so I can see the behind the scenes working. the issue is my calculation fields are showing a "?", this makes me think something is wrong. any ideas. I think I may need to put in more details to this question please let me know.

Hi All, I am gradually getting a handle on things as I try to build up my scripts in order to get more functionality on the database i am working on, and appreciate the input I have gotten from the community thus far, so thanks for that! I have multiple questions but will try to hone in on a simpler one today. Is there a way to make a field be a date but not require it to be a 4 digit year date? For the type of records I am working (archival materials), each record has two date fields, Date 1 and Date2, and people entering metadata into the database can use those fields to reflect the span of time the archival object represents. However, we can often say that for the…

Hi everyone, Absolutely new user to FMPA 18. I managed to cobble a small database together using FMPA 18 on my 2018 iMac (Catalina 10.15.3), and want to share it over a local network with my laptop. I'd like to have the laptop log in via a user account (Data Entry only). I created a user account in the "Manage Security" section, and have made sure the user account has Data Entry only privilege & "write access to all records" is enabled under the advanced tab. I also checked that "fmreauthenticate10" & "fmapp" are checked (Advanced tab). My firewall is off, and I've allowed File Sharing in the prefs of my iMac - pointing directly to the Filemaker Pro…

🤔 Hi everyone, I am relatively new to filemaker and trying to study it with my own project. I'm designing a school management program. At this point I still have problems with relating tables. For example; In my school, we have seven classes and fixed amount for fees are levied on each class. I created a table for classes: (_pkclassID, className and Fee). Class A... £100, class B.. £150 etc.. On my view in browse mode my portal on fee does not insert the relative fee value when I select the className. Any guides thanks Peter.

Hi everyone I'm looking for a little assistance if possible. I have a container field which is displaying a pdf (store reference only) and a field which shows me the file path of that container field after I insert the file. Is there a way of inserting the file path into the field and the container showing the pdf without me having to insert the file/reference?

Filemaker pro 18, / Mac 10.13 In the Webviewer, Paypal is giving me the security challenge before signing in. Selecting the proper photos works but when I click verify, nothing happens. I have found a few people with similar problem on the forums but no answer is ever given.

Good Afternoon. I was wondering if anyone could possible assist me. I wondered how to total field values if the field was a certain value. Like if I had a list of items a1 a1 b1 c1 a1 how can you only add the a value then the b value etc etc. Hope this is quite clear to understand. Thank you very much for any help or advice.

Hey all, I am relatively new to using FMP and really have just picked it up so I can add features that help me do my job to my organizations existing system. With time to work from home I've been playing around with a system to help stream line case management. The system includes a needs assessment which details current information (ie. employment status, linkage, transportation, etc). I built this for utility so my team can share and store the most up to date information on each case. Sent my completed system to the person who manages our FMP and he asked that I find a way to store previous iterations of each field so we can show progress or change over time. I hav…

I am trying to connect to a Filemaker Database via an ODBC connection. I am using a MAC and Filemaker 18 Pro. I successfully connected using my ODBC manager, but now I want to connect with NodeJS but I don't know the connection string format, please help.

Hello! I have two Date fields in my database, Date1 and Date2, that allow someone creating a new record, or searching for a record, to put a date in Date Field 1 and another, later, date in Date Field 2, so expressing a range of dates. The Date2 field can be left blank, it can be the same as Date1, it can be later than Date1, but it should never be earlier than Date1, so I want to build in a way to either stop the user from entering an earlier date in the Date2 field, or to at least warn them that they need to reenter the date correctly. I tried using Validate/Calculate and thought that might work, but it brings up a Revert Record message when the user makes a mistak…

Hi, in the attached database, we collect a range of readings per date. I need to calculate the median for each element (eg temperature, pH etc) across a range of dates. There is one record per date. The user will change the range of dates depending on what time period they want to view. The data doesn't need to be summarised by anything. I am most of the way there, thanks to this great post: https://www.briandunning.com/cf/298. I have run the script in that link on a field doing a summary list. However, the list doesn't seem to sort as specified in the script, and the median value returned is not always accurate. The lab results layout has been temporarily …

When I launch the exe for upgrading to FM 18.0.3, I get a window showing msiexec options. Installation will not start. I am running win 10 Pro, version 1909. Any help will be appreciated. Found a way around the issue... Had to drill down to the msp file in the package, clicked on that and the install ran without issue...

Hi, I'm trying to do a cURL PUT request using Insert from URL to Discord's API. I've successfully completed the PUT request using Postman, but I can't get it to work in Filemaker. I've successfully completed GET and POST requests with Filemaker, so I know my Discord authorization is working. Here's the url I'm using (with IDs removed): "https://discordapp.com/api/channels/<channel_id>/messages/<message_id>/reactions/<:name:id>/@me" Here are my curl options (with authorization removed): --request PUT --header "Authorization: <token>" --header "User-Agent: <user>" --header "Content-Type: application/json" …

In the past I used Podio to organise my daily/weekly workload. In that setup I would login (via my browser), and immediately be notified of tasks: Outstanding (tasks which had been scheduled, but not actioned, or actioned and marked as completed etc), today's calls and future tasks. Podio was integrated with a Google Calendar which made tracking very easy. I'd like to try to create something similar so I receive a pop-up message/task list, when I log in to FMPA at the start of each day. Is this something I might be able to achieve as an absolute newbie? Thanks

When I launch FM Pro 18, it will only start as a background service on my Win 10 version 1909 PC. FM 14 starts fine, 16 will not, 17 OK, 18 will not... The versions that do not run do start as background service but no interface. Hoping someone will have an answer for me. Thanks...

Have an odd situation, just wondering if anyone else has ever seen this. We have a solution that's been in use for 10+ years now - so started I think as a v7 database. Our developers are now running v18 while most clients are v16 or v17. I made an adjustment to a script last week to an Import Records script step. It's all internal, just importing a record from one table to another. In v18 the mappings all look and behave correctly. However, for any clients on < v18 the mapping of the fields was totally messed up. Not off by just one field but all over the place. Same script from the same hosted file showed two very different field mappings in that script st…

I have a Import button on my layout that will import excel file , it works well ,but the problem is when importing the file is that it also imports the blank data from the excel. It will add up to my space every time i will use this function, and it will cause problem someday. I don't want that to happen, So please help me for excluding the blank data to my filemaker application.

A small, big problem. We have a field to enter the 4-digit zipcode in the address, and we wanted to introduce only the code by entering the full address, I give some examples: When entering the zip: 78130-2037 he wrote the address in the address field "SUNGATE DR", he wrote in the city field "NEW BRAUNFELS", he wrote in the state field "TX" and finally in the country field he wrote "USA" We would only have to enter the zip and then enter the house number. Is it possible?

Anyone can suggest how to make Dropdown List with Month & Year. Like this one : Jan-19 Feb-19 and so on.

I had this old database (still working fine) that I believed was not configured properly especially the relationship parts (please check uploaded tables relationship). The database was used to record users (staff) leave days by Start to End and calculate the number of leave days taken... this exclude the weekends and holidays. The database still works fine but I want to re-do it properly this time. My confusion is why do Leave Table and Holidays Table have many to many relationship? I forgot how this happens but I designed this with a very old version of Filemaker. How can I do the relationship properly and if could explain why... would really much appreciate it. …

Hi, I have got a problem: In Scripts it was an alternative to Activate/Inactivate script steps. That option is no longer avaible in my FM 18. Also it was possible put an arrow as marker in the left side of the script. That is also away. Is it a bug after last update or is it obnly my computer who have the problems? -Per

I am planning to upgrade my stuff soon. Does FMA 18 open .fp12 files or has it changed again? If so, will it convert or do I need one or several older versions to convert to the current format? Presumably, FMA 19 is just around the corner, so I might as well wait for a little longer. Is the word out on compatibility yet? Thanks, Stefan

Hi I have a script that is triggered when an OnObjectEnter that stores the Get(ActiveFieldContents) from the field in variable as well as doing a SetField on field url2. It then fires a load card window with a webviewer where the url is set to be url2. In the data viewer and in the dialog box I get the correct field data for the portal row clicked, see the properly formed url2 but the webviewer only loads the "https://www.airbnb.com/rooms/" and is missing the ActiveFieldContents which is appened after the last / to create a proper URL. What am I missing? I need the URKL to be as listed in the data viewer image below. Instead it is rendering a url based on the first po…

Hello, Having a bit of an issue with tab objects, blinking, or flashing in Web Direct, when moving mouse over tab object. All states (active, inactive, hover, and in focus) are set to "FFFFFF", but on hover, the tab object appears to go Transparent, which creates this sort of flashing effect. Could this be CSS related? Is there something else I should be looking at to fix this? Thanks! ~ZAV

I have a simple API endpoint I have working in both Postman and PAW that uses cURL. It does not work when I use insert form URL and paste into the CURL section. I dont understand why you cant just PASTE the text from Postman or PAW into the CURL Options WITHOUT having to do some convoluted text string manipulation. Any ideas on how to do this easily without PLUGINS or TEXT MANIPULATION? Shocking that FMP18 doesnt support this natively. Here is what works in POSTMAN and PAW: ENDPOINT: https://stevesie.com/cloud/api/v1/endpoints/e7762587-1426-47ac-b5d5-d9b2836ec89b/executions CURL: curl --location --request POST 'https://stevesie.com/cloud/api/v1/endpo…

Hello! Our company has about 2,000 employees and we intend that each one has a unique access to the Filemaker platform. Does anyone know how to do this en masse, ie without creating an account one by one? Thanks for the help.

I would appreciate some help if anyone knows how to solve this. I have a database with three tables. The first is a Recipe table, with fields RecipeID, RecipeName, etc. The second is an Ingredient table, with fields of IngredientD, IngredientName, etc. The third is a RecipeIngredient table that joins the above tables together, with fields of RecipeIngredientID, RecipeID that links to the Recipe table, IngredientID that links to the Ingredient table, Amount, etc. The three tables form a typical many-to-many relationship. I have been trying to figure out how to find a recipe that contains two specific ingredients. For example, I tried the Criteria “RecipeIngr…

Hi, As a complete novice to FMP, I'm attempting my very first database. We rely on storing our contracts on Google & Dropbox. I've been trying to either embed the pdf's into a "tab", or (my preferred option) to have an "Add URL" button to link to the online pdf. I tried adding a field and copying and pasting the URL, but it's not clickable, and I'd need to add another field for each pdf/contract. Is there a better more efficient way to do this? Thanks Steve

Hello, I want to know what's the value of a fields in layout A(Table:: Site_Site) and have the same value in layout B(Table::Site_Network). whenever the value is changed in one layout it should updated it self in other layout.

I have setup a layer with web viewer. I can maneuver within the website just fine but, I would like it if when the website loads it would send 4 carriage returns to get to a specific field within the website. If anyone has any ideas on how I can accomplish this it would be greatly appreciated. Thank You John

filemaker sends mail with the program FM18. does not send mail with runtime. gives an SSL error.

Hi All, Apologies for perhaps being in the wrong part fo the forums for this query! I'm on FMP16 right now, and I've a container field that I use to display square pictures of people. Due to different layouts, the container is landscape on one, and portrait on another (ie wider on one, and taller on another). Because the only option in FMP 16 is to FIT the image, when the container is wider than tall, either the image is distorted or there are gaps on the sides, depending on whether I've got the 'maintain proportions' box checked or not. And similarly, when the container is taller, then the image is either distorted or there are gaps on the top and bottom. …

Actually, I guess this could apply to macOS Mojave as well, but is there any way to get the Send Email script to work when creating a Runtime solution in macOS Catalina? I'm using FileMaker Pro Advanced 18 to create my runtime solution. I created a button on my main menu to send an email. When I click the button in High Sierra (and all previous macOS versions) it works. But in macOS Mojave and Catalina, nothing happens. I know that Apple placed security limits on applications, but there's no way to add my runtime to the list of allowable applications to execute a script. What is supposed to happen is that macOS is supposed to have a pop up that allows you to cli…

Someone any idea why FileMaker does not know it's own error codes? This happened when a customer with FileMaker 18 is trying to perform a scripted QuickFind. I cannot reproduce it.

Good morning I was wondering if anyone had template for a basic home accounts sytem or the schema for the databases. Thanks again.

macOS Catalina. 1. Make a new file and save it to the desktop 2. While the file is open, move it to the trash 3. empty the trash The trash is emptied without any error. Weird. This does not seem right, in fact it seems VERY wrong. Can anybody reproduce?

Hi guys, I'm trying to dynamically change a text field from one that autofills using a calculation to a dropdown list depending on the value of another field. If the other field = "yes" then the original field should be autofilled, if the other field = "no" then the original field should become a drop-down list. What would be the best way to do this? Thank you for any help!

Hi guys, Im trying to autofill a field depending on the value of other fields -- Ideally this field would be autofilled with some text immediately followed by a numeric value that increases by 1 for each new record. I currently have this: If ( Case1 = "A" ; (Case(Type = "Protein" ; "test1xxx"; Type = "Antibody"; "test2xxx"; Type = "DNA"; "test3xxx"))) I would like to replace the "xxx" components with "000" through "999". I was hoping someone would have some insight on this. Any help would be appreciated. Thank you!

I have a FileMaker solution that powers an internal "TV network". It runs over Intel Compute Sticks which have FileMaker installed on them and are connected to TVs mounted to the wall throughout the facility. A FileMaker script runs through various layouts and steps thru records on each layout. This lets us show a calendar, weather report (in a web viewer), company news, birthdays, customer feedback, employee recognition, and pictures. I would like to add a news ticker to the solution, like you'd see on CNN scrolling across the bottom. I have a table with the news stories in it. Since you can't run more than once script at the same time, I have a script set on t…

I'm not sure how to explain this properly but I will try. I have 2 tables, one main customer table and a phone log table with over 700,000 records. They are related with a customer number field. on my main customer table, I currently show the last phone log entry, date and user initials with a field in the main customer table called (last phone log name) (last phone log date) (last phone log initials) using the last function. This works perfectly but it is massively slowing down when I scroll through hundreds of records on my main customer table. Is there any way to create a new field or store this information so it isn't calculated on the fly, an…

how i can stored a field when it depends from a related field from the other table, The field is the senior citizen discount field which only calculates when the customer is registered as a senior citizen. if not , it will not calculate. Table 1-Customer (senior citizens discount field) one to many relationship Table 2-Transactions(look up the senior citizen discount field and make a discount if the discount field is yes)

Hi Guys, Disclaimer: I'm not a Guru, never used a database before, let alone build one . . . but the time is right to start looking into how I can help my company's productivity improve, into the future. FMPA was recommended . . so here I am - up for a challenge! So I'm starting from absolute Zero . . and builing my first "Contacts" database from scratch, mainly to get a feel for FMPA18. Questions: Where do I start with Tutorials? Whats out there? Suggestions what to try first? I have a table and several fields, some of which are email & phone numbers, but the phone numbers aren't formatted correctly (ie: 123…

Hello, the following is the essence of a problem I need to resolve. The code is AppleScript display dialog "Hello \"world\" " This code needs to run in FMP18 as a calculated applescript. I tried: Perform AppleScript [display dialog \"Hello "world" \"] Perform AppleScript [display dialog \"Hello \""world"\" \"] Perform AppleScript [display dialog \"Hello "\"world"\" \"] Perform AppleScript [display dialog \"Hello \""world\"" \"] and other permutations of 1 backslash and 2 quotation marks cause the calculation to be unsavable b/o error. Perform AppleScript [display dialog \"Hello \"world\" \"] results in "A identifier can’t…

Hi, Can the data be fetched from the checkbox of the Editable PDF using the Productive Computing’s “PDF Manipulator DC Plug-in for FileMaker”? We are able to fetch the data from Text fields. Is it possible to fetch the data from check box or radio button? Please let me know. Thanks in advance. Regards Vinoth

Hello; can I Lock Records if creation date more than a month so user can not edit the record and can only browse it?

Hello; can I change the content of any error message that I get during edit or modify?

Hello; how can I create a Chart same as in Excel?

Hello all On FM 18.03, the closing of a popover, the button of which is in each row of a portal, causes FileMaker to close. This appears to only happen when the fields which are in that popover (the portal records) are edited. Has anyone else experienced this? Thanks

Hello; how can I link FileMaker Pro Apps with the Mobile Phone Contact Program so when any call comes if my apps has the name will show on screen?

I have started sending emails using the INSERT FROM URL method shown by soliant here: https://www.soliantconsulting.com/blog/html-email-filemaker/ Emails are being sent out but many recipients seem to be getting my emails sent to their spam folders. I'm curious if this has anything to do with this method of sending emails.

What is the best way to require a user to enter todays date or into the future within 90 days when entering a date field?

I have headers for my layouts that consist of multiple buttons and objects. Oftentimes, it is the same header for many different layouts. But if I make a change to the header in one layout, I then have to go to EACH layout with the same header and duplicate the change (or copy and paste from the first layout). Is there any way to create an object that I can add to multiple layouts, such that if I make a change to the object on any of the layouts, it will reflect that change on ALL of the layouts that contain that object?

Hi Guys, Sorry, me again with another question. I want to have a calculation which produces the results of a test, in effect there are 4 tests being conducted at once, which would be as follows: Number > Limit + Test said "Go" = Correct Number > Limit + Test said "Don't Go" = Wrong Number < Limit + Test said "Go" = Wrong Number < Limit + Test said "Don't go" = Correct Not being very good at Filemaker, I don't know how to do this - so what would be the best way? I guess this is too detailed for an IF statement? Thanks! Neil

Hi Guys, Hoping this will be a more simple question that before! So I have a set of transactions with data in a table, for example: Company 1 - Bought £100 - Date 5.3.19 Company 2 - Bought £200 - Date 12.9.19 Company 1 - Bought £100 - Date 9.7.19 I've set up a Portal on a company record, which gives me a list of transactions with that company, these display perfectly, with a date and so forth. However, I'd like to be able to get a Total Bought in relation to Company 1 only, which given the case above would be Company 1 transactions, would total a Bought of £200. Ideally, this total would sit in the Company File, rather than the …

Hi Guys, I am building a Scoring Database, which was originally in Excel. The way I build this in Excel was as follows: Metric 1 Multiplier Metric 2 Multiplier Metric 3 Multiplier Metric 4 Multiplier Metric 5 Multiplier SCORE 10 8 6 3 6 Item & Score …

Hi Guys, Sorry of this in the wrong forum! Complete newbie here! I have two questions: 1. If I have a Table with two Fields - say 2019 Results and 2018 Results - what would be the best way to show a percentage difference? Is it to have a third Field, or is there a better way? 2. Is it correct to use the "Calculation" field to find the %? Could someone please show my the syntax, as it's not working for me! Thanks! N

Good Morning, I have a database with the master table having a field called customer number. Typically a 4 digit field. Each year the customer is with us, his file is duplicated and the new file increments with a second field called renewal number. Example the first year he is a 0 in the renewal field, the second year file he is a 1, etc. This master table has 50,000+ records in it, with some customers having been with us for over 30 years. All other tables use these 2 fields to link in to the correct customer file. I'm trying to create the ability for my employees to link different customer accounts. Like if they have multiple policies with us. They would …

Hi -- I'm trying to direct a client to the web-page for purchasing Filemaker 18 - - but I'm only finding Filemaker 18 Advanced. Is Filemaker no longer offering the somewhat simpler package? If so, wouldn't it be simpler to leave off the 'Advanced' title? Thanks!

I am working with a water billing system. so I have a field for a reading of a water consumption so this is the process flow,this is also a field in a portal (date billed with due date and previous-present reading=consumption then consumption=amount due and there is a penalty field, when the consumer did'nt pay or paid after the due date then the calculation execute.) after the 1st week that i have developed the aplication the calculation and the field is working fine, but when i try to enter new bill recently ,i have noticed that it is not working properly,like its always calculating even the result is false. please help or please give other sugges…