FileMaker Pro 18

Every time we reboot one computer, an iMac M1 running Sequoia, we have to go into System Settings, Privacy & Security, Local Network, and toggle off and back on access to the Local Network. If we don't, FileMaker client cannot see our FileMaker Server. All the other computers are fine, even those running Sequoia. I'm trying to write an AppleScript to so it for us, but it's annoying. Is there any way to get the setting to stick?

I have users on FM18 advanced. Have not upgraded since they use runtimes and 18 is the last version for which runtimes are available. I use the SMTP server for sending email and the process, which has worked for years, suddenly stopped working for their outlook accounts. It used to be that the TLS, Plain Password options worked. But it appears Outlook is deprecating (or has deprecated) the Plain Password option. FM18 offers one other authentication method - Cram-MD5. it also doesn't work. Outlook claims to have transitioned to something called OAUTH2. That option is not available in FM18. Is this application dead in the water for Outlook users? Or is t…

I have parent records and related children records. If I want to put, say, all the first names of the children into the parent I can use the List function. I want to put each name into a separate field in the parent record. Is there any way to do that? Thanks. Michael

Similar to a previous post but different. My portal contains records where a musician (MusicianID) may have multiple entries based on participation on a song (SongID). My goal is for the song count (circled) to show how many songs this musician has 'touched' regardless of the role or involvement. In order words, in this example, the song "For Good" appears twice because the musician has two records for this song in the portal - one for Cover Artist and one for Comp/Lyricist. However, the song "For Good" should only get counted once in the summary field. The song count field is a summary field =Count of SongID in the related table. I'm sure this is a fairly …

Hi. I found a post on this forum for the creation of a news ticker, and it works very well - thankyou to all those that made this possible. Can anybody please suggest what changes that could be made to it that would allow it to be a continuous loop of all items, rather than resetting after the last item? I have not been quite able to find what I need 'out there' to make it behave differently. Any help would be appreciated. Greg

Hello everyone, First off please bear with me as it's been a while since I was tasked to do anything with FMP, so I'm a bit rusty... not that I have any formal training, but I used to be much better at it and I am trying get my mind back in shape! I am working on a solution that invoices customers for booth rentals at yearly trade shows. Many customers attend the same shows year after year. It consists of these linked files: Customers are in a table named "The New World!" (note the exclamation point) in a file named "The New World" Shows are in a table named "Show Names" in the file named "The New World" Invoices are in a table named "WWE Inv…

FM stop working. I started FM and it now asked me for a License Key. I have my key but it was me to go to my certificate. I purchased this FM 18 Adv on line from Amazon. It worked fine for over a year and now it wants my certificate. I have the License Key, but it doesn't give me a space to manually enter the key. Any Help?

I have just experienced the Gray Menus of Death. All of my keyboard shortcuts are grayed out ... I can't even use the standard cut, copy, paste keyboard shortcuts. I was using Big Sur, so I upgraded to Monterey ... This upgrade did not solve the issue. It was on FM 18 Advanced, so I upgraded to FM 19 ... I still have the Gray Menus of Death. I deleted the com.filemaker.client.pro12.plist (User > Library (Hidden Folder) > Preferences) thinking that would help ... That didn't help either. I deleted my only plugin ... Still no keyboard shortcuts. Others online are complaining about this issue. However, I not finding a solution that works. Any ideas?

I have a database of 185 records. The record numbers are currently in a text field 'record no', Indexed, Auto-enter Serial, Required Value and Unique. When I sort on record no, the order result is not serial but reads the first digit, so record no 3 is followed by record no 30, then 31, etc, 39 is followed by 4, etc, as it should in a text field. However, I want to sort 1 - 180, so presumably need to change the field from text to numbers. How can I do this without losing the data?

Script below produces attached rubbish output. Have tried creating new file from Excel data, but same result. Mac Mini Apple M1 running Ventura 13.4 How do I correct this please? 1. Show all records 2. Go to Record/Request/Page [First] 3. Save a Copy as [file:Reg14 File IN USE BACKUP; copy of current file; Create folders:Off] 4. Close File [Current File] Produces file output attached, not a copy of FMPro file: Reg14 File IN USE BACKUP

As of this morning the following stopped working. I updated chrome (as the error message said) but it didn't make a difference. I'm using FM18. "http://local.google.com/maps?" & "q=" & /*Address=*/ Parents::Address & "," & /*City=*/ Parents::City & "," & /*State=*/ Parents::State & "," & /*Zip Code=*/ Parents::Zip & "," & /*Country=*/ "" The above brought up a google map google_directions ( street1 ; suburb1 ; state1 ; zip1 ; country1 ; Address ; City ; State ; Zip ; country2 ) The above gave directions and distance from school to home Now they both don't work and tell me to update browser which I did. …

I am trying to help a friend, and don't have exact details at hand, but I'm hoping a description of the situation is enough to get clues which way to go. As far as I know he purchased FM Pro preinstalled on his Mac Mini. Recently there was an upgrade available. Apparently he renamed the old version app filename in order to keep in separate in case something went wrong. He now has both versions on the computer and can start them both. The old one shows it is licensed. The new version is a trial version. I am guessing if he had not renamed the app file, the upgrade would have found the license on the old version and automatically used it, ... but what do…

