Jump to content

Search the Community

Showing results for tags 'fmp18'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


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


  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. 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.
  2. 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
  3. I have a script that distributes a quantity across various number fields using a "set field" script step. It is possible for the number being distributed to be zero. When I run the script with debugger, it puts zeroes in the number fields as expected. But if I run the script without debugger, it enters zeroes as null (blank). I have absolutely no idea why! I've tried modifying the script to specify the value with GetAsNumber and I've even tried adding to the Case statement (which determines the portion of the value to be distributed) that if the value to enter is not greater th
  4. 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!
  5. 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
  6. 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
  7. Hello, We run several FMS18 instances on Mac OSX machines. Randomly, more often on Fri / Sat / Sun, Filemaker server will shut down and disconnect all clients - curiously always at the same time, around 11:55 PM - , and I am unable to restart it from the command line and the web admin drops offline. The only way to bring it back to life is to reboot the entire machine. Is there any scheduled update job at 11:55 PM that I should be aware of that would cause this behavior?
  8. 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....
  9. 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 i
  10. 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 w
  11. 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
  12. 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
  13. This is strange. Two FMS18 servers on Mac. Both run a similar database file I had synced with mirrorsync. One of the tables is not that important but slowed mirrorsync down, so I decided to not mirror that table between server 1 and server 2, but instead make server 2 an external data source to server 1. I add server 2 as external data source to server 1. Then, things start to get weird. The table I wanted from eh external source I deleted from server 1. Yet, when I add server 2 as external datasource, it defaults back to the local file? I can
  14. 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 Goo
  15. 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
  16. 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
  17. 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 d
  18. I am using Filemaker Server 18 on Windows Server 2012 R2 Been using it for years with no issues Currently when I log in to the console it is very sluggish. When I get to the Dashboard it shows No databases, then it auto refreshes and the database list appears. Within 15 seconds of scrolling the database list to open files the screen refreshes. This situations is happening over and over in a loop. Any Thoughts on what is causing this issue?
  19. 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?
  20. Hi, My issue is that my customer layout has a script trigger on LayOutEnter that sorts my customers portal list by "Active" customers, but when I do a go to related record from another table say from quotes or any other the customer layout does not load that customer or show my related customer because the OnLayoutEnter script trigger changes it, I would like it to go to the related customer and also sort it by "Active" on the list. Hope someone can help me with this. Thanks, Pio
  21. 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 scr
  22. 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 service
  23. 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.
  24. Dear All, We have installed FileMaker Server 18. We have added a custom SSL certificate to FileMaker Server 18. On FileMaker Pro, we can view the green encrypted symbol and can able to access the Server DB. But on FileMaker WebDirect, we can't open the Server DB using the Domain name. We have received the error "No such file or directory" on connecting externally. On the internal network, we have received the error "Rejected request from RFC1918 IP to public server address" when we opening the WebDirect using Domain name. Can anyone help us to solve this issue? Thanks.
  25. 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 ha
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.