Search the Community
Showing results for tags 'fmp18'.
-
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 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
-
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!
-
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 -
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
-
FMS18 on Mac randomly crashing at around 11:55 PM
DataCruncher posted a topic in FileMaker Server 18
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? -
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 i
-
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
-
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
-
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
-
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
-
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 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 -
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
-
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? -
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?
-
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
-
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
-
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
-
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.
-
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. -
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