Hello Mavens, I have a complex database and I have to export some of it into a spreadsheet. After some experimenting I created the right export order. Now I can reuse it and export from each record individually but now I'd like to automate it in the form of a script. Is there a way to sort of "import" the current export order into a new script? If there is, I have not been able to find it. Thanks, Asu

Hi brains trust, I want to be able to create an Edit Box field where the field will "pop open" when selected, to show all it's contents (to a certain line limit), similarly to the Pop-up Menu but without a pre-entered value list. Is this possible? Thanks!

I am trying to merge two databases together. Because fields are in portal, no idea how to accomplish. Adding to Table LineItems layout is no problem. Both dBs have same fields, of which the below are relevant. (These are samples. Actual dB1 goes from year 2000 to 2021 with several thousand records and over 200 for dB2 monthly records for 2022 only -- actual dB originated as something else so some fields I didn't use but didn't want to delete to prevent breaking anything) 2001 dB sample.1 dB Table Hours detail layout> one record per month 2001 (one record per month per year = 12 records; one per month for one year) Table LineItems > one record per event per …

I've read to open my previous fmp5 files, I need to first get them to fmp7 format. I run FileMaker Pro 18 Advance currently on MacOS 10.15. I found site that says I can download Filemaker 11 <https://filemaker-pro-advanced.software.informer.com/11.0/> but will that not overwrite my current installation? And, will it even run on my OS? I only need to get the data out of the files.

I have a old database that in the past I've turned into a runtime without issue. I think the last version of FM I used to make a runtime of this DB was v16. I've been trying to use FM 18.03 to gen the runtime this time. It's working fine on the runtime build process but when I run the runtime database exe, in the startup scripts process the DB is terminating on Any "Adjust Window [To Fit]" script step. Hits an Adjust Window step and boom, terminates. I can use the full client to tweak the database in the runtime folder and comment out all of the Adjust Window steps and the runtime will load after that. And, oddly enough, I have some buttons on the main DB menu t…

Fields: ACTIVE = YES value DATE STARTED DATE ENDED gDATE_TODAY = global Get(Current_Date) YEARS OF SERVICE (calculated result) If the ACTIVE field is "yes" then I want to see current YEARS OF SERVICE from today. Else, I want to see YEARS OF SERVICE from start to end date. Tried scenario that isn't quite working: If (Active="yes"; Year (Date_Today) - Year (Date_Started); Year (Date_Ended) - Year (Date_Started))

Hey all, I need a way to differentiate a Runtime from someone using a solution using FileMaker. The Get(ApplicationVersion) is supposed to show "Runtime" if someone is using a runtime, but I've found this doesn't work. When I convert a FM18 solution to a Runtime, and definitely launch the Runtime, the Get(ApplicationVersion) still shows "ProAdvanced 18.x" (I forgot the exact version number it displayed.) I've updated to the latest version of FM Pro Advanced 18, and it still doesn't work. I can never get the Get(ApplicationVersion) to display "Runtime" I know Runtimes are deprecated, but I need a function that will go to a different layout if someone i…

My layout "Securities" is from TABLE: SECURITIES and uses FIELD: SOURCE / checkbox with 10 values. Second layout is also from TABLE: SECURITIES where I would like to have only 2 of the values showing from FIELD: SOURCE (one or both may show check/yes). Tried to show example in image below (not using the 10 values). If I create another field on the second layout, how do I call the values from FIELD: SOURCE for that layout?

I am trying to have my CURRENT (number calculation) field display results (DESIRED) based upon 4 scenarios. Using a CASE function. Two work, two do not. The CASE statement shown in example is one, I've separated to make it easier to distinguish the scenarios.

I’m using FMP on a Mac computer. I sometimes want to “Copy All Records” by holding down the Option key and clicking on the Edit button and choosing that option, but sometimes that does not work: 1) When I’m in a field, it does not work. Sometimes clicking outside of the field allows me to access that “Copy All Records” menu item, but sometimes it does not. 2) In some FMP files, I can’t get that option to appear no matter what I do, even if the file is newly opened, and I have not clicked in any fields. Is there a reliable way to access that function from my keyboard from any record? Thanks!

I've never understood why the age of a forum post, in general, anywhere on the internet, about anything at all, matters with regard to anything besides it being a record of the date the post was made. I laugh when I see posters say things like "Sorry about commenting so late on this really old thread, but..." Why the apology? It makes no sense. The only thing I can think of is that it's too much work for readers of threads to observe and make note of dates when reading posts, but then, what do the dates really matter? Everyone knows the thing got posted sometime in the past...when do the actual dates really matter? Hardly ever if you ask me. So I laughed when I saw…

I have table A that has list of pharmacies with phone numbers addresses etc , linked to table B that has patient's info, from B I want to populate the chosen pharmacy of a patient from A through the relation, the pharmacy name in B is value list driven from A through the link, it does pull the list and when I chose the proper pharmacy I am having difficulty figuring out how to populate the rest of this pharmacy info in B from linked A.

