FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
I have an application where some of the related files will reside on removable media. When sorting, a message box appears telling the user that the related file (which is not on the server) can not be opened (Not Found) and asks the user to locate it. The related file may or may not be available on the removable media and is not needed for the purposes of the sort. Is there anyway to prevent this message from appearing? Error capture on does not solve the problem
-
- 1 reply
- 2k views
- 1 follower
-
-
New user I have a "Search" script setup in one of my layouts, which works well but I'd like to refine it a little to make searching quicker and with less mouse clicks. Currently, I have a field into which I enter a client name, and a "Search" button which activates a search throughout my database for any records containing this name. For the search to work I have to input the name (or a portion of it) into the "Search Name" field , and then click on the "Search" button. What I'd like to happen is to enter the name into the field and then hit the enter key to activate the same search. Is this possible? Thanks in advance.
-
- 4 replies
- 3k views
-
-
My first try using a Server Side Script. I'm importing csv data which is on "This PC / Documents/CompPBM_checks.csv". I have tried every possible path, but still get missing file error. Options tried include file:FileMakerServer/data/documents/CompPBM_checks.csv file:ThisPC/data/documents/CompPBM_checks.csv file:ThisPC/FileMaker Server/data/documents/CompPBM_checks.csv $Import. $Import equals: Get ( DocumentsPath )&"CompPBM_checks.cvs" FM Server is hosted on AWS
-
-
- 1 reply
- 1.3k views
-
-
Greetings; New to FM Forums, so I hope I’m posting correctly. I have two primary tables BONUPROGRAMS (BON__BONUSPROGRAMS_tog) & CLASSES (CLA__CLASSES_tog) I have a table BPViews that is a portal to each of the above tables (bon_BPV__BPVIEWS) & (cla_BPV__BPVIEWS) My objectives; When I populate bon_BPV__BPVIEWS::BPVClass, I want to populate cla_BPV__BPVIEWS::BPVClass When I populate bon_BPV__BPVIEWS::BPVDate, I want to populate cla_BPV_BPVIEWS::BPVDate When I populate cla_BPV__BPVIEWS::BPVName, I want to populate bon_BPVIEWS::BPVName When I populate cla_BPV_BPVIEWS::BPVDate, I want to populate bon_BPV__BPVIEWS::BPVDate My relationships…
-
- 0 replies
- 536 views
-
-
Simple problem with hopefully a simple solution. After installing FileMaker 19 (Mac OS X 10.15.7) and installed the license certificate when prompted, subsequent launches of the application remain in trial mode. I've followed the instructions at the site linked below: https://www.soundsessential.com/blog/191-filemaker-pro-19-how-to-fix-the-license-certificate-not-installing But they made no difference (and I didn't have the folder structure issues shown in that blog post). I also have FM 17 Advanced installed as my default FM application, so perhaps that's part of the issue. Any ideas? Kevin
-
- 0 replies
- 970 views
-
-
I am attempting the simple task of omitting those records from a search result when a specific field is empty. The obvious solution, Constrain Found Set > Omit Records > Criteria = "" (equal sign omitted) for some reason doesn't do the trick as I'm still getting records that have empty values in that field. Thanks.
-
- 1 reply
- 2.1k views
-
-
In list view my fields extend off the available screen area. In Layout Mode the Top Navigation part scrolls to the right together with the Body part, BUT when I exit Layout the Top Navigation part does NOT scroll when I scroll to the right in the Body part. How do I keep the Top Navigation Part in line with the Body Part? This is thoroughly disconcerting as my field labels are all in the Top Navigation Part, but the fields are in the Body Part. The two do not align as I scroll to the right. Any suggestions would be gratefully received. Problem Solved - I should have put the labels in 'Header' rather than 'Top Navigation'. Now the scrolling works
-
- 1 reply
- 1.3k views
- 1 follower
-
-
Does anyone know how to do this? calling the "generate as configured" script stacks the script that gets called after the webveiwer is set at the end of the primary script, there for only the last record in the found set of the loops actually has the image file created and saved to the container field.
-
- 1 reply
- 1.2k views
-
-
Recently converted a FM application from V6 to V19. The application will run on FM server. Very new to FM19 Questions related to temporary path I have scripts that exports data to 3 temporary fm12 files. Two of the temp files hold data that is them imported to other files and one of the temp files holds data for a lookup in another file. dhistory imports data from dtemp rhistory imports data from rtemp vendors looks up data from vtemp The temp files are fm12 files Questions 1. I would like to have the temp files sent to the temporary path on the users computer. I have not been able to correctly specify the output path to send t…
-
- 0 replies
- 1.5k views
-
-
Hi All, Just had a look at the new Add-ons in Fm19. Is there a way to make the timer work in reverse. i.e. Start from a field (Timer::TimeLength) that a user can input, so that the specified time of say 30:00 will run down to 0:00 Any help would be appreciated. Regards Milton.
-
- 1 reply
- 2.3k views
- 1 follower
-
-
Hey Guys! I am having an issue with my Script Workspace. I am trying to use common functions like GET(CurrentDate) or GET(QuickViewText), but they are not "found". I can type them out, but when I hit "enter" the line disappears in the workspace. They are also missing from my "Steps" window on the right side of the workspace. I searched for "Get", and all I get is "Get Data File Position", "Get FIle Exists", "Get File Size" and "Get Folder Path". Nothing else. If I go into Manage Custom Functions, I can see them listed in the Edit window. Any thoughts? I'm on FileMaker 19.2.1.14
-
-
- 3 replies
- 834 views
- 1 follower
-
-
I am trying to script an import of three worksheets in the same Excel file. The 3 geographical regions worksheets are not structured the same, i.e. field name rows are not in the same place and are named differently. The script runs but stops to ask which worksheet to process. How do I create a variable/parameter in the script for it to proceed sequentially from worksheet 1-3 without stopping? Thanks DA
-
- 5 replies
- 1.2k views
- 1 follower
-
-
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.
-
-
- 8 replies
- 4.2k views
-
-
Thank you in advance... We have a serialized field that has a value of FL2021-0001 and increments by +1. I created a script that makes a duplicate record for reasons that don't matter here... but at this point I need to reset the serialized field to the next correct number. I do this with the Set Next Value function as such: Set Next Serial Value [TableFL::SerializedField ; Max ( TableFL::SerializedField ) + 1 ] The problem is it sets the next value to 20210002 instead of FL2021-0002. Can I read this as a string and increment it or is the return always going to be a strict numeric value? Thanks again.
-
- 8 replies
- 1.7k views
- 2 followers
-
-
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…
-
- 0 replies
- 1.6k views
- 1 follower
-
-
Hello Everyone, I would like to check what are issues when FileMaker Pro and Server 19 are installed in Windows Server 2012 R2? Thanks.
-
- 0 replies
- 835 views
-
-
The content of myField is: text before quotes "quoted text" and I want to format a JSON object: JSONFormatElements ( "{\"object\":\"" & myTable::myField & "\"}") the quotes within my data make invalid JSON, so I escape quotes: JSONFormatElements ( "{\"object\":\"" & Substitute ( myTable::myField; "\""; "\\\"") & "\"}") Then I get valid JSON like this: {"object" : "text before quotes \"\u0016quoted text\u0016\""} I wonder where these \u0016 characters added around the quoted text come from, I don't want them there How should I escape quotes without this problem?
-
- 4 replies
- 2.6k views
-
-
Hello, I'd like to record when a user views a record, and then have a layout where the "Unviewed By Me" records become bold. This idea is similiar to "Unread" in most email programs, but it is generated from a shared set of records instead of only emails delivered to me. I know that I can create a subtable to create a record each time someone views a record. I don't need an audit trail of when or how many times they viewed it, just the LAST time, if they have viewed it at all- which makes me think I want this info in the record in question, not through a relationship. I only have 4 users, and I don't need this to scale up to more users. Would it be a bad…
-
-
- 3 replies
- 644 views
-
-
In the attached sample, there are two tables: a Project table ("AD") for project name and booked $ amount and a related table ("Rcvbls") which can have multiple invoices per project as shown below: I want a report that shows projects by status and has summary amounts for the Rcvbls data as shown below: As you can see, the BookedAmt (from AD) works fine in each part of the report, but the related records subtotals and grand totals aren't acting correctly. Any ideas what I'm doing wrong? The db is attached. ReportTest.fp7
-
- 2 replies
- 5.4k views
-
-
I'm having an issue with the getnthrecord function. I am using it in conjunction with the get(recordnumber) function to get a value from field X in the previous record in a sorted list (i.e. getnthrecord (X ; get(recordnumber) -1), and then add or subtract something from it to give the value of field X in the current record. It's working fine for the first 130 records in the found set (out of about 150) but thereafter it shows a ? in the field--and I cannot click that field to see what value is in there, so it's not obviously a wrong formula or a larger number than the size of the field can contain. I've tried it in various databases/tables and it always seems to hap…
-
- 6 replies
- 3.6k views
-
-
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?
-
- 1 reply
- 1.2k views
- 1 follower
-
-
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…
-
-
- 7 replies
- 849 views
- 1 follower
-
-
Being forced to upgrade my Filemaker version. I bought it under the Educational discount just before I retired. I had to replace my computer this month and now I can't use that version of Filemaker (8.5). That's fine. It's an old version and I wanted to upgrade, anyway. The problem is the price of the current Filemaker version. I'm not going to pay a thousand or even hundreds of dollars per year for a license to use FIlemaker at home. When I still worked at the university I used Filemaker extensively, and I was pretty good at it, but I'm using it for a few small databases at home. I'm looking for affordable alternatives. Is there a Filemaker lite? I'd like a one…
-
-
- 8 replies
- 2.6k views
- 1 follower
-
-
Hi, I am new to FileMaker. Let's say I write an app and upload to the iOS appstore. And later I make lots of changes like adding new functions and new layout in the app and I want to do update of the app which is already in the iOS store and in the users' ipad and iphone. 1) How is it going to be done? 2) Is the user data going to be safe after the update? 3) Is the procedures going to be the same as the desktop app (Any alternative other than doing "Import")? Thanks KC
-
- 0 replies
- 889 views
- 1 follower
-
-
Is it possible to change the logo of the FileMaker 16 local file? We changed the logo in in "File Options". But it is not reflecting in the FileMaker DB logo. Thanks in advance.
-
- 0 replies
- 573 views
-
-
Good day. I am in the board of a voluntary red-cross organization and work on the project of creating a database to summarize all relevant information into one platform. In the creation of the database I am struggling on the following issues: For the invoicing of the medical services I would like to handle this with one button. The invoice should be created as PDF - named with the invoice number and the event title (both defined from fields) and the invoice should be attached in an automatized E-Mail with the subject text containing the invoice number as well as the event title. The body text can be a standard text and the E-Mail address should be defined from the…
-
- 2 replies
- 1.4k views
- 2 followers
-
-
I suggest you post your date question separately, as it is unlikely that anyone else in the future will be interested in this particular combination of problems. When you do, please clarify if it is possible for a shift to span more than 2 periods - e.g. start at 7:00 PM and end at 9:00 AM the following day. Also, please update your profile to reflect your version and OS so that we know what you can use.
-
-
- 5 replies
- 693 views
- 1 follower
-
-
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.
-
- 0 replies
- 652 views
- 2 followers
-
-
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…
-
- 2 replies
- 1.3k views
- 1 follower
-
-
Hi all, I would like to create a page count for a found set of records when I am in preview mode and when I export to PDF ie if a found set of records has 3 pages then the first page would contain a field that reads '1 of 3' Can anyone help with how to achieve this? Any help is much appreciated Thanks Michael
-
- 3 replies
- 1.8k views
- 1 follower
-
-
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 …
-
- 1 reply
- 1.7k views
- 1 follower
-
-
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.
-
- 2 replies
- 845 views
- 3 followers
-
-
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. . . .
-
- 8 replies
- 1.2k views
- 1 follower
-
-
I cannot select inside an input field at a specific character. Clicking on the field works and selects the field, but I then need to use the arrow keys to go to a specific characters. Mouse clicking at a specific characters does nothing. Anyone has experienced this? screen.mov
-
- 0 replies
- 733 views
-
-
Hello, I moved fields (and scripts) from one FM file to another one. Now, I have a table to 2 fields that has same function but different names, example: Container1 and Container2 Both have their own attached scripts and calculations. I would like to merge "container2" into "Container1" field so the attached scripts and calculations will also change, but I can't rename it simply to "container1" is there a way to without going through all the scripts and calculations? Thanks
-
- 6 replies
- 683 views
-
-
Hi all, I have created a portal in a related table and I want to apply a filter to it so that it only shows the latest versions from a found set of records and to hide the others. There is a related field within the portal called 'scan version' which displays the version number as eg 'v001' 'v002' 'v003' etc I've been hunting around online to find a calculation that fits my needs and have played around with the 'Max' function but to no avail If anyone can give me some pointers that would be awesome, I'm still very new to this and learning so any help is always appreciated! If you need any more info please let me know Thanks I have just …
-
- 5 replies
- 732 views
-
-
Hi everyone, I am trying to make a database for my analogue/film photography with FMP19. In my ERD I have a “MediumBatch” (parent) and a related “Exposures” (child) table. A MediumBatch record can be a single 4x5 or 8x10 film sheet (hence 1 single exposure) but also a 6x6 film roll (roughly 10 exposures) or a 35mm film roll (24 or 36 exposures). I have a Get( UUID ) primary key in both the parent and the child table. I also have an auto-enter serial number for the MediumBatch table (I need it in order to match it to my paper database). I also need a serial number for the Exposures table. When I create…
-
- 2 replies
- 1.3k views
-
-
Hi, I have tried to pass the below JSON data to the API. But it doesn't accept the JSON data due to Square brackets[] in the JSON Key. Is there any solution available to pass the below value? JSONSetElement ( "{}" ; "[Name | Last]" ; "Test" ; JSONString ) We need the output like below. { "[Name | Last]": "Test" } Thanks in advance.
-
- 1 reply
- 1.1k views
-
-
Hi all, I'm a film editor and have started building a FM database to be able to track visual effects shots that go in and out of an editing timeline. I am trying to create a calculation that will enable me to add frames to timecode and get the result back in timecode. At the moment I have a text field called 'Scan TC In' which has the following TC entry 18:59:48:23 (HH:MM:SS:FF) and I need to add 8 frames to it, the timeline runs at 24 frames a second. Does anyone know how I can achieve this? I'm a newbie to FM so any help is greatly appreciated! Thanks Michael
-
-
- 11 replies
- 2.3k views
-
-
Hi all, I'm new to this forum and to filemaker and looking for some help. I have the following number in a field 101_010_0010 and I want to extract 010 from the middle of the number and paste it to another field. I have been trying to do it with replace field contents but with no luck... does anyone have any advice on how I can achieve this? Many thanks, Michael
-
- 4 replies
- 1.1k views
- 1 follower
-
-
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…
-
- 2 replies
- 3.3k views
- 2 followers
-
-
I have a database of around 35K music tracks, each of which has a file ID and any number of keywords up to around 200. There is a fileID-keywordID table, and a main table with a global keyword field. Using a relationship between keyword ID's in the two tables, the user selects keywords from some pop-down menus for different categories, and I create a list of keywords in the global field - this is the "Magic Key", which automatically shows any tracks that contain those keywords in a related portal. However, this shows *any* tracks containing each keyword (ie this is an "or" relationship). I then wanted the option to show "all" (an "and" relationship) which would only displ…
-
-
- 11 replies
- 893 views
- 2 followers
-
-
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
-
-
- 6 replies
- 889 views
- 3 followers
-
-
I have an older "contacts" database that I want to update using the template from Filemaker Pro 19. Unfortunately, importing the data from the old DB to the new DB is impossible due to how they structured the database. The "new" way is better, using related fields, so that one could have, say unlimited phone number fields, as opposed to a pre-determined amount. The problem is the import window only shows fields for the current layout to import into, and not any related fields connected to that layout. So, phone numbers, addresses, etc. all wont import. My idea was to just copy said layout to the old DB, so the data would still be there. Then map the fields to their c…
-
- 1 reply
- 2.1k views
-
-
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…
-
- 0 replies
- 1k views
- 2 followers
-
-
Forgive me if this is a dumb question, but I am new to FileMaker. I want to automate the process of users importing an "update" fmp12 file into an existing database. Sometimes this update file will include a container field of images, other times (to keep the file size down) this field is omitted from the update file, so I don't think I can use Custom Order or Last Order because of this variation in table structure (and the user will not necessarily know which structure it is). I had expected "Matching Name" would cope with this, but when I am creating the script, when I select the blue Match Field option (which I have to do because I want to Update, not Add) the "Ma…
-
- 0 replies
- 992 views
-
-
Hi All, As per mentioned on topic, in fact i would like to create icon ex. hour in case rigging guard the insert time.
-
-
- 6 replies
- 937 views
- 2 followers
-
-
I made an awesome capture utility to capture pics from a webcam for ID card purposes. Works perfect online, but in the fm web viewer is does not (it loads the basic html, but nothing more). It uses javascript and css, nothing fancy or out of this world. Tried it as a link to my server, and as complete html code. Anyone got an idea on why this is not working? https://fieldsmedia.com/cameracapture/
-
- 4 replies
- 2.1k views
- 1 follower
-
-
I have a regular text field with a height of 20 px in Layout mode. In Browse mode that height is respected. But when I select the field, the height seems to triple and a blue border is added. How do I get rid of this behavior? No doubt it has to do with the stupid Themes thing, but how do I edit that? And is there a way to completely remove the Themes/Styles from a database? This feature has zero usable themes as they are ALL UGLY. I create a nice pro look and copy paste fields, Filemaker Themes/Styles s*ck.
-
-
- 6 replies
- 905 views
- 1 follower
-
-
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…
-
-
- 4 replies
- 1.4k views
- 1 follower
-
-
I know the solution is probably very easy but it escapes me. I got this database, which I use to create invoices, year after year, I created a report page where with a neat summary field I get the "lifetime revenues", "lifetime general expenses", "lifetime total taxes" and "lifetime total invoices number", which is handy, but I need to have the same data broken down by year, and I can't figure out how to achieve that. In another post I have been suggested to consolidate the three tables I had (Invoices 2018, Invoices 2019 and Invoices 2020) into a single table (Invoices) and then use a "subsummary" which would give me the data I want based on how I sort the records b…
-
- 15 replies
- 1.8k views
-
-
I have a calculation that goes like that, I input a number on "Base Imponibile" (say 100), it adds 15% (it gets me 115), it then calculates 4% to the previous result (115) and it gets me 4,60, I then add 2 and the total is 121,60 which is perfect. And that's the part that works just fine. But I then want to make a reverse calculation, where I input the expected result of Total Calculation and tells me all the other values and here it's where things go awry. I'm attaching the initial calculation that works as a reference and the reverse calculation which doesn't work as an example. The "2" that gets subtracted in the reverse calculation is a fixed value of…
-
-
- 4 replies
- 1.1k views
-
-
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
-
- 2 replies
- 881 views
- 1 follower
-
-
I have a nonprofit in my town. They rescue horses. I reached-out to see if they need any I.T. support. They responded and do. I went onsite to find-out whats going on. It's a complete mess. running wifi EVERYWHERE and wondering why everything is slow. They are a mac outfit and just recently went to the web(Claris). They have 6 Macs and only two can use the client, because the others are so old(only web based and looks completely different then mac client). Now, I'm a windows\Linux guy. 28+ year I.T. consultant that has pretty much worked on everything, but apple..... I even have worked on Fielmaker pro(server v7, lol) How involved would it be, to switch them to wind…
-
- 3 replies
- 596 views
- 1 follower
-
-
Hi everyone, This may seem pretty basic to most but I am a very new user. I have managed to create my asset database with the following fields: MAKE - TYPE - SERIAL NUMBER - SERVICE DATE I have scripted a button to enable me to click on a record in portal and update the service date to current date (pretty easy). What I would like is to be able to store each date the item was serviced and have a list of those dates appear inside a pop up when a SERVICE HISTORY button is pressed. I have been trying to script it so each time the SERVICE button is pressed it updates the SERVICE DATE field with current date and also stores that date is a c…
-
- 3 replies
- 1.5k views
-
-
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...?
-
- 5 replies
- 1.8k views
- 1 follower
-
-
Good evening, I would need to create a script that exports the data of a format to an email. My difficulty is to insert the data in the mail in table format, instead of as simple text. Thanks.
-
- 3 replies
- 1.8k views
-
-
I'm not even sure to describe under which category my specific problems fall into, I can only advance some hypothesys, so I'll just describe it and let the wisdom of others guide me. I have a DB with several tables, I use them to make invoices. With every invoice I input the desired price and it adds automatically 19% taxes and produces a neat invoice which I can print, these three tables are called: Invoices 2018 Invoices 2019 Invoices 2020 Now on to my problem. I wanted to create a forth table where from every previously listed table it would calculate the total revenue of the year in question, broke down like this: - Total Net price paid for 201…
-
- 3 replies
- 1.4k views
-
-
Hi Group how can i copy a parent record and all the child portal records in it into a new parent record with a new parent id number with all the copied portal records updated with the new parent id number? Fluffy
-
- 0 replies
- 670 views
-
-
Hi, I am trying to better familiarize myself with Custom Functions and am going through some very basic exercises to get an understanding of how they can be used in calculations, and also make use of global variables as parameters. Along the way I've run into what to my eyes seems a bit odd. I'm hoping a more experienced developer can help me understand why. I've created the following: Custom Function: name: TESTFUNCTION Parameters: PAR1; PAR2 TESTFUNCTION( PAR1; PAR2 ) = PAR1 + PAR2 Calculation Field: = TESTFUNCTION( $$PAR1; $$PAR2 ) *Calculation result is Number Script: (to set the variables $$PAR1 and $$PAR2) 1. Set …
-
-
- 2 replies
- 2k views
-
-
I just moved form 18 to 19. In FMP 18 I had a folder in my applications folder that was called “FileMaker Pro 18 Advanced”. It contained: FMPA Read Me (English).pdf FMPA Acknowledgements.pdf FMI Runtime Resources FileMaker Pro 18 Advanced Extensions English Extras After upgrading to 19 IO do not see that 19 has the same folder. Is this a problem? What to do? Any tips or ideas?
-
- 0 replies
- 1k views
-
-
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…
-
- 1 reply
- 1.5k views
-
-
I recently upgraded to Big Sur and I use the lasted Claris/FileMaker 19. Since upgrading to Big Sur one of my scripts no longer works in iMessage. The script involved pasting several mobile numbers into iMessages via the URL Script ("iMessage://" & Filter ( Contacts::MobileGroup; "+610123456789," ). Instead of phone numbers I now only get the first record/number. Or if I do a manual copy and paste (from FileMaker to Messages I get "⬀㘀㐀㈀㜀 㜀㤀㌀㠀Ⰰ⬀㘀㐀㐀㜀㜀㤀". My script worked perfectly before Big Sur and was able to send texts to over fifty people at once. Is this a bug, a redacted feature in iMessages or a change that I need to make in FileMaker to…
-
- 0 replies
- 758 views
-
-
Guys, there is a task, to establish work between FileMaker Server v19 and clients FMS Pro & Go. What is the challenge? 1. On a new computer, Windows 10 is installed, then a virtual machine, and on a virtual machine Microsoft Windows Server 19, and on this server has installed FileMaker Server v19. To my mind - Frankenstein)))) The installation was completely done by me. We set a task, completed it ... but ... 2. To the admin panel - I have access through local host. In the admin panel on the main page I see all the data as well as the IP that the server has. The installation was carried out according to the official instructions. 3. It's time for t…
-
- 1 reply
- 1.8k views
-
-
I have 1100 records in a found set. 12 records are for 1 customer 2 records are for another customer etc. My question how can I get an individual count of each customer in the found set.
-
- 7 replies
- 2k views
- 1 follower
-
-
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.
-
- 1 reply
- 1.7k views
-
-
Hello! I am a beginner and I need help of advanced users in the matter of converting characters, namely from period to comma. What's the point? There is a CSV file, it contains data. Example - 5.00%, 20.00%, 2.456, 22.564 and so on. Below is a screenshot of the file so that you understand the content. When importing data from a file into an existing table, the data is displayed as follows - 500 2000 2456 22564 As you noticed, data has no structure and is just a set of numbers. The screenshot will show how it looks after import, and it will also show how the data after import should be displayed. In short - In the imported file, there is a dot between the numbers, and…
-
-
- 8 replies
- 1.6k views
- 1 follower
-
-
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
-
-
- 4 replies
- 1.8k views
- 1 follower
-
-
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 than zero to just enter a zero. Still makes the field blank. 99% of the time but n…
-
- 3 replies
- 1k views
- 1 follower
-
-
I am trying to modify one of my exisiting databases. I firstly clone the old database they I want to rename it as=nd mnodufy a few layouts for a new business. I have managed to clone it, but I simply cannot open the clone. I just get an error that Filemaker is unable to write to this file. No idea why, file permissions are correct. Anyone else seen this? I have recreated the file, moved it to different folders etc. This is using Filemaker Advanced 16.
-
- 2 replies
- 1.9k views
-
-
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!
-
- 1 reply
- 735 views
-
-
Under Mojave, my version of Filemaker was funky but more or less functional. My recent upgrade to Catalina put a stake thru its heart. I came here after and hour of reading endless sales pitches on the website, 20 minutes waiting on the phone for sales and another 20 in the chat jail with CalrisBot, also awaiting someone with a heartbeat. I'm sold, I want the product but I'm getting a bad feeling. I was an advanced user in the past with Filemaker Pro 11 but my work took me away from database paying work and although my work is now more involved with research and activisim, I'd like to bring Filemaker back into my toolbox. Can you purchase FileMaker or …
-
-
- 9 replies
- 1.7k views
- 4 followers
-
-
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.
-
- 1 reply
- 796 views
- 1 follower
-
-
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!
-
- 0 replies
- 652 views
- 1 follower
-
-
Total newbie question: I am a registered user of Filemaker Pro 15 (from back in the day). I am about to write an application for a small organisation to maintain contacts and workshop bookings. This needs to available remotely by one, maybe two users (and me). There is a company that offers Filemaker Server 14 shared hosting at a reasonable cost (filemaker-hosting.co.uk). So, they licence FM Server 14, I have FM Pro 15, my client needs one or two copies of FileMaker Pro 19, yes? and will that interact successfully with an application on Filemaker Server 14. Does my plan seem feasible? Any issues here? or any other way of approaching this situation. Ma…
-
- 5 replies
- 940 views
- 1 follower
-
-
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…
-
- 0 replies
- 1.4k views
-
-
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
-
- 6 replies
- 1.9k views
-
-
Is there a way to change my coding of scripts so that so-called scripting errors don't show up in server logs when a scheduled script is executed on FM Server? I get dozens of such errors for each daily execution, and Using a Set Error Capture [On] script step doesn't seem to make a difference as to whether the "errors" show up in the server log. The kinds of error codes that do show up (101, 401) don't seem to me to be be the result of scripting errors at all. Rather, they are part of ordinary operations (e.g., testing to see whether to stop looping by checking whether a record exists in a found set). I raised this question a couple of weeks ago in a much longer ema…
-
- 2 replies
- 1.2k views
- 2 followers
-
-
I have seen various articles and videos that explain how to upload a file from a Filemaker Container to Dropbox using the Dropbox API. However I would like to create a script so that a user can save a pdf directly from Filemaker to a shared Dropbox Folder. Any tips?
-
- 3 replies
- 1.7k views
- 2 followers
-
-
My script in a hosted file needs to export records as pdf into the user Downloads folder, needs to run under Mac and Windows, so I set the variable $path_filename to: Case ( Get ( SystemPlatform ) = 1; "filemac:"; Get ( SystemPlatform ) = -2; "filewin:"; "file:" ) & Substitute (Get (DocumentsPath); "Documents"; "Downloads" ) & "file.pdf" And then: Save Records as PDF [With dialog: Off; $path_filename ; Records being browsed ; Create folders: Off] The script it works in Mac but not in Windows: I get an 800 Error and a message warning that it can't create the file. I don't get what's wrong with the windows version, any idea?
-
- 2 replies
- 2k views
-
-
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....
-
-
- 4 replies
- 1.4k views
- 1 follower
-
-
As there isn't a thread about this I thought I'd post about this annoying bug as it affected me and I thought I had a corrupt db. The issue seems to be that when editing layouts with certain summary parts in FileMaker 19.1.2 it changes the way that the layout is configured, so that a DDR created in FileMaker 18+ (at least) crashes FileMaker Pro and fails to create the DDR. Some points from my testing: Creating a DDR without selecting 'Layouts' works fine. 'Save a Copy as XML' works fine. It seems that running Recovery or compact/repair in 19.1.2 also introduces the issue. I don't know if running this in 19.0.1 fixes the issue but worth trying…
-
- 2 replies
- 2.1k views
-
-
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…
-
- 0 replies
- 938 views
- 1 follower
-
-
I have a small Filemaker Member's database (less than 1,200) with some 650 existing members but I am not the Membership Secretary. The Membership Secretary uses Excel to record who joins and resigns, and each time there is a change in membership (joining or leaving) the Excel file on Dropbox is updated and I am notified. I therefore have to import that data into my Filemaker Members database each time there is a change to the members (new member, change in personal detail or resigned member). However I am in control over the data of the existing members who also join our web membership (at present less than 100). The web members have to be manually activated when…
-
- 5 replies
- 1.7k views
-
-
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
-
- 0 replies
- 1.3k views
-
-
Hello hope all is keeping well? Please I need help with this script what I have been trying to do for the last week is to put a saved PDF into a container field after its been created? I have tried to insert into a container field with the field be interactive and not Interactive but with no joy. The script attached is where I have been trying to place the script where the red line are? So after its saved to the desktop import into a container field so we have a copy of the PDF I hope someone would be so kind to help me Thank You
-
- 5 replies
- 2k views
- 1 follower
-
-
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…
-
- 4 replies
- 982 views
- 1 follower
-
-
I need to import a large amount of data from excel spread sheets into FM19. Is there a way to create a custom import order of field so it will be easy to match the source fields with the target fields. ( I know there is an "arrange by" -custom order) option but that is not a fast enough way The excel spread sheet (source fields) will not be in the same order as the Filemaker File (Target Fields) I often spend a lot of time matching up the source field and the target field and I am looking for a more time efficient way
-
- 0 replies
- 1.9k views
-
-
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
-
- 0 replies
- 1.1k views
-
-
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
-
- 5 replies
- 1.1k views
- 1 follower
-
-
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-…
-
- 6 replies
- 3.8k views
-
-
Hi all, Novice here. I have a simple two table database for inventory tracking. Parent table "Cases" and child table "Items". The cases can be filtered by finding all cases with the field "Status" set to 'Yes' or 'No' I am able to create a report Layout with the found set with the field 'Case Name' in a Leading Sub Summary part and the content field of each case (Items) listed in the body part. What I am struggling with is a way of having a field in the Leading Sub Summary part along with the 'Case Name' that sequentially numbers the Cases in the found set from 1 to xxx Can anyone help me please?
-
- 3 replies
- 1.4k views
-
-
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
-
- 1 reply
- 821 views
- 1 follower
-
-
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…
-
- 2 replies
- 827 views
- 1 follower
-
-
I know that peer to peer sharing has been deprecated. I also know that it still works on my network between two computers. My client has a two-person shop and has been doing peer to peer for years. He wants to upgrade from an old version of FileMaker to 19 because he is getting new computers. He has been hit hard by events this year so he wants to spend the minimum amount. My versions of 19 are part of a volume license, so I don't know if p2p sharing is only working because of that. Would it work with two or three individual licenses of 19?
-
- 2 replies
- 2.3k views
-
-
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?
-
- 0 replies
- 1.1k views
-
-
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
-
- 7 replies
- 1.8k views
- 2 followers
-
-
Hello all, While I'm not exactly new to using FileMaker (17, in this case), I am quite wet behind the ears with a lot of its functionality, and the proper way to do things. I've put together a few solutions that seem to work, but they aren't pretty, and I'm sure they are quite inefficient. I'm not really sure how to ask this question, so I'll lead with a simplified example: Let's say I have one table that is the focal point of a relationship (Table X). In that table, I store foreign keys to smaller tables (1-5) that just provide options for the main table foreign key fields (via value lists based on the 1-5 table fields). Is it necessary to connect eac…
-
- 4 replies
- 1.9k views
- 1 follower
-
-
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…
-
- 6 replies
- 2k views
-
-
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.…
-
- 1 reply
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.