FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Chino Hills, Calif., July 22nd, 2019 — John Mark Osborne and I would like to invite you to join us at the Fireside FileMaker podcast (http://www.firesidefilemaker.com or https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087) for a series of interesting and, we hope, thought-provoking conversations about everything FileMaker™ from two passionate developers with a total of almost 60 years developing FileMaker solutions. “Michael and I have created FileMaker example files, written blogs, recorded videos, released example files, presented in public and even published books but we have never had the opportunity to record informal chats about FileMaker, muc…
-
- 0 replies
- 633 views
-
-
Just upgraded to FMP 16. Now when I try to log into my solution as an admin by hitting the option key I just go straight into the solution. Unfortunately I go straight in as low level user and not as an admin so there doesn't seem to be an easy way to fix this than I can think of. Any suggestions?
-
- 4 replies
- 3.1k views
-
-
Hello, I have a long text fields that's been calculating a lot of things and put them in one large text field to be exported. I want to calculate the lines of the text field with ValueCount function but I want the result to be in the same field as the one it's calculating. I tried to create a different field, which I got the number of lines, but when I try to insert that field in this long field, it shows a "?" and doesn't show up anything else in the field. Does anyone know how to calculate the number of lines in a long text field and put the resulting number in the same field it's calculating? Hope this is clear. Thanks anyone for assisting in advance!
-
- 4 replies
- 645 views
-
-
Excel and Filemaker calculates the difference between two dates differently. I always thought that when you subtract two date from one another, the result was the number of full days between the dates. For example: Calculate the difference between 1/15/19 – 1/9/19. There are 5 full days between these dates (10th, 11th, 12th, 13th, and 14th). However, FM and Excel calculations do not result in 5, and they don’t even agree with each other! In Excel, Difference = 7 In FM, Difference = 6 It seems that when you subtract two dates in Excel the result includes the starting and ending dates and therefore it is not the number full days between…
-
- 1 reply
- 2.1k views
-
-
Hello, We are running an FM15 solution on a Windows Server platform in a small sized company setting. The FM solution is comprised of about 70 Tables, multiple layouts and Scripts. Its been in use for over 6 years in this environment and working well On June 25th, the File size grew from 1.7 GB to 5.8 GB Performance the next day was fine, and we actually didn't notice the change until 2 weeks later I have run: File/SaveAs/Compacted: 4.29 GB Save as Clone No records: 3.24 GB I have run the DDR report on an older,smaller backup file and this one and cannot detect any glaring differences When running the Recover command it ha…
-
- 3 replies
- 1.4k views
-
-
Hello French user of FM14 I'm looking for a sample of getting infos for a book through Google books API in a FM database (tile, author...cover picture...) Thanks for your help Noël
-
- 2 replies
- 757 views
-
-
Hello! I am building a database and came up this little problem can help. The identification number is composed of 9 digits, the first 8 digits being in series and the last one is digit check based on the algorithm of Luth, that is, instead of confirming and manually entering the identification number, there would be no a calculation / script that when creating a new record it created an identification number with the requirements above. Here is an example: 19510889 2 19510890 0 19510891 4 Thank you,
-
- 6 replies
- 4.7k views
-
-
I am building a directory for my HOA. All of the data is in the Mac address book. I can sucessfully export that to Numbers and then export to a .csv file. I have designed my directory page and I can import the .csv file into it and I get a correct page for each homeowner with all the data, addresses, names, etc. That all works fine. In the upper right hand corner I have a block for the picture of the house. I have to go to each page of the directory and drag and drop the picture to that box. Needless to say I would like to get that automated. One of the things I import with the .csv file is the Lot Number of the house. Simple 3 digit number of 1 to 250. I have all of th…
-
- 2 replies
- 1.3k views
-
-
Hi everybody, looks like I do have a sort of rookie problem here. I created a subsummary report which is sorted by a break field and all works fine. All is fine in layout and preview mode. Just in browse mode I seem to have a problem. There is a large grey empty area just underneath of the subsummary part showing. Anyone with an idea what it is I messed up here? I already googled but just found 1 similar report from 2010. Sort of optically annoying. Any help is highly appreciated.
-
- 6 replies
- 1.5k views
-
-
Hi everyone I am working with filemaker on and off for the last recent years but, no doubts about it, I am still a rookie. lately I have created a db similar to a booking engine for shore excursions for river cruise ships. Lots of modules, layouts, scripts etc. As I really have to work with my limited knowledge, it took a long time and is not really constructed in a way any pro would do it with a lot of workarounds and probably sort of unorthodox. However, it works just fine for me and I am sort of proud, to have gotten to the point where I am. However, I am afraid, that I corrupted the whole thing somehow. No I am trying to integrate a sort of an accountin…
-
- 1 reply
- 1.9k views
-
-
I was wondering if anyone has ever tried this before. I need to import about 20 ledgers into Filemaker. This would obviously be very expensive if someone had to type out all of the pages line by line, (I would say 6 months of work). Does anyone here know of a means of scanning it into filemaker or Excel in order to create the database that we need?
-
- 1 reply
- 902 views
-
-
Hello Experts, In my attached sample file, I have two Tables Inventory and Transactions. In my Inventory Table I have fields Current Month Inventory Last Month Inventory I want these two fields to capture the count of my Last month Inventory and the count of my current Inventory. In my Last Month Inventory Fields I like to have 1589 Bottles / 7 Boxes ; If someone withdraw 235 Bottles This Month My Current Inventory Fields will Show 1354 Bottles / 6 Boxes. Please find attached file that Im working. Thank you Cross posted to https://community.filemaker.com/en/s/question/0D50H00006…
-
- 3 replies
- 1.8k views
-
-
Hi Guys, There is any script who request user and password of user after click in a button. I have a check box in my solution with get username for log register and validation, i want to request user and pass to allow user enter this option. Thanks for all.
-
- 3 replies
- 1.5k views
-
-
Running FmPro 14. This is about trying to mine data as it is entered into a database. I have to modify an existing database, but it has not been set up very well. There are only 2 Tables: Invoice, and Inventory. Only key field is ID, which is used to identify the specific piece of gear. Approx 200 ID "codes" (Primary Key in Invoice table, Foreign Key in Inventory table) Inventory rarely changes, and current stock is kept in an "on hand" field in that table. An invoice is created for future meetings listing line by line items. Invoice form is set up as lines...Fields are: # of units needed, ID, Name of item…
-
- 0 replies
- 1k views
-
-
Hello FM Experts! Does FileMaker can create a Queuing System? Here's an example of a Queuing System: Do you think I can create a Queuing System using FileMaker?
-
- 4 replies
- 2.3k views
-
-
Basic Question: I am attempting to import 60 records from a CSV file. There are 4 fields per record: First Name, Last Name, Email and Source. When I choose Import Records... > File... from the File menu, everything looks good, 4 data points point to the correct field names: arrow icon "Import this field" but the rest are the double dots icon, "Don't import this field," and when I click on the Import button only the first record is imported. I don't use Filemaker frequently enough to remember everything but when I need it, I really need it. I do not remember having to go thru and changing every icon in the Import dialog to import this field, I thought th…
-
- 4 replies
- 1.9k views
-
-
I need to design a sales/purchase and product database to handle the following. Purchase order: record lengths of different shaped steel with cost price,description,quantity and length being the main titles. Sales : record sale price,description,quantity and length. The lengths sold are usually less than the purchased length. Product: to show full lengths along with any that have been reduced by sale. Example: 10 lengths at 6.00 mts are purchased and 2.00 mtrs cut and sold from one length. and 5.00mtrs cut and sold from another. How do I show that I have 8 full lengths at 6.00mtrs ,1 length at 4.00mts,1 length at 1.00mtrs? Any help with how to show the…
-
-
- 9 replies
- 873 views
-
-
Hi Guys, As i told in my previously topic, i new in FM. I working in a solution that i need user type a qty to populate a table. However i not getting create a input field to user type, i only able to create fields related with a existent table field? This is a FM rule, or i able to create a field to user type according your necessity? Thank you.
-
- 1 reply
- 572 views
-
-
I have a Filemaker Pro script which writes a text file in GPX format. The resulting text file works correctly when running on Filemaker Go (on an iPad or iPhone) BUT when the script runs on MacOS under Filemaker Pro 17, the resulting GPX file won't work correctly with several applications which use GPX. The file looks identical but just won't work. The file written under iOS on an iPad works fine after being transferred to MacOS. It appear that the same script creates a different file under iOS than under MacOS. The script uses "export field contents" from a single global record. I'm guessing that "non printing" characters like CR TAB LF may be the is…
-
-
- 12 replies
- 1.3k views
-
-
How complicated is it to migrate solutions written under FM Pro 14 to FMP 18? Will I need to rebuild them from 14 to 15 then 15 to 16 etc?
-
- 2 replies
- 836 views
-
-
I am trying to use a Global field as a variable to generate a look up list, (rather than creating separate CV table occurrences). I have set up Global Table (Table A) with the necessary search field and created a Table Occurnace for the lookup field (Table B). All works fine. Problem is the delay caused by the script trigger, (I've tried all the before processing triggers) which all seem to run after I have selected the dropdown object. i.e. the list displayed doesn't update until after I've selected, or clicked away etc... It occurred me that really I'm asking the dropdown to act like a button, so I've tried to set it up as a button to run the script immediatel…
-
- 8 replies
- 2.8k views
-
-
-
Hi, hope someone can help. I am a relative novice to Filemaker, so any assistance would be gratefully received. I am trying to develop a simple database where you have a startup screen which would prompt the user to enter a unique 5 digit number. Either by pressing return or by a scripted button, the user would be taken to a different layout with a record that corresponds with the unique 5 digit number. Just don't seem to be getting past this first hurdle. Again, many thanks for any response. Alistair
-
- 9 replies
- 1.1k views
-
-
Hey Guys, So we have a runtime solution (windows only at this time) , data and interface in single file (no data separation) and we have just changed all container fields that are accessible to the end users to now use external (open storage). The issue is when saving a backup i use a script to save a copy of the file as self-contained, when i "reformat" the runtime app to have no records and restore from a backup file via script all data is imported except for the container data. So the container data is not being embedded back into the fields as it should, This bug has been reported since as far back as at least FM14 and has persisted in every FM since …
-
- 2 replies
- 2.3k views
-
-
This is a problem I frequently have. I can't custom format a date in the Inspector. I can't make a selection because the drop down menu becomes a long vertical blue stripe and selections are not available. I wonder if this is a FMP problem or a Windows 10 problem. Does any one else have the same problem?
-
- 6 replies
- 924 views
-
-
I would like to know how to create a calculation: i.e. calculate the number of days since operation How do I create a calculation field which involves: Date of event and today's date. Thank you
-
-
- 1 reply
- 726 views
-
-
Filemaker 18 now has a popup requesting delimiter information when importing records. I have created a database which has been used for 5 years by my clients, It has an import record script which the user could just run and everything populated properly, after choosing the required file. Now there are shown a new popup and asked to choose delimiters. They now have to know which to choose and it is an extra step which is frustrating for the user. Is there any way to use a default delimiter as it is always the same type of file (tab delimited .txt) imported.
-
- 2 replies
- 1.4k views
-
-
When a field validation fails, alert is displayed then when clicking OK program freezes
-
- 5 replies
- 2.5k views
-
-
with filemaker 10 pro advanced I have a calculated multivalued that displays linked images. I checked "keep the proportions" and reduce the image. On screen in preview mode everything is ok ... ... but in print the picture is cropped what can I do?
-
- 0 replies
- 1.7k views
-
-
I have a field which has validation selected to only known values from a value list (populated from a separate field{Names} ) When I enter an invalid value or leave it blank, I get the alert dialog box from the field definition but then the program freezes and I cannot proceed. Valid values seem to work fine.
-
- 2 replies
- 1.4k views
-
-
Hi, I hope you having a wonderful day, Currently I'm traying to create a dashboard with Filemaker, the idea is show several portals and grafics of differnets databases but with specific criterias. The case that i'm trying to resolve is the next one: There are three database related, one is for clients, another is the contract of this clients (services) and the last one is client's tickets, so we have the next relationships: tickets DB ------ Clients ------ Services (I didn't create that DB distribution). The idea is show in the dashboard which tickets were created for clients who have certain services. The first thing i did was create a self join rel…
-
-
- 7 replies
- 1.3k views
-
-
Hello! Came over to this forum since FM screwed up the community, so feel free to move this post around if I have it in the wrong place! Is there a way that I can put a transparent button over the body of my list layout, but only allow it to be clickable of the user first clicks to make that record the "active" record? Essentially, they would then be able to click to make the record the active row but remain on that layout, but then a second click would direct them to the appropriate layout? Can the button only be shown when the listed record is active? If so, what would my "Hide object when" formula look like? Thanks for the help, here's to hoping this foru…
-
- 2 replies
- 1.6k views
-
-
I used to be able to host a limited number of clients with FMP. With FM17 it now says "The host's capacity was exceeded, try again later." and the file shows 0 clients connected. Is the only way around this to get FMP server?
-
- 5 replies
- 2.5k views
-
-
Good morning. I have a solution that generates a PDF from a series of tables, appending various pages to the report. Sending it via email is fine, even saving it to a fixed file location, but I am experiencing difficulty in being able to save it in a container field so the user should be able to click on it and view this PDF on the screen. How do I save this please? I don't get an error in the solution (or script debugger), it just doesn't appear in the field. Any suggestions please? Many thanks in advance too. Greg
-
- 6 replies
- 1.1k views
-
-
Here is the official link to the FMPA 18 Help: https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help/index.html
-
- 3 replies
- 1.7k views
-
-
FileMaker, Inc., Releases Enhanced Workplace Innovation Platform for Custom App Creation Latest release offers security, user interface and scripting updates to help organizations solve complex challenges SANTA CLARA, Calif. — May 22, 2019 — Today FileMaker, Inc., announced the release of the FileMaker 18 Platform, the latest version of its leading Workplace Innovation Platform. The release features a range of enhancements from an improved user interface to a larger offering of security controls. “The newest version of the FileMaker Platform helps you tackle your biggest challenges at work.” said Ann Monroe, VP of worldwide marketing and customer success at …
-
- 0 replies
- 1.1k views
-
-
I have this little app that uses google sheets as its base for the data. When the app starts, it runs a script that downloads via insert from url a google sheet and stores it in a container field. it parses it all out into fields etc. As you can see in the pic, the bottom line in yellow shows the current dance. done by comparing current time against another table via join. This value is derived by a InsertOnTimer script that runs every 15 seconds and flushes the join to keep current dance value at the top. My problem is, when there is a change in the spreadsheet (btw this is the clients choice of storage) I need another timer to run in the background that checks eve…
-
- 4 replies
- 1.8k views
-
-
Hello Friends, As such any script which can close the popover portal when a certain field have value ''No'' and if ''Yes'' it remains open. Popover portal is also open by script. Applying the following script steps but not succed Thanks
-
- 4 replies
- 1.7k views
-
-
I am stunned why I cannot get rid of the white space in a text field. I created a note window for my solution that runs in a separate window. I want to be able for the user to resize it as small as possible, the same way it can be done with the native TextEdit app the Mac. But even with the layout settings set to the minimum, I get this result, I cannot drag the bottom windows side higher: This is how the layout looks like: Any idea what causes this?
-
- 5 replies
- 1.4k views
-
-
Hi, Is there anybody here familiar with the OFBiz solution from Apache ? I have a customer who wants to migrate thier data from FileMaker into OFBiz and I am wondering if there is anybody familiar with exporting of FileMaker's data into OFBiz solution. After we import the historical data, I want to build additional scripts in FileMaker so when a new record is created, I export / import this new record directly into OFBiz. Just trying to get some insight how a script like this would be designed / developed. Thank you.
-
- 9 replies
- 1.1k views
-
-
How can I count the amount of lines in a text field? And is there a way to get a live update of the line count while typing in the field without it slowing down or interrupting the typing?
-
- 3 replies
- 4.6k views
-
-
How does one create a dashboard of different templates/layouts. for example, I am using the contact template and now would like to add Asset template. so rather than adding a new layout can we not import another template layout. New user, I am afraid hence the question so please be kind. thank you
-
-
- 2 replies
- 1.1k views
-
-
Can anyone describe how to set up a layout for center fed #10 envelopes?😠 FM help says that after creating the layout you must verify margins and other settings before printing. How do you do that? I've tried everything I can think of, but the script print step prints 2 or 3 envelopes when the print dialog is set to 1 copy. I've tried adjusting the header and body dimensions (by guessing), I've tried deleting the header and keeping the body, I've even tried just keeping the header. Everything looks normal in Preview.
-
- 3 replies
- 1.1k views
-
-
I have a table with about 100,000 records. One of the fields in the table is called "DecimalNumber" (type is "Number"). There are many records (perhaps 10 to 20%) which have the same value in that field as another. Sometimes only 2 records have common values, sometimes more. What I want to do is to delete all records except one of each of those which share a value, thereby removing 'duplicates'. How do I achieve this? I assume a script will be needed, if so please can you give me the whole of that script. Many thanks in anticipation.
-
- 5 replies
- 9.9k views
-
-
Has the recent Mac update broken filmmaker 16? I would love to move to 17 but the cost of hosting it on any of the hosting services is prohibitive. Is filemaker forsaking me and driving me to airtable?
-
- 5 replies
- 1k views
-
-
Hello Does anyone know how to change the cursor position in a Text Field from auto positioning at the bottom of the text to the top of the text? I have a running field where I make weekly entries, but the most recent is at the top but the cursor always starts off at the bottom. Filemaker Pro 12 Mac OS X 10.10 thanks Lonn
-
- 1 reply
- 2.6k views
-
-
I have a flat file database with only one table. However, I cannot not delete records. I get the error "This operation cannot be performed because one or more required related tables are missing". However, I can create records, just can't delete them. Obviously, I don't have a related table.
-
- 0 replies
- 1.3k views
-
-
I have a couple of questions before I take the plunge back into Filemaker after a long absence. When purchasing the annual contract can someone explain what a user is? Is it the number of people that can use filemaker at one time or does everyone that will want to get online need a separate licence? For instance would I need one licence when I access from at home and one from work. I might have many people sharing machines etc. Also there is a limit of "2 GB outbound data transfer per user, per month — tracked annually." What is this telling me? My databases will tend to be quite large as we use thousands of hi-res photographs.
-
- 3 replies
- 869 views
-
-
I want to build a filmmaker solution where multiple employees/users could be able to send text messages via SMS from their file maker database – does anyone know an efficient way to do this? Or what plugins or SMS services are available?
-
- 1 reply
- 915 views
-
-
Hi, My solution opens an Excel file and loops through 3 tabs in it, importing and processing the contents of each. What I really need to do is get the user to specify an Excel file (preferably by opening a script generated default directory and filtering to only Excel files...something I can't seem to get to happen) then, in a loop, import data from 3 separate tabs in the file (tab names are fixed but import mapping is different for the different tabs) and process that data. When I'm running locally I can get the input file name by using Insert File into a container to hold on to the file name and can set up the imports specifying the filename, tab, and import …
-
- 4 replies
- 2.1k views
-
-
I want "Continuity Header Calc" to take "Group_Header" if it exists. If it does not, take Scenes:Scene Header I tried making the calculation with this: If ( IsEmpty ( Group_Header ) ; Scenes::Scene Header {; Group_Header} ) But it gives me the error: "The specified field cannot be found" I think I'm missing something... Thanks in advance!
-
- 2 replies
- 1.5k views
-
-
Hi, i am trying to find a position of new window so that new window opens on each record's line. is there a formular that can give pixel position of an object ?
-
- 2 replies
- 1.1k views
-
-
Hi, i am having a problem when i try to set a transparent color for the portal. previous version - fmp 11 , i never had this problem. is it disabled in fmp 17 ?
-
- 2 replies
- 1.1k views
-
-
I'm experiencing an issue regarding on my database. Every hour 1 I see perform find popping even I just scrolling through records. I already check if there's an On timer script but nothing. This issue happens every day.
-
- 0 replies
- 738 views
-
-
Hi. I had a really weird problem last night that was pervasive through all files I was working on, served, local, and even a new file I created to try to test the issue. It was totally crippling and driving me crazy. I had gone into a script and selected the Go to Layout command, but when I tried to select a layout, none appeared, even though there were plenty of layouts in the table. I dismissed it as a temporary glitch and tried a Set Field command, needing to set a field to a calculation, and again, found the system locked up in such a way as I had never seen before. It would not let me enter a calculation! I closed and re-opened the file. No dice. I restarted Filemake…
-
- 2 replies
- 1.3k views
-
-
Is it possible to put the empty blank new record line on top of the portal view? Currently it shows up on bottom, and I'd love it to be on top if possible. Thanks in advance!
-
- 1 reply
- 1.3k views
-
-
These two filters work on their own: Edit Notes::Edit Phase Short Name = "EC" Edit Notes::Completed = 0 But when I try to combine them, I tried using "and" operator.,., maybe this isn't how you use the operators in the filter window, but I tried: Edit Notes::Edit Phase Short Name = "EC" and Edit Notes::Completed = 0 But then nothing showed up. there are most definitely records where those two things are true. I'm used to && from programming, so maybe I'm just not using it correctly in the filter window. SOLVED, nevermind... The fields were blank, not 0... My "most definitely…
-
- 2 replies
- 801 views
-
-
Using this for tv/feature film tracking. I have a bunch of scene card images I want to relate to scenes. I have an images database with just thje image itself and the filename (auto filled on import of folder) I have an images table because i want to us it for multiple things, such as SCENE CARDS, and also THUMBNAILS for each shot in the database. Scenes related from Scene numnber. Ex: 19.jpg (this would be scene 19. Scene "19" is stored in database matching that name) Shots relate from TAPE_NAME column in database. Ex: A003C003.jpg (would be TAPE_NAME A003C003) I'd like to see if there's an easy way to relate without having to du…
-
- 5 replies
- 1.4k views
-
-
I'm looking for advice regarding strategies for storing photos/scans within my database. Currently, I'm of the mindset that I would prefer to have a single 'container table' that is used throughout the database where needed. This table would have a few identifiers, which autofill based on where (as in from which layout, or where on the layout) the container is populated. Then, there would be a single layout where all photos/scans could be browsed/filtered/etc based upon those identifiers. First question, is this design good practice or should I reconsider my approach? Please note that for my purposes a container is not always necessary for every record (i.e. some re…
-
-
- 4 replies
- 1.1k views
-
-
Hello all. I am new to FM and have not worked with database in years when I used Access. I was wondering if anyone has a sports trading card database template? I have over 500,000 trading cards and I am trying to come up with a way to track what I have. Thanks for any help someone can give me.
-
-
- 5 replies
- 1.7k views
-
-
I am working on an inherited system. It was originally just a single file. I split it into the separation model by duplicating the interface file to create a data file and then repointing all the interface file TOs to the tables in the data file. The External Data Source is called DATA. It contains the path $$PATH.DATA Within File Options, the interface file is set to open on a temporary layout built from a table occurrence that has no relationships and no records From here I then set a value into $$PATH.DATA before heading to a layout that references data from this file. https://community.filemaker.com/docs/DOC-8174 This is the default metho…
-
-
- 14 replies
- 2.9k views
-
-
Hi, people! I'm pretty new here and in filemaker. I'm actually only helping my research group creating a database and have just started learning about filemaker. So what I need is a portal in a participant that will display the studies that exist and whether or not they are eligible. The problem is, I need a second page to update the studies, so once I insert a new study it should show in a new row for all participants. I did others portals that worked ok, but I'm having the problem in updating the study displayed in all participants. Does anyone knows how to deal with this?
-
-
- 3 replies
- 2k views
-
-
Hi everyone, hope you have had some experience with this one. I looked on the internet and tried solutions i found there to no success (I have also gotten my IT involved, who are unsure what to do). Our computers have Windows 7 on them, and it works fine (script that opens a new email in Outlook and populates with data...we then manually click the send button in that email to send). I was upgraded to Windows 10, and Outlook 2016, and have had issues immediately. The new email will pop up, and it looks like everything is fine. When I try to click send a "Server Busy" message will appear with "This action cannot be completed because the other program is busy. …
-
- 9 replies
- 5.4k views
-
-
Hi all, I have 2 repeating fields, Turnover last year & turnover this year, each with 12 repetitions. I would like to compare the year to date turnover with same period last year. EG If the current year has 3 months of turnover, the 3 first months have to be compared with the 3 first months of last year, and so on. So using the COUNT function, I can determine that 3 months of this year have Turnover. How can I dynamically make the sum of only the first 3 months of last year although all 12 repetitions cells have a value? I was thinking of using the let function to avoid a lenghty calculation, but I don't grasp how to make the recursion...…
-
-
- 2 replies
- 989 views
-
-
I can't get find a range of dates with a script. The following script is supposed to find the last 12 records on the layout. The Perform Find results in the error that the provided find criteria is not correct. Even if I use Enter Find Mode and insert the variables, I get the same error. What gives? Layout [ “Log” ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Log::Date; ascending ] [ Restore; No dialog ] Go to Record/Request/Page [ Last ] Set Variable [ $End; Value:Log::Date ] Set Variable [ $start; Value:$end-12 ] Perform Find [ Specified Find Requests: Find Records; Crite…
-
-
- 6 replies
- 4.4k views
-
-
Hi. I have a database that lists grant applications. I need for my user to be able to view the records in a number of ways according to certain criteria for analysis purposes. These records are displayed in a List layout. I need to be able to: 1) see only records where the submission dates are between x and y then 2) filter these records according to what is selected in 2 dropdowns - Outcome and Status. The Outcome field dropdown value list is : <blank>, granted, unsuccessful, unknown. The Status field is dropdown value list is: <blank>,submitted, in progress, finalised. The <blank> is where that dropdown criteria are not requi…
-
- 10 replies
- 1.4k views
-
-
Hello Everyone, I have an issue I'm trying to solve in a function. I have a join table that has 5 country ID's from a foreign table (UK, France, Germany, Spain & Italy), I want to look at the one that is France and read the value of certain fields in the record associated to France. How do I get Filemaker to cycle thru the country field until is finds France ID, then read the field value I request? So for clarity there is a join table that has 5 country ID's. And the thing is in that table that country can be there more than once, but only once in there for a certain product with a unique price for the product in that country. Example Join T…
-
- 12 replies
- 1.4k views
-
-
Sorry if this is evident as I am a new to FMP, but I haven't been able to find a 'how to' for this So I have some large data tables that I have uploaded from Excel to FM with Primary Key (pk) and Foreign Key (fk) fields. All the primes have UUID data. and I create the relationships. Now in order for it to work I have to copy the pk data in the parent table into the related fk fields in the child tables. It works, but is there an easier way to do this? The only way I can see is to do it manually which will take ages. There must be a better way that I am missing. Sam
-
- 2 replies
- 1.1k views
-
-
Does anyone know about a plug-in for Sales Force?
-
- 1 reply
- 726 views
-
-
I want to be able to import data from an Excel worksheet into a FM runtime solution. How do I open a runtime solution to set it up? How do I use the binder key? The runtime has a script to import, but from from the desktop. But apparently I have to place the Excel file in the solution folder?.
-
- 1 reply
- 993 views
-
-
Hi everyone, Is there anyone that can help me fix this problem? I created a 3-page report template that I want to use to print all the records in my database. Each record should begin on page 1 of the template, so that in printing record A will be pages 1 to 3, record B pages 4 to 6 and so on. However, when I print, at the bottom of page 3 I can see the beginning of the following record, which should be instead at the top of page 4. I hope you'll be able to help a beginner like me out! Silvia
-
-
- 3 replies
- 1.1k views
-
-
When I insert a Word file into FM17 Pro, all I see is an icon of the file. How do I display the file?
-
- 0 replies
- 747 views
-
-
Hello All, The attached file is the simulation of my excel worksheets. I have three (3) accounts Admin, John & Lola all the three (3) accounts has no password. In my layout "ReportsEquipmentTime", I want that If I click the "project x equipment" button I will see only the record of the current account that is login. The script that Im using is Set Error Capture [on] Allow User abort [off] Set variable[$_columns; Value: ValueListItems ( Get(FileName) ; "Equipment" )] Set variable[$_rows; Value: ValueListItems ( Get(FileName) ; "ProjectCode" )] Set Field[Users::RELOGIN; Get(AccountName) Enter Find…
-
- 4 replies
- 1.2k views
-
-
Filemaker Pro 11 is running on two Windows 10 computers connected as Host and Client over a network. The script to import data from an Excel .csv file utilizes the following script step options: 1. Un-Checked - Specify data source - File 2. Check - Specify import order, Import Action a. Select - Update existing records in found set b. Check - Don't import first record (contains field names) 3. Check - Perform without dialog When the Import script is run from the Host computer, and the desired .csv file is manually selected, the Excel first row field names are not imported and the second row with the data is imported as expec…
-
- 0 replies
- 2.1k views
-
-
Hi there - I need to create a simple crosstab report and wondered if filemaker 17 has this functionality built in ? If not can somebody point me in the right direction on this please. It would be very much appreciated. Also once ive created a series of reports how can i combine them so they appear at the press of a button in a single document ? Any help would be much appreciated. Peter
-
- 5 replies
- 2.3k views
-
-
I have a runtime solution that was created in FMP 12. This no longer works on High Sierra or Mojave. My iMac just gave up the ghost , but Mojave would not have run on that machine anyway. So Instead of sinking money into a new Mac, I am looking to see if there is anyone here on the forum that I could hire to render the runtime for Mojave (from the previous fmp12 file), do a simple runthrough to verify that everything works well and then create an installer package/DMG to get me (and my customers) back up and running. Thanks for your time and consideration!on in this matter
-
- 0 replies
- 1k views
-
-
FileMaker 17 is launched with the purpose of letting the users do more without spending much time. The new version also works towards its goal of letting the users do more with the FileMaker platform while they are on the go. To know some of it's most popular features read this article. https://www.metasyssoftware.com/blogs/filemaker/5-popular-features-introduced-filemaker-17
-
- 0 replies
- 1.2k views
-
-
Band Solution Design I am trying to create a filemaker solution for my band. I have been unable to find a pre-made solution that does everything I want, so I am going to try and create my own using filemaker. I am looking for advice on what tables and structure I should use, before I start. Entities Band Members - I need contact info and a history of money I have paid them from any gigs Clients - People that hire us for gigs. I need to send them a press kit in hopes of getting hired. Invoice them, and send a receipt. Fans - Marketing to these people , email, text, social media, etc. Can a fan also be a…
-
- 3 replies
- 1k views
-
-
Hello -- I would like to open pdf files that are stored in a secure external manner. Only the first page of multipage files show in a FM container window (if I';m not mistaken) so I am wondering about using Preview (Mac, of course). I can retrieve the file path to the secure file by processing the text output of the container file, and then use it as a variable filename in a Send Event script step, but Preview cannot open it. Any suggestions?
-
- 5 replies
- 6.6k views
-
-
I chose to suppress the SSL warning for a given host in my FileMaker 16 Pro Advanced. Which file can I edit or remove for FileMaker to forget that I chose to suppress invalid SSL warning?
-
-
- 1 reply
- 2.2k views
-
-
In my opinion the FMP "Launch center" just destroys some more FMP user friendlyness. What could have been more friendly than being able to have the solution start file shortcut on the windows desktop. But Nooooo, from v14 on we must have a launch center whether we want it or not. What was wrong with FMP "Quick Start" and the option check box to "Show this screen when Filemaker Pro opens". How about adding a check box the the launcher to "Show this screen when Filemaker Pro opens". Or, how about a workaround to disable, bypass or delete the "Launch Center". Is this at all possible?
-
- 4 replies
- 3k views
-
-
After my Windows 10 based Filemaker Pro 11 MarinaPro Solution is launched (Path = C:/MarinaPro/Marina.fp7), I need to create a variable ($$source = filewin:/C:/MarinaPro/ResScheduler/) to a revised default "Open File" path. Because I need to select from several reservation request attachment Excel .csv files, placed in the ResScheduler directory by an Outlook 2010 Macro, my "Import Records" script is set with an "unspecified" data source. When my script is activated with Error Capture "Off", I get the obligatory Filemaker Pro Error message, "The file <unknown> could not be found..." and the "Open File window is still set to "Look in: "MarinaPro" (Default). An…
-
- 8 replies
- 3.8k views
-
-
I know. Don't use them. But There is a simple task and a repeating field would be a quick solution. Field 1: a number Field 2: a calculated repeating field, each repetition adds the repetition number to the value of Field 1. Can it be done? Thanks
-
-
- 2 replies
- 2.5k views
-
-
I am beginner to use Filemaker pro, I Created visitors system how can getting data from reader (HID Omnikey) to fill the fields automatically like first name, middle name ,and ID Number (Emirates ID). how can make script for this issue? Could you please provide me course training for this matter ? note: i am live in untied Arab Emirates
-
- 0 replies
- 1.2k views
-
-
Hi, I am looking to move some functionality away from BaseElements (4.0.3) and into Filemaker Pro's native functions. There are three functions that are used that I need to migrate. Could somebody please help me 'translate' the following line away from using BaseElements (BE) and into Filemaker's own functions? 1. BE_HMAC_Deprecated ( $queryString ; $$_API_Key ; BE_MessageDigestAlgorithm_SHA256_Deprecated ; BE_Encoding_Base64_Deprecated ) As I understand it, the new function would be: CryptAuthCode( data; algorithm; key) yet the BE function has four parameters, and Filemaker has only three, and I'm not sure how to "translate" the third and fourth …
-
- 0 replies
- 806 views
-
-
if we want to develop a solution that runs locally on the machine and we want to sell them we should give them the solution and client must have FileMaker full version which the client has to buy. But many clients aren't having FileMaker installed on the machine, is there any solution for this problem to run solution full-fledged ???? apart from making runtime which has restricted functions hope u got my point
-
-
- 3 replies
- 747 views
-
-
Running FileMaker Pro 16 Advanced on a Mac (NOT Server). I currently have some databases set up to send data to a third party software to create barcode files. Data is imported into FMP and there are buttons that activate scripts. Everything is working fine. My understanding is that FMP talks to the other software via AppleScript. However, I may need to switch my third party solution and I cannot find anything that will do what I want via AppleScript. A few claim to work via Automator and one other seems to work via "Command Line" input. My question is - can I send Command Line instructions from FMP 16? I have searched this forum and the internet in general and…
-
- 4 replies
- 2.3k views
-
-
I have a field that holds names, normally four names separated by commas. But right now they are aligned like this: John Doe, Jane Doe, Billy Doe, Jo Doe I need to have them listed on one line such as this: John Doe, Jane Doe, Billy Doe, Jo Doe I tried importing from a CSV and an EXCEL sheet and it still comes out vertical. Any help would be appreciated, thank you.
-
- 6 replies
- 2.4k views
-
-
Is there a way to calculate only the first row of a table? thank you in advance
-
- 3 replies
- 1.3k views
-
-
I've updated my computer from Windows 7 Pro to Windows 10 Pro. My FileMaker Pro Advanced 11 does not launch. I get the message "The application has failed to start because its side-by-side configuration is incorrect." What's the solution for this issue? Update: I clicked on an fp7 file, and then Windows asked me to insert the FileMaker CD, which I did. Some files were quickly copied over, and everything works fine now!
-
- 0 replies
- 2.5k views
-
-
I work a lot with multiple windows open on the same Record. Something that is driving me mad right now is; I have a Field open in one Window and I try to edit the same Record in another Window. But of course I get the Record Locked message. Because I have multiple Windows open I have to go clicking through all my open Windows to release the Record - which is very irritating. I thought of making a Script containing the Commit command which I could quickly run with a Command-[Number] keystroke. But Commit only works on the frontmost window. Is there some workaround that would let me Commit the Record across all of it's open Windows?
-
- 5 replies
- 1.1k views
-
-
Hi, Good Day! I'm quite new to the world of FileMaker, I have a database file fp7 whilst trying to update its contents i get ODBC error. File is hosted by filemaker 7 server. I was able to get that file unprocted still i cant update contents. ScriptMaker and all other features are greyed-out. At this point i have no clue - could you please help me. Thank you kindly. // KSN
-
- 4 replies
- 3.5k views
-
-
Hi I have been provided several .fmp12 files with the intention of making searchable to the public via a website. My initial post was at (linked) which got me to this post. My plan is to export the data as csv, create tables on the website database and write a search form to interrogate those tables. Is this the best method for getting filemaker databases on to the web? The original owner of the files is using FM12 on a likley old Mac OS version. I am on Mojave hence using FM 17 Trial as FM12 does not work on my OS version. A couple of his files contain images for each record, he is using Layout: Input. Exporting directly from this view does not give me all…
-
- 2 replies
- 1k views
-
-
FYI I tried to add this to the Filemaker community page but don't think it worked hence adding here also. I have been tasked with creating a website for a charity, part of the website will be a searchable archive of all of their historic data. This data is stored in Filemaker Pro 12 on the historians machine. He has provided me with 4 .fmp12 files, I downloaded a trial version that I found here http://www.filemaker.com/redirects/ss.html?file=PRO12MAC however none of his files will open. The website runs on Wordpress which is php based, the database is a maria database although I am happy to use whatever method I need to get this data on to the website and s…
-
- 6 replies
- 2.4k views
-
-
I am getting a value from a plist file and I am trying to update the value of a field in a FileMaker Pro table. The script read the plist files correctly but the field does not get updated in the FileMaker Pro table. Would anyone have an idea why set _EventNo to field "EventNo" of table "Preferences" does not work? Many Thanks! tell application "System Events" tell property list file ("Volumes:NX5U:NX5U.plist") tell contents set _EventNo to {value of property list item "EventNo"} end tell end tell end tell set _EventNo …
-
- 2 replies
- 864 views
-
-
Hello, I've been doing some search on how to Get the content of a plist file within FileMaker Pro and the only information I am getting are links on "Where is FileMaker plist preference path located". I have been able to perform this action in using "Perform AppleScript...." Are there another way then using "Perform AppleScript"? tell application "System Events" to tell property list file ("Volumes:NO NAME:NX5U.plist") set value of property list item "EventNo" to "44" end tell Many THANKS!
-
- 1 reply
- 1.2k views
-
-
Hi everyone, i'v got many copies of a Filemaker DataBase. There is many changes week after week in this file put the tables are the same. I would like to count for example how many records i have week after week. For example starting month with 10 000 records, next week (another file) 17 654, next week (again another file) 18 765. So your doing this i set in external data source, changing with a loop so i have $$path for example, then open template but data or not changing. Maybe it's not possible to refresh the template even if the datasource changing ? The template is set with a table from the external data source Don't know if it is c…
-
- 2 replies
- 809 views
-
-
I decided to install the Mac Mojave OS (10.14)...BIG mistake! I found out too late that my FMP 14 files would no longer work. I reinstalled Mac OS 10.13.6, only to find that my FMP application files were no longer in my Applications folder. I dug out my FMP 11 Advanced, and my FMP 14 Advanced updater and reinstalled them. This seemed to go smoothly but, when I tried to open any of my FMP 14 files, I was met with two error messages as follows: "The document “11/14 MASTER copy.fmp.12 could not be opened. Filemaker Pro Advanced cannot open files in the “Filemaker Pro Advanced.app document” format." and "This application has been installed incorrectly or m…
-
- 0 replies
- 2.1k views
-
-
I have a customer that has 3TB of photos in the program Picasa. They use it to edit images and then put some in Filemaker. Currently the images are on a NAS. The problem is it seems to be getting slower and slower. Picasa is discounted so I'm looking for a replacement that can handle the large amount of images they take on the job site and interact with Filemaker, seamlessly. they run on a windows platform but would like to perhaps introduce iPads to the mix in the future. Not sure if this is the right place to post this question but I thought I'd give it a go. Any guidance on the matter would be greatly appreciated.
-
- 3 replies
- 1.7k views
-
-
Hello I am integrating with Apple's GSX API's, and one of the functions allows you to download a PDF of a 'DepotShippingLabel' which we need to send faulty parts off to Apple. The data is sent as an application/octet-stream. I have tried saving that data into a FileMaker field, and then using 'Export Field Contents' to a path that resolved to Get ( DesktopPath) & "mypdf.pdf" However, the resulting file is not recognised by Preview or Acrobat. Does anyone know how I can convert this type of data into a usable file using Filemaker (or an custom/plugin functions)? I can't post the whole data here as it contains sensitive data, but below is the begin…
-
-
- 3 replies
- 9.1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online