In a previous thread, "Copy/duplicate database structure without content" was answered ("Use Save Copy as (no records)"). I need to do that for a Server-hosted file, the "Save A Copy As" option is greyed out, I presume because its on the server? Is there a work-around? thanks

Hello : Will FMP 18 Advanced run with Rosetta on the M1 MacBook? Regards : Hubert Wagner

I added two container fields in my database. I put a picture in each and set it as global. Worked fine. Went to a second computer and opened the file and they're not there. Closed my file and reopened it and they're not there. I put them in originally with copy paste. Any idea what I'm missing? Thanks.

I was wondering if the following is possible and, if yes, how to do it. I have a parent/student database. I created a script where I can send an email with information from the parent record out to the parent. It works fine. I want to set off a script to choose certain records (like those that owe tuition) and send out an email to each of the ones in the found set at one time with what they owe. What I need is to know is which emails couldn't be sent and for what reason (if possible, otherwise just the email) and want the script to continue through till the end without stopping on errors. I tried it once and I got error messages but at one point it stopped sending al…

Here's a strange question. I have a parents table and a student table. I have a field in the student table that creates the student name concatenated with their grade. In the parent table I have a field that puts all the parents children and their grades in one line for a printout. I use the substitute(list(student.... function. Works fine. Is their any way to get different fonts for different students in that line? If a student is in a certain grade I need it to be in a different font within the same line. Each parent's children, some in font a and some in font b depending on the grade. I know it sounds a little crazy, but any ideas? Thanks

Is there a way to format a number into dollars and cents with dollar sign, not in the layout, but in the database or email message, where I ultimately need it? TIA

i am trying to find out how to delete the selected users account. I can delete their record but I cant figure out how to delete their account.

When I start Filemaker and go to my hosts favorites I see icons of all my favorite files. The names of some of the files are longer than the icon line and I have files named the same except for the end which says 2021 or 2022 etc. I can't see that year so they all look the same. I was looking to see if I can change it from icons to a list but don't see where. There is an option when looking at the hosts files. Is there a way to do it?

I have some graphic pictures on some of my layouts. When you click on them you can resize them. I got a new jpg file and when I want to put it on the layout it says it has to make the page larger but when it inserts it I can't amke it smaller. It's one large picture. How do I make the jpg file smaller to fit properly on a layout? Tha handles just don't come up. TIA. I put it on a separste new blank layout and was able to make it smaller. It's a shame you can tell it not to enlarge your layout and just make it smaller the first time. Anyway, I got it. Thanks.

Hello! I'm a newbie, sorry! Wondering if anyone could help with advice on how to go about generating reports based on data from multiple tables in Filemaker Pro. Or point me in the right direction if there is information online about this already. Description of the problem: let's say Table 1 is the main table which includes (1) date of bank transaction; (2) debit amount; (3) credit amount; (4) account code (text). However, sometimes one bank transaction (whether it be debit/credit) needs to be split up in order to then associate it with more than one category code. From a layout which displays the data from Table 1, have set up using a pop-up button visible in …

My FPro 18 advanced database is music contents. Table 1 is artist s. Table 2 is music (title of recording and other details) along with 2 portals. Table 3 which is track list and timing. Table 2 relationship Table 2 recNoID to Table 1 FK_recNoID. portal 1 has sideA fields; portal 2 has sideB fields. There is a gap equivalent to the number of portal 1 entries when viewing portal 2. Can't see option to upload image so hope I explained well enough.

I have records with 6 possible "run dates" and I need to come up with a calculation that finds the latest date of the 6. It is possible and likely that most of the fields will be empty. 12/12/19 1/1/20 2/15/20 The calculation should look at the 6 fields and determine which has the latest date. Thanks for any help you may offer.

Good day all, Issue - I have created the file Radio.fmp12, stored in the same networked location as my other filemaker files. (See attached 'Filemaker Files.png'). I am however unable to open this file using a script as have previous done with my other files. When I open the Hosts window, all my other programs are displayed except for Radios.fmp12. (See attached 'Hosts.png') I attempted to open the file directly via its network path and filemaker alerted me that the file could not be found (See attached 'filepath.png') Please forgive me if i am missing something but i can open the file directly from the directory so i am baffled as to why th…

FM18P: What is best practice when it comes to importing data using JSON / ION? I usually use XSLT and FMPXMLRESULT for import, is there a similar way to do these imports of records into FileMaker? FM19S consideration: I guess the simplest way is to write something in ECMA or Swift that outputs the portable array as FMPXMLRESULT? As pr example curl -kL https://api.domain.tld > /opt/local/usecaseION2FMPXMLRESULT > /opt/FileMaker\ Server/Data/Documents/usecase.$(date).fmpxmlresult.xml But then again FileMaker 19 Server does not allow for XML imports?

Hi All. I've come back to FM18 after last doing anything with it back in 2011when it was FM11 but I can't remember much about it. We have been offering a Thai food delivery service for a few weeks and it's getting bigger and busier. I have 42 Thai menu items that I want to auto populate in text boxes to create an order. I have created a value list with the 42 items and I just want to type in a menu number, eg. 23 and it will add Red curry prawns item to a bill. The price is a box alongside the menu item. It also needs to call up the price of the item and complete a box alongside the menu item. I have created 15 items in the form of a customer order which sho…

