All Activity

This stream auto-updates   

  1. Past hour
  2. One of the most important and wide-reaching updates in FileMaker 16 is the ability to set cURL options in the Insert from URL script step. This allows FileMaker to natively integrate with innumerable services across the web, including Google Calendar, Google Maps, Microsoft SharePoint, and many other services. FileMaker cURL Options David Happersberger dbservices.com
  3. You make it really hard to help you. Whether you want to use portals or not is totally irrelevant at this point. You first have to articulate what it is you want to do. Saying "something like CDBABY" is meaningless to us, and so is posting only screenshots without explanation. The only thing we can do with that is infer meaning and make assumptions about what it is you want. We shouldn't be making assumptions to help you; you need to explain exactly what it is you want to see and exactly what you should happen when the user goes through your UI.
  4. Today
  5. I Said, sir, I don't want use portal and I want to do something like CDBABY
  6. I have no suggestion because you have not explained what you want to achieve and why. Start by explaining what the UI should do.
  7. Hi @Wim Decorte, So what is your Suggestion? If I don't what to use portal in this project
  8. Why don't you explain how CDBABY works or what about it that you really like or that your users expect? Pretty sure that repeating fields are not going to be the answer.
  9. So, sir, I don't want to use portal how can I do this work like CDBABY?
  10. So I am new to EasySync, and trying to get the best from it. I am using it more to replicate a subset of a live database for external clients to access, but they will not be changing anything, so my only requirement is to pull data to my 'Mobile' dataset from my 'Hosted' dataset. At the moment the live database is approx. 120k records, but this grows daily between 100 and 300 records for the main customer view, and possible 3 times that for associated activity. I seem to have a serious speed issue, in that trying to sync the mobile version just locks everything up, trying to do an initial sync. I can manually pull the data over at the end of a day, then mark all of these as EX_Exclude 1 and import them manually into my new portal Set a OnCommit on the maincustomer view, so any changes will make the ES_Exclude to 0, thus marking these for sync Question 1: How do I set these back to 1 once the sync is done? Question 2: Is there a way to Schedule the sync to happen every 15 minutes so it has lessto sysnc, meaning less traffic? Question 3: If I cannot schedule it, how do I prevent the 2 database's from appearing to lock, preventing users from working on either side, or slowing everything down? Any help with this would be very appreciated as I am totally stumped at the moment.
  11. What makes you think a repeating field would provide a better user interface - or better anything - than a portal? (I am afraid I did not understand your description, but I am not sure it's important that I do.)
  12. Hi, I solved my last problem but now I want to have a better user interface. we use the portal to show which filter used on machines like this. But now I don't want to use portal I want to use repetition field but if I do this work I have problem with user interface because when user press add new button other fields must go down like CDBABY picture
  13. I've added a new set of instructions for Let's Encrypt SSL Certificates with FileMaker Server for Mac.
  14. Looking for instructions for Windows? Click here! Let’s Encrypt is a non-profit certificate authority with the mission of spreading the SSL love across the internet. Though they’re not officially supported, we can use Let’s Encrypt to get free SSL certificates to use with FileMaker Server. We will use a Bash script and a LaunchDaemon to retrieve and automatically renew SSL certificates through Let’s Encrypt to make sure our connections to FileMaker Server are secure. With this, there’s no reason anyone should have an invalid SSL certificate on their FileMaker Server deployment! Requirements: FileMaker Server deployed on a Mac server – Tested with OSX 10.11 but may work with other versions. The “FileMaker Database Server Website” page must be reachable through the public internet using a web browser at the address you wish to get an SSL certificate for, such as http://myserver.mycompany.com. This means opening or forwarding port 80 in your router, firewall, or security groups. We use the Let’s Encrypt HTTP verification challenge, so we must make sure that Let’s Encrypt is able to reach our FileMaker server through HTTP. Warning: FileMaker does not list Let’s Encrypt as a supported SSL vendor and usually alerts the community that non-supported SSL vendors’ certificates won’t be able to be validated by FileMaker Pro and Go. I believe we’ve solved this issue with this solution. We’ve had no problems with validating these SSL certificates with FileMaker Pro 13-16 but of course can’t make any guarantees. FileMaker Go 15/16 also seem to validate everything correctly, though FileMaker Go 14 can’t connect. Please post in the comments section below if you have any issues using these SSL certificates. This is an experimental script and procedure. Please proceed with the use of this Bash script and Let’s Encrypt SSL certificates at your own risk. Here’s a summary of what we’re going to need to do: Install Homebrew Install Certbot Edit the GetSSL.sh file Run the Bash script Change the FileMaker Server SSL Connections settings Set up a schedule to renew the SSL certificate 1. Download the GetSSL.sh Bash script First, you’ll need a copy of the GetSSL Bash script. Download the file using the link below and save it on your server where you’ll want to get the SSL certificate. Warning: This is an experimental script and procedure, and SSL certificates from Let’s Encrypt are not officially supported by FileMaker, Inc. Please download and use this script with the understanding that it comes with no guarantees or warranties, and that you are doing so at your own risk. Blue Feather, Let’s Encrypt, nor anyone else are responsible for what happens to your server or systems when using this script. Download the GetSSL Bash script 2. Install Homebrew Homebrew is a package manager for Mac. It’s used to install tools and applications for your system. You can read more about Homebrew at the Homebrew website. We’re going to follow the instrucitions on there to install Homebrew on our Mac server. Run the following command in Terminal: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" 3. Edit the GetSSL.sh file The script file needs to be edited so that it know the address you wish to get an SSL certificate for. Open the script in a text editor like TextEdit, TextWrangler, Sublime Text, or through Terminal using an editor like Vim. Change the address, email address, and (if necessary) the FileMaker Server install path variables to reflect your server’s information and your contact information. Let’s Encrypt will use this contact information to reach out to you if there is a problem with the SSL certificate that they have issued to you. 4. Run the Bash Script WARNING: Running this Bash script will safely restart your FileMaker Server service, abruptly disconnecting any active users. Make sure that nobody is connected to your server before you run this script. With Certbot installed, we’re now ready to run the Bash script. Make sure nobody is connected or using your FileMaker server and then run the GetSSL.sh Bash script by navigating to the directory you have it copied to in your Terminal window and entering: sudo ./GetSSL.sh A bunch of text will scroll by in the Terminal window as the script requests, fetches, and installs your SSL certificate. Your FileMaker Server service will then be stopped and started again automatically. Your SSL certificate should now be installed! Go to your FileMaker Server admin console to make sure you’re seeing the new SSL certificate. You may need to close and re-open your browser if you had the page open already. 5. Change the FileMaker Server SSL Connections settings The SSL certificate is installed, but we want to force FileMaker Pro and Go clients to connect securely to our server. Log in to your newly secured FileMaker Server admin console. Select the Database Server options from the list on the left and then the Security tab at the top of the page. Check the “Use SSL for database connections” option (as well as “Use SSL for progressive downloading” if you would like) to force FileMaker Pro and Go clients to use a secure connection when connecting to this server. Save your changes and then restart your whole FileMaker Server machine or just the FileMaker Server background service. Your FileMaker Pro clients should now show the green lock icon when logging in to this server, indicating that the connection is secure. 8. Set up a schedule to renew the SSL certificate SSL Certificates from Let’s Encrypt are only valid for 90 days and must be renewed before that time. Let’s Encrypt does this purposefully to encourage automation and increase security. In that spirit, we should set up an automatic renewal for our SSL certificates so that we don’t need to manually re-run this every couple of months. This process is similar to setting up a scheduled script in FileMaker Server. Move the GetSSL.sh file to a relatively permanent location on your server. An example place for this might be /usr/local/bin/. You’ll need to create a LaunchDaemon schedule to run the script at the dates and times you want to do it. A LaunchDaemon will run your scheduled program or task at the dates and times, or at the interval, that you specify. These certificates are good for 90 days at a time, and the Certbot tool we’re using will only renew them once they’re at least 30 days out from renewal. You will want to create a .plist file to schedule this in a way which makes the most sense for you. You can have it run once per week, for example, and it will renew your certificate when it becomes eligible for renewal (It will still restart your FM Server at your scheduled time, even if there isn’t a new certificate – I’d like to update this in the future to only restart if there’s a new certificate.). You can use the example .plist file available at the download link below. You can download and edit this example file to run your GetSSL.sh script at the location you stored it at and on the days you want. This example one is scheduled to run once per week, on Saturdays at 6:21 pm. You can read more about writing your own LaunchDaemons from the Apple Developer site. Download example .plist As an alternative, there’s a great app called Lingon X which give you a really nice GUI for creating, editing, and installing LaunchDaemons. A demo is available, and a single-user license is $9.99, which may be worthwhile as it makes creating and scheduling LaunchDaemons very easy. Once you’ve finished setting your schedule, place your .plist file in /Library/LaunchDaemons/. With your LaunchDaemon installed you can tell your server to start the schedule by ( substituting your .plist file name and then ) running : sudo launchctl load /Library/LaunchDaeomns/my-script.plist Done! That’s all that you need to do! Your script should run automatically at your scheduled time to renew your SSL certificate with Let’s Encrypt. Do a test to make sure that it’s all working properly, that it gets a new certificate for you, and that your FileMaker Server service restarts after it has retrieved the certificate. If there is an issue, you may want to run the script manually in PowerShell or debug with the PowerShell ISE to locate any issues. Keep in mind that your FileMaker Server service will be restarted after getting the new SSL certificate, so be sure to schedule it for a time when people will not be active in your system. This is an early version of this script and there is quite surely room for improvement. Please let me know if you have any suggestions or run into any issues using this scripting. Let’s make the FileMaker community a secure one! View the full article
  15. Yesterday
  16. There are various ways you could do it. For example, you could create a script to get a list of the desired dimensions, and then loop over that list to create new records in the target table. So something like: Set Variable[ $source ; ExecuteSQL( "SELECT theID WHERE partID = ?" ; "" ; "" ; inspection::partID ] Set Variable[ $count ; ValueCount( $source ) ] Go to Layout[ the target table for the new records ] Loop Set Variable[ $i ; $i+1 ] Exit Loop If[ $i > $count ] New Record Set Field[ partID ; GetValue( $source ; $i ) ] End Loop
  17. Editable FileMaker Pro Virtual Lists By David Thorp and Andy Persons *Tested in FileMaker Pro 14-16 Virtual Lists Since FileMaker Pro virtual lists were introduced more than five years go, they have seen wide use due to two primary benefits: flexibility and performance. The whole point of this tip is EDITING values in a virtual list. That's new and fancy and most people believed impossible, until now! Flexibility FileMaker Pro Virtual lists allow us to display information (usually in a portal) in virtually (pun unintended) any configuration we want. We can gather information from a variety of sources and combine them how we wish, without impacting the schema (other than the initial setup of the virtual list structure). Once the structure is in place, we can also reuse it for multiple purposes. Performance FileMaker Pro Virtual lists have another, sometimes crucial benefit: they can be dramatically faster than retrieving data directly, especially over a remote connection. Because developers control what data is retrieved, they can avoid loading unnecessary data; because they control when it is retrieved, can avoid reloading it unnecessarily. This can result in greatly improved user experiences. Limitations However, FileMaker Pro virtual lists have a crucial limitation: because they rely on calculations, they cannot be edited directly. This technique allows us to work around this limitation. This can be applied to any usage of FileMaker Pro virtual lists. For example, you might wish to quickly retrieve a list of contacts in a popover, while retaining the ability to edit names for quick corrections. Or you could display a list of students with their classes in a cross-tab arrangement, with the ability to change their class assignments on-the-fly. Here’s an overview: Global fields are placed over the virtual fields and set to be hidden except for the active row. When a user clicks in a virtual field, the value is entered into the corresponding editable field and the focus moved there. When the user modifies the editable global field, the database is updated. The virtual list is then refreshed to load the changes. The result is that a user can click into the unstored calculation field on the virtual list directly and it will seem like they are directly editing the values. Though this technique was developed with FileMaker Pro virtual lists in mind, it could be used any time you want to create the experience of “editing” a calculation field. Please see the demo file for more details. • • • Download Demo File • • • ENJOY! **This article is provided for free and as-is, use, enjoy, learn, and experiment at your own risk – but have fun! eXcelisys does not offer any free support or free assistance with any of the contents of this blog post. If you would like help or assistance, please consider retaining eXcelisys’ FileMaker Pro consulting & development services. About eXcelisys, Inc.: Founded in 2001, eXcelisys (www.excelisys.com)is an FBA Platinum Partner and FileMaker Certified developer organization. eXcelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing, and integrating of database solutions for Desktop, Mobile, and Web applications. Our core technology competencies are FileMaker Pro, FileMaker Go, and MySQL for database frameworks, along with FileMaker WebDirect, WordPress, MySQL, PHP, CodeIgniter, PostgreSQL, Joomla, Drupal, Magento, CSS, HTML5, and Javascript for web sites and web applications. Aside from providing eXcellent customer service, our goals are to use these technologies to intuitively automate your organization’s data solution needs seamlessly and flawlessly across the web, mobile, and desktop platforms. Contact eXcelisys today for a free estimate and consultation about making your business more efficient through intuitive and effective software automation. 866-592-9235. eXcelisys, Inc. is an independent entity and this web site/information/blog post has not been authorized, sponsored, or otherwise affiliated with FileMaker, Inc. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries.
  18. That won't work for me unfortunately. I don't have a simple relationship like that. I have Lots, tied to Part Revs, tied to Parts
  19. Have you looked at the Inventory example that comes with FileMaker Pro?
  20. That is it... and I had thought that was the first relationship I created. Thanks for the simple solution.
  21. I have a table that contains dimensional data for parts. Each record has a unique ID, but also has another field with the ID associated with the part. I have another table that I'll be storing individual inspection data on. I was wondering if it's at all possible to parse the first table, and copy over all records that have a specific part ID to the second table whenever someone starts a new inspection record. Please let me know if I need to provide any more information and/or pictures. Thank you in advance for any assistance you can offer!
  22. Please read the Private Message I sent you over 2 hours ago. Especially the Anatomy of a Good Topic.
  23. I have modified the text. And now?
  24. Does the attached work for you? Example2.fmp12
  25. To make the request simple, I did not include all fields. Table A is my Contacts Table that has all of the personal information, including the Active field, Starting and Ending Numbers. What I want to do is Count the records where the Active field is checked, but only when CalcNumber >= StartingNumber and CalcNumber <= EndingNumber for each record. The issue in my screen caps above is that for the first record, I want it to stop counting after it reaches the EndingNumber
  26. I am afraid not. I could not follow this at all. I don't understand what your tables represents in real life (names like FTIME and STEPS are meaningless to me, and the fact that your screenshots use different names only adds to the confusion), and how they are related (or why they are related the way they are). And I don't understand in which table are the times you want to sum. I am not even sure from which table you want to sum them. It sounds like you want to have a subtotal in each portal row? In such case, you must have the start and end dates within the table shown in the portal (STEP???), either as calculation fields or to begin with, and use them in the relationship to the table where the times are. But that's just a wild guess.
  27. Native JSON functions have made it to the FileMaker platform! We dive into how to use the functions to create, modify, and parse JSON for REST APIs and more. Learn about the 6 new functions available, JSONSetElement, JSONDeleteElement, JSONGetElement, JSONListKeys, JSONListValues, JSONFormatElements. FileMaker JSON Functions David Happersberger dbservices.com
  28. Hi, I have a configuration table (named 'Usager actif') with 'Projet ID actif' and start/end date values (field name 'Bilan date début' and 'Bilan date fin') linked to a timesheet table (named 'FTemps lié Projet bilan') to show only the records that match, according to the following relation: This table is also linked to a step table (named 'Étapes lié FTemps lié Projet bilan') to show a list of steps used by the timesheet table (named 'FTemps lié Projet bilan'), base on the following relation: So the last table (named 'Étapes lié FTemps lié Projet bilan') is shown in a portal and it's working correctly (show only two steps used, for all the timesheet records). But I wanna show the total time used for each step (first step is 5 hours, and last one 95 hours). It's working correctly if the start/end date included all timesheet records. But if I shrink the ending date (removing 2 hours from the timesheet in step 2), the total time by step still show all time since the context does not follow from timesheet table to the step table in relation. I still see 5 hours for step 1 and 95 hours for step 2 (should be 93). The total time for all step is now 98 hours, since the ending date has been shrink (removing 2 hours on step 2). How can I do this (hope fully I'm clear enough)?
  1. Load more activity