Jump to content

Search the Community

Showing results for tags 'pc'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
    • Product Ideas
  • Productive Computing Support Forums
    • Visit Productive Computing
    • General Discussion for Productive Computing Products
    • Core CRM Solutions
    • QuickBooks and Accounting Plug-ins
    • Contact and Calendar Management Plug-ins
    • FileMaker Utility Plug-ins
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • 360Deploy
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • FileMaker Vendors
    • FM Starting Point - By Richard Carlton Consulting
    • Monkey Bread Software (MBS Plugin)
    • SyncServer Pro by LinearBlue
    • Comm-Unity Networking Systems (CNS)
    • SmartPill PHP Edition
    • FileMaker Plug-Ins
    • Accounting Solutions
    • FM Easy Suite Framework
  • FileMaker Training Resources
    • Professional FileMaker Training
    • ISO FileMaker Magazine
    • FileMaker Developer Conference
    • User Group Central - Sponsored by FMPug.com
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins

Found 276 results

  1. Good evening people. As the title states, I am a complete newbie to FileMaker Pro. I've done some fairly extensive work with Excel, but this is my first experience with databases. For now, I'm looking for advice and suggestions. I promise I will have plenty of "how do I... " questions later, but for now I need to pick a direction to go in with my new project. I've spent a bunch of hours viewing Intro to FileMaker tutorials on YouTube and I've experimented with creating a couple test databases. If this is not the correct forum for this question, please let me know. So, my wife and daughter are heavily involved with riding horses. I've been drafted into being on the Board of Directors for our state Quarter Horse Association (Quarter Horse is a breed like Thoroughbred or Clydesdale). The first thing I discovered is that they have NO association membership database of any sort. What they do have is simply a file folder of applications for members, one folder for each year. Me being an I.T. geek by trade, I know there is a better way. I've at least entered the info into a spreadsheet (my specialty) so we have the info electronically to be able to reference current membership status during our shows. I wish to create a database for the membership, which I've done so far. It has basic info - name, address, etc. I have an ID field that automatically increments with each record - seems to be a strong recommendation in the tutorials I watched. I have a field that combines the first & last name fields which I plan on using for looking up membership info, sending renewals, etc later. I also have a membership year field and here comes my first question. When I renew a member for the new year, I want to keep the previous year's record in the database - should I ever want to print a report for 2016 membership in 2019 for instance, I can. So I figure I need a static member ID field that is separate from the record ID field I already have that can be linked to another database which will hold that member's horse information. Is it possible to have a field that will increment serially when I add a new member but will copy from the previous year's info when I renew a member for a new year? I'm looking for any and all suggestions - links to videos that might help - suggestions for a better way of accomplishing my goal, anything at all. I'm not a programmer so I don't have that background FYI. Thanks! Jon
  2. Hello, I am using l am filemaker 15 pro advanced in windows 10 computer (64 bit, 8gb ram). I buy it few week ago and i converted my database from the old version fm5. The database work properly but it is very slow to open, about 60 second or more. I am working as standalone (no remote connection). I noted thta if the PC is offline (no network or internet connection) the database open in less that 6 second. It is very strange because I have not any ip configuration and any sharing option... what can be the problem? Thank you in advance Vincenzo
  3. Hi, I'm importing records and have a date field that i need to use to set my Fiscal year, month, week based on the fiscal year starting February 1st and ending January 31st. Any ideas or sample i might be able to take a look. Thanks in advance.
  4. SaveAsPDF corrupted font or layout ?

    LS, We recently migrated from FM14 to FM15 and suddenly some invoices come out strange after the saveAsPdf script step . ( see pic ). When in preview mode everything seems to be ok and is printed to a printer ok. Theme : Classic, Font used : Calibri size 11 and 12. Problem occurs on Mac 10.11 and Win10 with FM15. When I do a print ( to preview ( mac )) and then save as pdf everything is also ok, so it seems to be related to the FM pdf renderer. However, not every invoice has this issue, but I wonder how data could cause this behaviour. Best regards !
  5. Hello, I'm very new to this program and need some assistance in creating a database. I've been watching Guy Steven's YouTube videos and I've learned as much as I could. I'm trying to create a "table" (where I can list specific medications) and a "checklist" (descriptions with "completed" buttons on each end of each row) in a section of my layout where I've created multiple tabs. I'd like to create a table under "Medications" and a checklist under "Checklist". Would anybody be so kind to give me some pointers? I've never worked with databases before so I'm learning everything on my own via the internet. It'd greatly be appreciated. Thanks in advance, Briana
  6. The environment is Windows Server 2012, with FileMaker Server 13 v1x64. I've got a script that sends out an e-mail to multiple recipients. When I run the script through FileMaker Pro 13, it sends the e-mails with no issues. However, when I schedule the script to run, it fails. I had the schedule send me an e-mail after the task was done and got this: Looks like 1506 is an SMTP error, but I have no idea why it's failing when it's ran from the server but not from my local desktop. Any help is appreciated.
  7. I'm upgrading a solution from FM 8.5 to FM 14 and moving the server from our LAN to a Hosting Company (we will have a stand alone server). One of my tables has a folder associated with it to hold documents. (See Attached File, uses a webviewer to display the documents folder and send event to create it.) This has worked well for me for years and will continue to work IF I want to leave these files on our LAN. (Why I posted example file, someone may find it useful.) I do not really want to leave these on the LAN. I want to move these "into the cloud" and need advice for the best way to do this. I have considered using container fields for these documents (and maybe I will) although it seems to be overkill for what I really need. I have also considered using php and a webviewer to create/display/upload documents to these folders. Is there another solution I should look at? Should I avoid containers? (Have found them buggy, unreliable, and hard to maintain in the past but have not revisited them in a few years) Thank you in advance for any thoughts on this matter, Allen DocumentStore.fmp12
  8. Hi, How to create new record from the popover button? I have customer layout which has City field with drop down selection, I want to create a popover button beside so that user can instantly add city incase the city is not listed on the dropdown list. It has table relationship as well. One to many relationship with One for City Table ( CityID - Primary Key) and Many for Customer Table ( CityID - foreign key). Please advice, Thank you.
  9. I have been using FM starting Point and Filemaker for sometime although I would characterize myself as still a beginner. I have been searching for a long time for a way to insert a line into the middle of an invoice table. I wish to use the line as a seperator for groups of items invoiced to one customer. I would prefer to do this rather than make one invoice for each group. This is easy to do as I make up an invoice but I can find no way to insert a line after the fact. Yes, I could export the invoice to a .pdf or Microsoft Word and edit it there but so much easier if I could to this within Filemaker. Is it possible to do this in the data entry layout?
  10. pc Building for WAN

    Hi there, We're using a FM database through an externally hosted service (triple8) which is accessed from a number of locations across the country. I currently have a situation where we are viewing a report that can contain 1200+ records in a filtered portal and each time the filtered is triggered it can take as long as 30 seconds for the screen to refresh and scrolling down the list is painfully slow. I've tried a list view instead and performance for filtering is improved significantly but scrolling down the list is still slow (not as slow as the portal though) - the issue is viewing it in list view poses a whole heap coding challenges as we have a parent child setup (similar to an invoice - invoice line items setup) We find we often have performance issues when viewing lists and portal - Particularly if they use related fields, contain large record sets eg. 1200+ records in portal or unstored calculations, or are filtered and sorted. I understand that a fundamental concept of using a database is to avoid data duplication ie. using a primary key to view data from other tables. Considering our situation I find that performance is significantly improved when I DO duplicate data ie. use a lookup or autoenter calc field to duplicate data that will be viewed in list views, portals etc. eg. duplicating product descriptions in invoice lines etc I understand that doing this will increase file size considerably, so are there any other options to improve performance without bloating our database unnecessarily?
  11. This is a straightforward plea for advice. The Win7 terminal where we installed FMS in 2011 is finally not up to the task - after the recent updates to IIS and ARR (and FMS), it opens and hosts my databases but refuses to serve the XML feed that powers one page of our Web site. It was always underpowered, so I don't have any complaint. When we put it in, this was an experiment, so we didn't pay much. After four years, though, the library director is convinced of the value of the product, so we're looking for a new terminal that will run FMS 13.0 v5 today. We're still a public library, which means we don't have a ton of money, and our needs are relatively modest (by the standards of Web publishing). The variables: I'd love a price range of $500-$800. This is a Windows environment. I have a rack and would like a rack-mounted solution (but could use a conventional CPU chassis instead). My 'normal use' scenario will continue to involve about ten clients locally running FMP, and FMS also publishing one XML feed. Likely future use involves five licenses for FMGo (for library staff on their personal portable devices). Possible future use includes a couple of licenses for Web Publishing (so library staff can do outreach in public places). Possible distant future use (2-3 yrs?) includes a proper custom web publishing public interface (where patrons can register online to participate in programs). What hardware do you recommend?
  12. What I want to do is paste the contents of a portal into a text field. (A pretty good analogue of the intended use: I want to send an email to program participants who have requested it; whether they're attending one program or thirty, I want to let them know.) A couple of years ago, in a solution tracking budgets, I wrote a version of this that worked but used the system's Copy & Paste functions. Having defined the portal as BUDGET_PORTAL, I wrote: which worked fine (worked well, in fact) - but used the system's clipboard, which isn't desirable. Looking for advice for accomplishing the same thing via Insert and Get commands. I thought I had it with the GetLayoutObjectAttribute function, but it seems to want me to define content downstream of a given table, which I don't understand.
  13. Last week I did the FMS upgrade from 13.0.4 to 13.0.5, and my database has stopped providing an XML feed that worked for a a few years (and that powers one portion of my organization's Web site). I'm going to append all the information that might be pertinent. First, what I've already done: - I've Edited Deployment, asking it to enable XML. (First asked it to turn off Web Publishing, then a second pass to turn it on again.) I've then gone into Web Publishing and asked it to enable WebDirect and PHP (just wondering is that would kick-start a process). - I've run iisreset /noforce from the Windows command line. - I've rebooted. Also, I have a static IP on this machine, but in its interface, it provides what looks like an internal IP address. The next thing I guess I'll do is call support and/or reinstall, but I'm posting this to ask for related wisdom. I will mention that since we moved into a new building a few weeks ago, I've been haunted by connectivity problems - some folks get kicked off a couple of times an hour. I think that's an internal problem related to hardware/cable (since I was able to connect remotely from home and remain connected for 24 hours), but I mention it here in case it seems germane.
  14. Sorry If this is a little basic, but I couldn't seem to find a straight answer on this. If I have developed a database with FMPA 13 can I host it using FM server 11? If it does work, does it need to be accessed with FMP 11 clients or FMP13 clients for all functionality to work?
  15. I am running FMS v11.0.2.217 Users are running 10.0 v3, I just realized a few are running 10.0 v1. Server is Windows 7 Pro SP1 In the last 30 days, 2 different times, When Windows Updates were applied, I am unable to log in to the database from all computers. The first time, I had to rebuild all the databases and restart all the PCs. The second time, All the PCs were restarted and can access the databases, but the server itself cannot login to the files. Here is the error I get on the server (note, no other users are affected): Problem signature: Problem Event Name: APPCRASH Application Name: FileMaker Pro.exe Application Version: 10.0.3.303 Application Timestamp: 4a3ad6bc Fault Module Name: ntdll.dll Fault Module Version: 6.1.7601.18247 Fault Module Timestamp: 521ea8e7 Exception Code: c0150010 Exception Offset: 0008482b OS Version: 6.1.7601.2.1.0.256.48 Locale ID: 1033 Additional Information 1: 65ad Additional Information 2: 65ad32e6764235fd8ab502cb31467ec6 Additional Information 3: 7b91 Additional Information 4: 7b912993949a407ff6fd5159679aa61a Any input that can be provided would be helpful. Thank you. David Stark / Anchorage AK
  16. [FIXED] I found where some additional port forwards of the same ports were pointing to a 2nd machine on the network. Turning those off fixed the issue. I am unable to get non-local remote clients to see any of my hosted databases. LAN clients can see and connect to all. I'm running FMS 13.0.5 on Windows Serve 2012 R2. Currently I have ports 80, 5003, 16000 & 16001 all open. Windows firewall is completely turned off (even at the services level). Bonjour is running correctly. I found this page: http://help.filemaker.com/app/answers/detail/a_id/5493/~/cannot-see-hosted-database It states: If you host FileMaker Pro files from a server with two or more network cards,(which I am) FileMaker Pro broadcasts only from the card with ID 0. I don't know what "ID" it's referring to, but I have gone as far as uninstalling the second network card on the server. No change. In any case, it is broadcasting just fine to all LAN clients, just not over the internet. I have also made sure that all system clocks are synced.
  17. Hi there I'm quite new to FM and come from a SQL background, and am struggling here a bit... I'm looking to run an ExcuteSQL command on a table which contains values for many customers. Each set of values per customer on my source table has their customer ID and in turn this is related to the customer table. I need to create a portal on the customer layout, based on the value table, using ExecuteSQL. I need to use ExecuteSQL to enable dynamic variables based on user input which will filter the results in the portal, producing average, maximum, minimum and so on. ExecuteSQL (" Select max(FTE) from Values where Type =?";"";"";GlobalFields::GF_Types ) The query above reviews ALL customer data on the value table and instead of the maximum value for the customer who's record is currently open, I get the maximum value for the table overall, which is no good to me. How do I filter this to behave like the portals usually do, displaying information relating only to the parent record being viewed? Any help gratefully received. Thanks
  18. I just installed a fresh copy of FMS 13 (updated to 13.0.5) on a new server running Windows Server 2012 R2 Standard. Everything is working fine except for the "Perform Script on Server" function. When it is called for the first time from the client, the script engine on the server hangs and then times out with the log entry: Client "[script name] (Filemaker Script)" no longer responding; connection closed. (51) After that, any attempt to call "Perform Script on Server" receives the error message popup "Host's capacity was exceeded, try again later." The script being called to run on the server is 2 simple steps 1) Set Variable and then 2) Exit Script. No Plugins are being touched. Windows Firewall is completely turned off. There is only a single client connected to the database.
  19. pc FileMaker 12 Server where to buy

    Does anyone know when I can buy FileMaker Server 12 ? I'm currently on version 11 and want to upgrade. Can some please help me out? Thanks, John
  20. I'm having trouble using an iSCSI drive as a place for backups. FMS13 sees it as a remote volume, not internal drive. When I attempt to "verify" the path to the D: folder, nothing happens. Can't verify, can't save. I can only revert. Essentially I have the server software on the C: drive and I want to use the D: drive as a place for backups. Has anyone out there been successful using an iSCSI drive for nightly backups? I have verified permission on the folder on the D: drive that I want to use as storage. FMS13.x.5, Windows Server 2012 Thanks in advance
  21. Frankly I did know in which section to post my question. It's related to fm server, fm go, scripting, etc. I currently have an update system for my fm go solution that works like this. 1. User syncs his data . 2. User downloads an (almost) empty version of the database that is stored in a container field of an another hosted database. 3. User syncs to get his data. This works well except that the full sync process at step 3 can take too much time since the user will have thousands of personalized records across many tables. What I would like to do is to replace the database that is stored in the container field by a version of the full database that will contain the user data. For example, the script could make a copy of yesterday's backup, strip down the data to include only the data related to the user and store the db in the container field. That way , when the user syncs at step 3 it will only have to download the data of the last day. Any Idea how to proceed ? I tried different things but so far I have had no success at all updating the container field with a server's file in a script that is launched by the client. I tried perform script on server and it did not make any difference. Anyway I will take any advice :)
  22. Hello, Currently I am having an issue displaying remote container fields with interactive content (PDFs) on an FMS 13 Server box. JPEGS/PNG display just fine. To describe the issue in detail: A local database will display the interactive PDFs in a remote container field. When the the database is hosted with FMS 13 the container field displays an IIS error message. IIS (v7) hosts a website that is unrelated to this database I have stopped the websites hosted with IIS without any success. Has anybody encountered anything like this is before? I will gladly describe in more detail if the information is insufficient. -B
  23. I'm trying to implement d3.js graph to filemaker project The graph which I'm trying to implement is http://bl.ocks.org/tjdecke/5558084 So I'm trying to implement that heatmap to Filemaker webviewer. And create data From Filemaker calculations, so do you have any ideas how? I have already created table which has javascript libraries & css, these are global fields. In the example it using tsv as data file and I think it needs to change as javascript array instead, which with filemaker calculation I will create the data. And that's what i'm struggling with.
  24. Hi, I'am installing filemaker server 13 on turkish windows. Admin console remain in the first step and will not proceed. But when installing filemaker server 13 on english windows, admin console is running and can go to the next step. Is there a solution for installation on Turkish windows ? Thanks.
  25. Interesting case: - FMS 13 on windows Server 2008 - Occasionally (apparently near same time a back up runs (not progressive) FMS goes unresponsive, unable to open files, unable to access via XML CWP and WD also. - FMS is accessed via Clients, WebDirect and XML CWP at the same time. - Windows logs do not show any funky activity - I have seen It 'Appears' when a script is running (previously scheduled) and a backup run at the same time FMS hangs. Restarting fmsServer and AdminServer fixes the issue. Has anyone encountered an issue like this? Charles Delfs
×

Important Information

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