I have been running on 2 copies of the same license in my house, in the mean time I bought a 5 user VLA, how can I change the license in FileMaker 18?, when the trial expires I can simply click Browse and click on the cert file that came with the VLA.

original title: Recreating a spreadsheet layout - daily sales of line items for customer, by product, arranged by day of month ascending across portal row, viewed by month I have purchased a business (a commercial laundry) which previously used a separate spreadsheet for each customer, each month, to track sales of each item, items were in rows and columns the day of month. I am wanting to replicate this layout in FM, with the initial intent of getting having a form per customer per month which is transferred to FM for invoicing, and ultimately having the ability for staff to enter the data directly, removing the manual step and duplication of task. I understand…

First, I appreciate any help I can get as this project has been evolving over two years and, as these kinds of projects to, has become more involved and complicated over that time. I've posted related questions, but exploring other parts of my project. As I'm not a programmer, but a sort of user nerd, my inquisitive mind wants to learn, but sometimes simple concepts elude me. Feedback, both on the specific goal at hand as well as the project overall is always appreciated. Performers is one piece of a much larger project, but I'm trying to enhance the project and working on a piece at a time. BACKGROUND I'm sharing the entire project layout to provide some …

For FileMaker hosted solution does anyone use $$VARIABLE for external data source? I'm able to make $$VARIABLE="file:filename" work, however $$VARIABLE="fmnet:/host/filename" does not. In my case this would be $$FM16S00CONTACT="fm16s00.domain.tld/contact" and $$FM18S00CONTACT="fm18s00.domain.tld/contact" This now works, however it's unclear to me what triggered this working. I have a startup script that sets the variables. I have configure the External Data Source with $$FM16S00CONTACT, and this works, however adding another data source does not work for now, I tried quitting FileMaker and relaunch.

Using FMP 18 on iMac. I'm wanting to create a script to import only new records from one file to another. When I go through the import steps in my script it doesn't give me the option to add new or update, it just goes to the part for import order and wants to import all the records. If someone could tell me what I'm doing wrong here. . . .

I have a client that has been using a send email script step that brings up the outlook email client on the desktop. This as worked for years no problem. It has stopped work on 3 of 35 computers within the last two weeks. I talked with there IT personal and they have assured me that no updates have happened. The actual error is - Microsoft Office Outlook Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. I have double checked with system default and Outlook's settings. Both are set to default. The client is u…

Hi All, I would like to find solve my issue, as mentioned on the topic of how can find more than fields like serial No. or Code by IOS camera. please find below the script. thank in advance for any help or support

I'm having a problem getting BE_SMTPsend to successfully send an email with an attachment. No problem sending without an attachment, but when I add an attachment, I get an error 2 (not sure exactly what that means, but without the attachment, no error) These are the argument strings with and without attachments: I have tried both relative and direct file paths for the variable $attachment. Examples are: Both of them return an error code of 2. Since the 'send' without an attachment works, all the values of the fields/variables other than $attachment must be valid. Can anyone offer a suggestion as to what might be going on and…

Hi All, As per mentioned on topic, in fact i would like to create icon ex. hour in case rigging guard the insert time.

Hi, I'm trying to make a subsummary report with data from the current table and a related table. I never get to display the correct totals for the related table, and would therefore appreciate your help. First I'll try to explain the workflow: I have two tables called 'Voorraad_uit' (= outgoing stock) and 'Voorraad_in' (= incoming stock) which are related by delivery number. Data is first entered in 'Voorraad_in' (= incoming stock) and then related records are created in 'Voorraad_uit' when an incoming stock item is partly or completely shipped. This second table contains mainly the outgoing amount and a unique outgoing delivery ID. As a con…

Security Challenge when signing on to Paypal through Filemaker pro 18 web viewer. I see the text "Security Challenge" but nothing else shows up... all is invisible, making it impossible to solve the security challenge and sign in.... Mac Pro..OS High Sierra 10.13 ....running Filemaker 18 . I am having Java script issues I am assuming. Has anyone else had this similar issue and solved it? Thank you in advance Steve

I am trying to capture the object name of a slide using the OnPanelSwitch script trigger so that I can return to the slide after going to another layout. The problem is that because the script trigger is pre (processed) it captures the name of the slide that it is leaving not the current slide it arrives at. This is the script that it triggers: Set Variable [ $panellnfo ; Value: Get ( TriggerCurrentPanel ) ] Set Variable [ $$objectName ; Value: GetValue ( $panellnfo ; 2 ) ] Any ideas...?

I am trying to omit the duplicate email address but keep the last and latest one on my foundset. What I have tried: After getting my foundset, I sort by email address and then by Creation Time Stamp. Then I tried to loop through each record and compare the Email field with the next record Email Field using GoNthRecord but it is not working. Gurus out there, please help. My Code Sort Records [Restore; With dialog: Off] // sort email then by CreationTime Go to Record/Request/Page[First] Set Variable[$i;Value:1] Loop if [T02d_actcrm_EMAIL||id_contact||preferred||::Email_Address = GetNthRecord(T02d_act…

Hi, I was wondering if it's possible to add some design to my email, I have attached a sample of what I'm looking for but the idea I got is from my quickbooks email invoice. Thanks.

Hi there, I attach a sample database producing a Gantt chart for each day of the month supplied by directimpactsolutions.com Works brilliantly. However, I need to produce the same effect but for each calendar quarter (Q1 = Jan, Feb, March; Q2 = April, May, June; Q3 = July, Aug, Sept; Q4 = Oct, Nov, Dec). Can anyone advise on how to change this to produce something similar to the spreadsheet attached (used for display purposes only)? Thank you Gantt by Qtrs.xls Gantt Chart (unlocked).fmp12

I have a couple of related basic questions that I couldn't find direct answers to anywhere. First, is it possible to store my photos and videos in an Amazon AWS S3 bucket or CloudFront and enter the path to those in a container field on my local database? If so, what does the path look like (special prefix, etc)? Next, how can I easily search for records that have missing photos or videos in these container fields? I have tried VerifyContainer and IsEmpty, but I can't get anything to work! Thanks!

We have a Filemaker 18 db file. We want to be able to access it remotely with roughly 3 users in different locations. We don't want to use Filemaker 19 server due to annual cost. We currently are using separate Filemaker 18 Pro Advanced on multiple stations. What we would like to do is find a way to host it remotely online, or to buy a server version 15, 16 or 17 to host it and access it remotely. Can I get recommendations on the best way to accomplish at the lowest cost and if possible, input on how to do this. Thank you.

Hi everybody, I created a runtime for a customer that wants to access an older solution for reference only. The solution has external container storage that i cannot access anymore. The original path was outside the database so it's very hard to re-create a relative path. Tried to drag new files in containers doesn't seem to work Is there a config file somewhere in the runtime that i can use to edit a new path? Any other ideas? I have no access to the admin password of the original solution. Thanks!

have built a banking application essentially containing Accounts with a link to transactions. I like to see the transactions associated to each account in Date order descending, so they show most recent transactions at the top I want to see the current balance/running total beside each each transaction for which i use a Summary field, In the examples shown in the image - if the transactions are sorted in Date Ascending order then the running totals are correct; but if they are sorted in Descending order (which is what I want), then the running totals are meaning less to me (even if correct to Filemaker) as the Summary total seems to start at the to…

Hi, I'm using text in my delivery slip layout through a lookup field and want to remove text if "RO#" text is in the field example: VS-321 The Severed Arm: Blu-Ray RO# 52975 i want to remove everything starting with "RO#" if the field contains it, I know this can be done using LeftWords or RightWords but I can't get it done, if anyone can help it would be much appreciated. Thanks. Pio

As per mentioned in topic ,I would create script help me to make" - " between number for Emirates ID include 15 like ... 783-1986-1234567-9 Thanks alot for any help....

It's been a while since I developed a performance/singer set list application in FM18 and am revisiting it. I don't work in FM enough make my desired changes on my own, so asking for some help or directions. Essentially I have several related tables that grab info into a join (Gigs~Songs_Join) table. Tables include: Gigs: Date/time, venue, producer, etc. I Songbook: song title, duration, keys, genre, lyrics, etc. Musicians: used in Songbook to include original artist, lyricist, composer, etc. Venues: address, contact for venue, etc., used in Gigs above The attached snapshot is of the existing layout. When this was originally created, there were jus…

Hi, Is there a way to smtp email a file (pdf) from an container as an attachment, not on the client side but directly from the FMserver? The reason is that I have some difficulties with anti virus software blocking smtp actions on some client stations. Unknown error 20639. IT fixed it for now, but its not ideal. SMTP email without attachment works driectly from FMserver, but dont see a way to attach a file directly from the database. Export filed is no option server side, but ideally you would want to send a file directly from fm container. Tried something with "get data file position" but no luck. Thanks, Arnoud

I have two files. One is the parent/student file. Has a parent record and student records. The second file is another student file. I want the second file to get relational fields from the first file. Now, in the first file, the student record gets the last name from the parent record. To link the two files, I create a field of last and first and grade. Same in the second file. Then I want to pick up fields from the first file into the second. It didn't work. So I tried to index the field but it won't because last is a related field from the parent. I was going crazy so in the student file I wrote a script that copied each last name into a last_copied field so that the fi…

Hi, I am pretty sure I have done this correctly but the result is not there. I have attached a few screenshots that will explain everything I believe. Looking forward to some help. PS. I have also had some issues importing excel sheets meaning the source fields (Excel did not show, therefore I could not line them up with the relevant Filemaker fields) Maybe my Filemaker is corrupted, although I have never encountered Filemaker be corrupted. Anyway hope someone can shed some light on this Kind regards Rudy

Hi, Can someone please explain why Leftwords function is not properly working when importing an excell sheet. For example the name John Doe LeftWords ( Client ; 1 ) should show "John" only. When typing John Doe it works fine but not when importing ???? Looking forward to a reply. Kind regards Rudy

Hello, I am novice filemaker developer, and trying to learn the cool ways Filemaker can integrate with other apps. The "simple" task: upload document (.pdf) to Google Drive Folder with native filemaker funtions (no plugin). So far: I have managed to get the authorisation token (following Seedcode guide for Gmail integration and Harmonic DevCon18 presentation and demo files) and make the POST call to create a file in the Google Drive root folder, however the file is unreadable. So my guess is that I am not putting all the curl options correctly from what I understand from the Google Drive API documentation ( https://developers.google.com/drive/api/v3/manage-…

Hi, I have two table: Invoice and Customer. I like to have the total of all the invoice for a customer between certain date in the Customer portal that show all the customers, but I got a error when I try to debug.. ExecuteSQL("SELECT SUM(I.TotalAmount) FROM Invoice I JOIN Customer C ON I._kf_CustomerID = C.__kp_CustomerID WHERE date(I.InvoiceDate) between date(C.SearchFromDate ) and date(C.SearchToDate )" ; "" ; "" ) I have an error and couldn't figure it out. Thanks... KC

I have an excel sheet that controls bills of ladings for a forestry company. In the example you can see that there is lots going on with this Bill. It has a payperiod, mill, truck that delivered it, etc. I would like setup a database to monitor this. The fields CT1, CT2, Skid1, Skid2. PROC1, PROC2 are all contractor numbers. There are 6 contactors. The percentages in each line are the amount of the volume they performed In the third line there is a value in CT1 only...they get 100% of the volume. I can figure out most of this, but am stumped on how I can monitor when a contractor does multiple jobs..ie in line one, contractor 5, cuts and skids. All 6 contract…

I get an error 3 when using a script to Export Records via WebDirect. Using FileMaker Server 18 and have tried both Safari and Chrome both with same results. I have tried using the temporary path, desktop path, and documents path. I have tried using with the automatically open and not. I have tried writing a tab delimited and comma delimited file. Does anyone have ideas I haven't yet tried?

Good afternoon/evening, I have found a script which looks similar to the functionality I'd like to embed into a tab in my database, but it's not "quite" functioning correctly. What I'm hoping to achieve is to have a field I can enter comments into, and then a button which when pressed, creates a new field. The idea is to keep every comment in a seperate field for ease of reference later. Pressing the button "New Comment" also creates the date to the left-hand side (would be nice to also add the current time), and also the "Delete Field" button to the right. This is the script I discovered - but as you'll understand (better than I do), it doesn't creat…

Hi All I am hoping some one can help! I have a table called TPM, in that table is a field "Next Due Date" Which is auto generated by creating a new record. You input the date you did the service and then it adds 3 months to that date and that appears in the Next Due Date Field.. All working... What I am trying to do is when the database loads it runs a script to see if there are any outstanding TPM Services to do... Here is the script Show Customer Dialog Message: If ( TPM::TPM Next Due Date < Get (CurrentDate ) ; "You have outstanding TPM services" ; "You have no outstanding services") I thought it would be that simple.…

Dear All, On FileMaker WebDirect, we need the details of the current latitude and longitude for the Travel Tracker. Is any possible way for fetching the current location in WebDirect, which must be supported for the Android mobile user? Please advise. Thanks.

I am fairly new to FMP - currently using version 18. I would like to figure out a way to auto-populate a text field based on the selection of multiple different checkbox selections (each checkbox selection refers to a different value list selection). For example if I had three different check box fields as follows - "colour"(red,green,blue), "shape" (square,circle,triangle), "size" (small,medium,large) - if the user selected "red" in the first, "circle" in the second and "large" in the third I would want my auto-populated text field to read "red, circle, large" or something similar (doesn't have to be punctuated, could also have each word on a new line if easier?). Is suc…

A B C 1 Sep 2020 25 2 May 2022 15 Hello, please forgive me the use of wrong terminology because I am rather new to Filemaker. I need to export a table with variable number of records crossreferenced in my current table in a row by row way, meaning I want to add some information before and after the records in every row and be able to choose the separator between the records and between the rows. To make it easier to understand I gave an example of the table above. If I use the following function it gives me only th…

Assistance please. I have a an app originally designed for a desktop environment and I did the unpardonable crime of having the user scroll down to complete all the required fields within the record. There are many. They moved the app to web direct and now we are at the mercy of the browser restrictions. Poor planning on my part to be honest. Here is my issue I have a portal at the bottom that allows the user to add custom categories. And they can add as many as they like. Problem is once they add one category the browser pushes back to the top of the layout and requires the user to scroll back down to the portal to enter another category and then it pushes them back…

Can I upgrade directly from FM 15 advanced to FM 18 advanced?

Hi folks, I am fervently hoping that someone out there has a possible explanation for the following. In a file accessible to our clients uniquely via WebDirect, at a time when only our newest user was logged in, 2 invoice records went missing several days ago, presumably deleted... except that there is no delete button for the invoice on that layout. A bit more info: the invoice layout contains a portal to a child table for individual sales items and the Invoices table does have record creation/deletion privileges over the Sales table. So it *would* be possible to delete all the Sales records in the portal one by one using a delete button …

Maybe I'll get lucky and get some answers. First, I get all the updates but been using FM12. Ready to switch. I had all the downloads but I need some king of key file for 18 server and the link disappeared. Now we're stuck Second. Once we somehow create the new FM 18 server, Can I move my files slowly by having FM12 and FM18 on each workstation at the same time and use whichever I need? I would need the 12 until I update all workstations and move all server 12 files over. Am I making any sense? Need help quick, pleaaaase! Mike

Hi, we are having an domain network in which all the local users connects to different machines depending up on the availability. Problem is whenever a person connects to a new system i.e. filemaker host is never set up before, all ways need to go to setting and set up host for that particular user. Is there any way to setup a default host independent of the local user for that particular machine. Thank you in advance.

I seem to be able to get one array worth to process, but I can't get any deeper than that. Open the Sandbox3 file: Select the two red buttons in the upper left to open a couple additional windows. Press "Test Script" that is just below those two buttons in the upper left. = In the "Moby Games Local Cache" window, 10 records will be created. These 10 records are coming from the JSON data in the left most JSON blob field (JSON_Blob_Parse) Each of the 10 records have mostly single field items, but there are three records within each of the 10 that have a further embedded array. These are supposed to be created in a related table. This is what I'm…

Hello all, I have a button setup to print as a pdf. What I want to do is: When that button is pressed, the save dialogue box will already have the serial number and date added to the filename from the serial number and date field for that particular record.. Any ideas how this can be achieved? Will it require a script? Thank-you in advance for your help. Kind Regards. Andy

I created a solution for a client. The solution took a pile of their data and with a bunch of scripts, etc. produced analyses and reports. They liked it and wanted me to do the same thing with a different dataset. So I duplicated the database file, deleted all of the records and imported the new dataset (from a spreadsheet). Rinse and repeat. I now have four different files with four different datasets. Everything works great, but the problem is that every time I fix or add something in a script, I have to do it four times. This is cumbersome and error prone. So maybe I didn't approach this correctly. Is there a better way?

This is kind of a unique situation. When working with Open Library: You can call for Cover images by creating a URL with the ISBN.. and if the Cover is available, it will show up. e.g.: "http://covers.openlibrary.org/b/isbn/" & ISBN::ISBN_Search & "-L.jpg" will give you the image in a web viewer. Literally, the image only, which is actually a different URL that is not really able to be created via calculation. Otherwise a simple Insert From URL would work. If I drag that image to a container.. I predictably get the actual URL of the image. I want to get that image from the Web Viewer into a Container field with -external- storage. So I …

I previously used ODBC Manager (32 bit) to great success importing data directly from Filemaker Server to JMP. I recently upgraded to Catalina (MacOS 10.15.5) and knew that one of the casualties would be this ODBC utility. I downloaded the 64 bit ODBC manager from Actual Technologies and successfully installed it but get the following message when trying to open an FM database from within the ODBC interface in JMP: dlopen(/Library/ODBC/FileMaker ODBC.bundle/Contents/MacOS/fmodbc.so, 6): image not found I have navigated to Actual Technologies' web site believing I should download an ODBC driver but this comes at a hefty price tag, especially when converted to my…

Good day All, I'm an amateur Filemaker "developer" building inhouse solutions for various needs like planning and I'm trying to makes things less cumbersome with regards to security where all users are setup in each and every file. So when something needs to change in security I need to go to each files to make the changes, apart from an external source or an authenticating server is there a better way to use Filemaker, maybe have a single "storage security database" and have all databases authenticate via this one? Thanking you kindly!

Dear users, I have three tables for three relevant layouts. Each one has separate table and tables are related with only one field. The scope is to show on the 2nd and 3rd layout the records that related with the 1st one. Here are some screen shots with what I need to do. Actually, I need to have on the seconf layout ("Orders from suppliers") the related records from the first one ("Suppliers list") Thank you thank you Giorgos

Hello all! This is my first post on any forum ever. I've scoured the internet to find a solution to this persistent problem I'm having and all of my research has led me here. I hope someone out there can help me solve this problem once and for all: My FM Solution involves a database for housing contracts for a warranty company. When you sign your contract, that paper copy gets uploaded into the database, and ideally, that file will be going into a container field. I have the container field on my layout and scripted a "browse" button that opens the various folder for your file then (it's supposed to) upload into the container field. For some reason I can't get this …

SOLVED! I tried to insert the file in a container field in a portal. As it seems, PSOS has an issue with "Insert from URL" into a container field in a portal. PSOS is now using a different layout with a flat hierarchy. I have this strange thing when I insert a PDF from URL ("Insert from URL" script step) while "perform script on server" I get error code 1 ("User canceled action"). This is strange, as I do not consistently get the error. In my case, I am exporting an invoice to PDF (Save records as PDF) to a path, and then convert the path to a URL and insert the PDF from the URL. Please note that in either case, PSOS or local, the sub-scripts go …

I find it odd that FileMaker is so intuitive yet hides access to the file name of the data source during importing. It looks like the only way I have found based on posts on the forum is to import the Data Source file as a reference into a container field. That is an extra step that shouldn't have to be done since FileMaker sees the Source file name during multiple points in the import process. Here are three dialogs where it's seen during import. There has to be a way to use the input file name with some kind of Get Function. Please help!

I've been saving various files - mostly pdfs - in FM container fields, for years. A script triggered by clicking in the field allowed the field to be exported for viewing. Recently I upgraded to FM18, and now when I click in the field, I'm told "container fields cannot be exported"! Is there a new way that I should be doing this? Thanks.

I can ping my PDF document server from Terminal, I can connect to the PDF document server from all browsers apart from Safari, my default web browser is FireFox, I also tried to change to Chromium and Opera as the default web browser. WebViewer has the same symptoms as Safari, server not found. $ ping -nc 1 document PING document (10.0.0.7): 56 data bytes 64 bytes from 10.0.0.7: icmp_seq=0 ttl=64 time=0.002 ms --- document ping statistics --- 1 packets transmitted, 1 packets received, 0.0% packet loss round-trip min/avg/max/stddev = 0.002/0.002/0.002/0.000 ms FileMaker says ’Couldnot connect to the server.’ The issues is easily solved by creating a new…

Hello. I'm using FMP 18 Advanced, and am unable to play mp3's in a container field on a Windows 10 machine. I can insert and play these files on a Mac. On the PC the audio files do insert in the container field but do not play.

The current file format has been active since FMP12. Judging by previous versions and how often file compatibility gets broken, it seems we're due for a new file extension soon. I'm at the point where I need to update a complex database that was created in FMP11. It's not an emergency so I'm debating wether it's worth waiting another 18 months or so until we get FileMaker 20 to convert it to .fmp20 directly. But if we know there won't be a new file extension, I'd start now in FMP18. Do we have any intel on FileMaker 20 file compatibility? Cheers!

Hi, I am trying to do something rather simple. I have a list of 5 charges for my business, each in their own field. I have defined a value list of each of the charges as a checkbox set. So. What I am trying to do is enter the appropriate value to the fields based on items selected in the checkbox set. Fee 1 - 1700 Fee 2 - 225 Fee 3 - 150 etc. How would I set it up so that if Fee1 is checked, then 1700 gets automatically entered into the field "Fee 1"? I know the basics of "if this then that" but just can't figure this one out! Any other suggestions welcome as well. Thanks so much! Jerry

I'm just not getting my head wrapped around this. .. parsing JSON 'properly' as opposed to doing it like scraping. My incoming data is as such: {"ISBN:9780830631292": {"publishers": [{"name": "Windcrest"}], "pagination": "xi, 451 p. :", "identifiers": {"lccn": ["88039223"], "openlibrary": ["OL2059910M"], "isbn_10": ["0830631291"], "goodreads": ["3532499"]}, "classifications": {"dewey_decimal_class": ["005.4/469"], "lc_classifications": ["QA76.76.O63 C365 1989"]}, "title": "Inside ProDOS 16", "url": "https://openlibrary.org/books/OL2059910M/Inside_ProDOS_16", "notes": "Bibliography: p. 442-445.\nIncludes index.", "number_of_pages": 451, "cover": {"small": "https:…

So, basically, in a nutshell: If I just have a relationship setup and use that related field on the layout, I'm forever going to see the oldest entry ever made under that relationship listed there unless I've got some sorting method applied in that layout or to that relationship? First <--> Oldest, meaning if I add 0, 1, 2, 3, entries .. and at a later date delete 1 & 2, add a 4, 5, 6... that 3 being the oldest in the relationship at that point would be the one I would see in that field? This part should be a different thread anyway.

Hi, I'm new to 360works so I'm using the demo version of Scribe. I have a problem with the plugin. The plugin seems to only load one document. When I tried loading other document .docx it would always load the first document. It seems that it loads the first document and keep it as a copy in the plugin and re-use it again and again. Is it because I have a demo version?

I have been attempting to connect to a SQL database on my network using Monkeybread Software and each time that I attempt to do it I have encountered the same error, which I have attached here. I have set up an ODBC connection as well as made sure that I had the names correct, however I have gotten the same error message each time. Thank you for your help.

Hello Please can anyone tell me if it is possible to export a PDF from FileMaker with one field which is a text field so that a user can enter their name in the form field. I do not want to read the text back or export the data at all. The PDF will be saved and sent back via email by the users. The field will contain the name of the person. In the past the client has exported the records as PDFs and added the field in Acrobat and saved the PDF again. This has been time consuming. Is there a plug in which would do the job? Thank you very much for your help. Christine

Hi Guys, I have a Script running a calculation for a Find. The table is in essence as follows Item Percentage Find Field My Script/Calculation is as follows: I have an identical Script with text relating to the item. This works perfectly. For some reason the calculated field isn't. The input for this Find Field is entered as a decimal number (the setting of the the field turn it into a percentage). So if I am looking to find ≥ 10% I would enter .1 into the Find Field. When running the script, I am getting blank, with no matching records - despite the fact I know there are records …