Jump to content

Search the Community

Showing results for tags 'filemaker 16'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
    • FileMaker Server 17
    • FileMaker Pro Advanced 17
    • Command Line Data Migration Tool
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
    • GDPR
  • FileMaker Server Administration
    • FileMaker Cloud
    • 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 DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • FileMaker Pro 16
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • 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
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 32 results

  1. Hello, Could someone help me with this question? I have a row in a portal in wich i would like to make a calculation: Bedrag= Cases*Prijs, but if Hoeveelheid is filled in then it should calculate Bedrag= Hoeveelheid*Prijs. The fields are all numeric. The calculation should be possible on one row, in this example i have made it on two. Yours sincerely Frans
  2. big hack#1 "JSON and FileMaker 16" https://t.me/filemaker_help January 25, 2018 In development process of information system definite records are required to be selected. For example, needed nomenclature could be added to shopping basket from product list. With 16 system release and adding functions JSON implementation of this task was greatly simplified. Earlier for user selects holding global field or supporting table was required. We had to follow that this field or table were emptied before every new selection procedure. Only public variable is needed now. All information about selected records can be easily added and read by using function JSON,, where the result will be the following JSON- text: “{"1":true,"3":true,"4":true}” in which 1,3 and 4 – keys , which name corresponds to chosen identifier (if we chose record with id 1,3 and 4). Every key gets assigned the same boolean value: true. Script , applying data-hold in JSON-text, is simply arranged . Let us suppose, we handle button, by which the user choses certain record or unselects. Thus we decided to store JSON-text in public variable $$JSON. STEP1 From the beginning we need to initialize JSON-text as it is not empty in initial state, it looks as : “{}”. We can do it once in the script, prenex user’s work with recordset. At this script item will appear : Set Variable [$$JSON; “{}”]. But we can dispence with preliminary script. For example, we can perform such check each time, user push the botton to “select” record. The check will look so: If (IsEmpty ($$JSON);"{}";$$JSON) Later identifier value of current record can be accounted and memorized in variable $id_record. Set Variable [$id_record; GetLayoutObjectAttribute ("id";"content")] In order to item in script worked with using function GetLayoutObjectAttribute, It is needed to place object on layout, displayed ID item, and name “id”. STEP2 Then you make sure existence of tandem in JSON-text, whose name of key corresponds to identifier. If current record has identifier 5, we have to find tandem “5”:true. Here we use function JSONGetElement JSONGetElement($$JSON; $id_record) STEP3 As such tandem doesn’t take place in our example, function returns “empty”. It means this tandem needs to be added to JSON-text by function JSONSetElement JSONSetElement ($$JSON; $id_record), результатом будет запись в $$JSON: “{"1":true,"3":true,"4":true, "5":true}” If JSONGetElement($$JSON; $id_record) returns 1, it means that in text record is already considered. We need to do back action,- delete tandem from JSON by function JSONDeleteElement JSONDeleteElement($$JSON; $id_record), if $id_record was equal to 3, so tandem "3":true," would be deleted and we would get: “{"1":true,"3":true,"4":true}” Thus , efforts are being made to fix and regulate chosen item in case of using JSON-function – minimum. Let us draw our conclusion. For implementation of this task we need: To create JSON-text in public variable $$JSON To check using function JSONGetElement, if value from $id_record took place in $$JSON. If it there isn’t , needed value from $id_record should be added in $$JSON using JSONSetElement If record should be deleted from $$JSON, we use JSONDeleteElement. Script "CheckButton" from MS.fmp12 #Write the current value of the object named id Set Variable [ $record_id; Value:GetLayoutObjectAttribute ( "id";"content" ) ] #check if there is a JSON variable Set Variable [ $$MULTISELECT_LIST; Value:If (IsEmpty ($$MULTISELECT_LIST);"{}"; $$MULTISELECT_LIST ) ] #switch if the variable is empty then write, otherwise delete If [ JSONGetElement ( $$MULTISELECT_LIST;$record_id)] Set Variable [ $$MULTISELECT_LIST; Value: JSONDeleteElement ( $$MULTISELECT_LIST;$record_id )] Else Set Variable [ $$MULTISELECT_LIST; Value: JSONSetElement ( $$MULTISELECT_LIST;$record_id; 1; JSONBoolean) ] End If #refresh checkboxes Refresh Window Refresh Object [ Object Name: "checkbox" ] Download file MS.fmp12 Invest in the development of our project We are ready to help in your development projects. Contact us and we will try to help you: artidog@gmail.com MS.fmp12
  3. Hello, I have been already half a day trying to find out how the 360work email EmailReadMessageValue function works. I have been able to download only the latest 3 days emails, but if any new email will come the EmailGet NExtMessage would be set as 0 and therefore "Halt the script" Moreover no email that I download comes with the messageID or UID. The first does not create the $variable because it is empty and the second gives only value "0". Everything else can be obtained from the keys. What could I be doing wrong so that the EmailReadMessageValue( "messageID" ) does not extract the messageID from the email??? I am desperate because I just cant figure out why this is not working, so any comment that would help see some light would be much appreciated, Thanks a lot in advance for any help you may provide. Luis
  4. Updated serial communication plug-in for FileMaker Pro 16 with several improvements.Alphen aan den Rijn, the Netherlands, January 17, 2018–Troi today announced the immediate availability of Troi Serial Plug-in 5.0.1 for FileMaker Pro 16.What is Troi Serial Plug-in?Troi Serial Plug-in gives FileMaker Pro easy and powerful access to external devices with a serial interface:- read from and write to the (virtual) serial ports of the computer directly from FileMaker Pro without the need of a separate application- native FileMaker script triggering, to get incoming data into the database- "Suspend/Resume Serial Port" script step to temporarily suspend the incoming data stream and resume it when you are interested in the data- "Wait for Match" function to wait for a specific text before triggering- the possibility to open an unlimited number of serial ports and to trigger different scripts for different portsWhat is new in version 5.0.1?Troi Serial Plug-in 5.0.1 is a maintenance release and has the following fixes and improvements:- Fixed a problem with Serial_SetDispatchScript: you can now use a different wait string for each port.- Added switch to Serial_Debug function "-UseTextAllBytes0To255": you can use this in combination with the switch "-TestTriggerScript". The plug-in will trigger a script with as test data all the bytes from 0 to 255.- Improved the Debug.fmp12 example file, it now shows how to use the "-UseTextAllBytes0To255" and "-ConvertBytesToNumbers" switches. Also improved the Terminal.fmp12 example file, it now shows how to use the "-ConvertBytesToNumbers" switch when receiving data.- (Windows) Added code signing to the plug-in for Windows.- (macOS) Fixed a compilation problem with code signing and extended attributes in macOS 10.12 (Sierra).- The plug-in now indicates if an external script step is compatible with a product. The step is shown in grey if it is incompatible for that product (for example iOS) in the script editing pane (center) and the script steps pane (right).- Improved the log text when running FileMaker Server: more information is added to the log. After an unsuccessful attempt to register, the log now also adds the (incorrect) register text used.Pricing & AvailabilityA fully functional demo version of Troi Serial Plug-in 5.0.1 is available for downloading at https://www.troi.com/products/serialplugin/A cross platform developer license costs US$ 999. Details can be found on our web site. You can order licenses from our web site.Upgrade informationVersion 5.0.1 works with the 5.0 version of the registration. If you bought a license for a pre-5.0 version on or after June 2, 2016 the upgrade is FREE! Eligible users have been sent a new registration string in May 2017.Upgrades from a cross platform developer license bought before June 2, 2016 are available from US$ 499. You can order upgrades from our web site.
  5. Updated script triggering plug-in for FileMaker Pro 16 improves stability.Alphen aan den Rijn, the Netherlands, December 11, 2017–Troi today announced the immediate availability of Troi Activator Plug-in 4.5.1 for FileMaker Pro 16.What is Troi Activator Plug-in?Troi Activator Plug-in is a very powerful tool for triggering scripts remotely. All from within FileMaker you can:- trigger a FileMaker script on a different computer (remotely)- trigger a FileMaker script over internet- use the built-in security to prevent unauthorized triggering- send a number (e.g. a record ID) and a long text with the trigger- start and stop listening for remote trigger messages with one script step- communicate with databases in different FileMaker versions or even runtimesExcept from remote triggering you can also use the Activator Plug-in for:- triggering a script on a specified date and time- scheduling events which trigger any script you want- running a script from any FileMaker calculation, for example a tooltip calculation- validating fields on exiting a record with a custom script suited to your specific needsWhat is new in version 4.5.1?Troi Activator Plug-in 4.5.1 is a maintenance release and has the following fixes and improvements:- (Mac OS) Fixed a crashing problem with installing or disabling the plug-in: FileMaker Pro no longer crashes when disabling the plug-in. Note: if you have installed version 4.5 you need to remove the plug-in manually to avoid the crashing. You will find instructions how to manually update Troi Activator Plug-in 4.5 here: https://www.troi.com/additional/manually-update-troi-activator-plugin-instructions/- (Mac OS) Fixed a compilation problem with code signing and extended attributes in Mac OS 10.12 (Sierra).- Improved type-ahead of external function names.Pricing & AvailabilityA fully functional demo version of Troi Activator Plug-in 4.5.1 is available for downloading at https://www.troi.com/products/activatorplugin/Licenses cost US$ 89 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.Upgrade informationThe 4.5.1 version works with the 4.5 version of the registration. If you bought a license for a pre-4.5 version on or after June 14, 2016 the upgrade is FREE! Eligible users have been sent a new registration string in September 2017.Upgrades from licenses bought before June 14, 2016 are available from US$ 39 per user. Upgrade prices for other licenses can be found on our web site.You can order upgrades from our web site.End of year sale: all licenses 10% off!Until the end of 2017 we offer a 10% discount on all Troi plug-in licenses! Order your new licenses and upgrades for any of the Troi plug-ins from https://www.troi.com/shop/ and enter the following coupon code upon checkout:END2017SALEThe coupon code is valid until December 31, 2017.
  6. Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16https://www.youtube.com/watch?v=urh8i...Most Recent Upload https://goo.gl/Dbn9fmGet up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content!Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas.Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client server integration.Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.RCC and LearningFileMaker.com are headquartered in Santa Clara, CA.FM Camera in the FileMaker Platform Playlist https://www.youtube.com/playlist?list...http://www.rcconsulting.com/Please feel free to contact us at support@rcconsulting.comFileMaker Video Training - | FileMaker video training ... FileMaker Pro is simply powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the webFileMaker Go is available free on the App Store and runs your FileMaker apps on iPad and iPhoneTransform your business with the FileMaker Platformwant all of our free FileMaker training videos? FileMaker Training Videos Channel https://www.youtube.com/user/FileMake...When In Doubt, Check This Out | Online FileMaker Videos https://www.youtube.com/watch?v=6DiI5...A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze datawatch a FileMaker training review https://www.youtube.com/watch?v=reoBi... Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source projecthttp://learningfilemaker.com/FIAS.htmlCheck out iPhone 6s, iPhone 6, and iPhone SEHere is a video introduction to iOS App Training https://www.youtube.com/watch?v=cVxQe...for more free FileMaker videos check out ...http://www.filemakervideos.comDownload the FileMaker Pro 16 & FileMaker Go 16 for mobile devices training videos at http://www.learningfilemaker.comDownload FileMaker 16 Go video training at http://learningfilemaker.com/FMGO-16/...Download the FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscrip...FileMaker Pro 15 News-What is FileMaker 15-FileMaker Pro 15 Videos https://www.youtube.com/watch?v=gw38m...FileMaker FLT Buffet Licensing | FileMaker Pro 15 Videos | FileMaker 15 Training https://www.youtube.com/watch?v=q5vdm...FileMaker News | FileMaker Server 15 Performance Improvements | FileMaker Pro 15 Video Course 40 Hrs https://www.youtube.com/watch?v=BCJ3f...FileMaker 16 Videos Get up to speed with the FileMaker Pro 16 Video Training CourseFileMaker 15 News | FileMaker Pro 15 Video Course | FileMaker Pro 15 Video Training | FileMaker 15 Videos https://www.youtube.com/watch?v=oRkOY...FileMaker Pro 16 Video Course 50 Hours-FileMaker Pro Videos-FileMaker 16-FM Pro 16 FileMaker 16 Training Videos-FileMaker 16Looking for FM Starting Point free software download: http://www.fmstartingpoint.comLearn how to use FileMaker to create an app with the FileMaker Training SeriesFileMaker 15 introduction | FileMaker pro video training https://www.youtube.com/watch?v=r2yfR...FileMaker training review of learningfilemaker.com https://www.youtube.com/watch?v=9JTgI...Please Comment, Like & Share All of Our VideosFeel Free to Embed any of Our Videos on Your Blog or Website.Follow Us on Your Favorite Social Mediahttps://www.facebook.com/FileMakerVideoshttps://twitter.com/filemakervideoshttps://plus.google.com/+FileMakerVid...#WhatisFileMaker16#FileMakerPro16Training#FileMaker16VideoTutorial#FileMakerPro16Videoshttps://www.youtube.com/watch?v=urh8i...http://feeds.feedburner.com/Top10NewF...https://www.youtube.com/watch?v=hHXZP...
  7. In Matt Petrowsky's video on all things new in Fm 16 , the very first new addition is a new calculation workspace where we can see the results of our calculation. i.e. there is an additional pane in the work space where results can be previewed.( see attached pic). I can get to this workspace from the Data Viewer , but when I try to get to it from Define Fields dialog box, I just get the regular calculation workspace. What Gives ? Why is it not everywhere ? Thanks. kevin
  8. dbservices

    FileMaker Layout Objects Window

    The Layout Objects window is an exciting feature released with FileMaker 16. This FileMaker Layout Object Window allows you to work easily with stacked objects and quickly finding an object or field on a layout. FileMaker Layout Objects Window David Happersberger dbservices.com
  9. Hey, what happens if I create a solution in FM16 and use the "Card Window" feature and someone else who still has FM15 wants to work with my solution? Will this work or is it not even possible to run the FM16 solution? Thanks in advance, Mike
  10. Troi releases Troi Serial Plug-in 5.0 for FileMaker Pro 16 Serial communication plug-in adds new script steps and online help for FileMaker Pro 16. Alphen aan den Rijn, the Netherlands, May 25, 2017–Troi today announced the immediate availability of Troi Serial Plug-in 5.0 for FileMaker Pro 16. What is Troi Serial Plug-in? Troi Serial Plug-in gives FileMaker Pro easy and powerful access to external devices with a serial interface: - read from and write to the (virtual) serial ports of the computer directly from FileMaker Pro without the need of a separate application - native FileMaker script triggering, to get incoming data into the database - "Suspend/Resume Serial Port" script step to temporarily suspend the incoming data stream and resume it when you are interested in the data - "Wait for Match" function to wait for a specific text before triggering - the possibility to open an unlimited number of serial ports and to trigger different scripts for different ports What is new in version 5.0? We rewrote Troi Serial Plug-in for FileMaker 16 and it now has the following new functionality: - Tested and made compatible with FileMaker Pro 16. - Added new Serial_GetPortInfo function, which retrieves the status and other information of a serial port. Version 5.0 adds the following new features when running in FileMaker 16: - The Serial Plug-in adds 9 script steps when running in FileMaker Pro 16. You can select these script steps in the script steps pane in Script Workspace, or you can begin typing the script step name, then choose the script step from the list that appears. The script steps significantly expand the possible actions you can perform with FileMaker Pro. Only steps that perform an action have been added as a script step. Functions that just return information (like for example Serial_GetPortNames) are only available as an external function. - Added new example file SimpleSerial-for-FMP16.fmp12, which demonstrates how to use the new external script steps of FileMaker Pro 16. - Added support for online help for the functions and script steps of the plug-in. You can now easily get online help from the Troi website, by clicking the Help button (the small question mark button) next to the function description in the functions pane or the script step description in the script steps pane. Apart from these additions we fixed several bugs and made various further improvements. More detailed information on all changes and improvements implemented in Troi Serial Plug-in 5.0 can be found can be found at: https://www.troi.com/products/serialplugin/ Pricing & Availability A fully functional demo version of Troi Serial Plug-in 5.0 is available for downloading at Troi's web site at: https://www.troi.com/products/serialplugin/ A cross platform developer license costs US$ 999. Details can be found on the Serial Plug-in page. You can order licenses from our website. Upgrade information Version 5.0 needs a new registration. The upgrade is free for users who bought a license for Troi Serial Plug-in on or after June 2, 2016. Eligible users will be sent a new registration. Contact us if you have not received yours after May 30, 2017. Upgrades from a cross platform developer license bought before June 2, 2016 are available from US$ 499. You can order upgrades from our web site. Contact information D. Budding Troi Newsroom: https://www.troi.com/news/
  11. dbservices

    FileMaker PDF from Server

    FileMaker Server 16 now has the ability to create PDFs on the server! Gone are the days of creating overly complicated PHP setups and unreliable FileMaker Pro robot machines. Learn a few of the great new features FileMaker Server 16 adds for PDFs. FileMaker PDF from Server David Happersberger dbservices.com
  12. Encryption plug-in adds new script steps and online help for FileMaker Pro 16. Alphen aan den Rijn, Netherlands, August 15, 2017–Troi today announced the immediate availability of Troi Encryptor Plug-in 4.0 for FileMaker Pro 16. What is Troi Encryptor Plug-in? Troi Encryptor Plug-in is a very powerful tool for securing your FileMaker data, exporting or emailing your data without risk and importing safely back into FileMaker. All from within FileMaker you can: - encrypt text or container fields, using the powerful 256-bit AES encryption scheme, so that your sensitive data is secure - export encrypted data that can be sent safely across internet, for example via email. No risk that someone will read or change the data while in transit - use the decryption functions to restore the original information after you have imported the received email or export file back into FileMaker, with the assurance that nobody will have tampered with it - exchange AES-encrypted data with other systems (like for example PHP-mcrypt) - verify data integrity and sources with SHA-1 message digests - encode text in Base64 - make conversions to and from binary - compress databases with large text fields - save and retrieve passwords to and from the keychain of the operating system What is new in version 4.0? We rewrote Troi Encryptor Plug-in for FileMaker 16 and it now has the following new functionality: - Tested and made compatible with FileMaker Pro 16. - Fixed several bugs, rewrote and modernized the code in several places and made further improvements. - Updated the User Guide and the Reference.fmp12 file. - Made various minor changes to the example files to better work with FileMaker Pro 16. - Updated the code by adding improved namespace handling to make the plug-in more robust. Extra features when running FileMaker Pro 16 Version 4.0 adds the following new features when running in FileMaker 16: - The Encryptor Plug-in adds multiple script steps when running in FileMaker Pro 16. You can select these script steps in the script steps pane in Script Workspace, or you can begin typing the script step name, then choose the script step from the list that appears. The script steps expand the possible actions you can perform with FileMaker Pro. Only steps that perform an action have been added as a script step. Functions that just manipulate data and have no side effect (like for example Encr_EncryptRijndaelAES) are only available as an external function. The following three script steps are added: - Save Password to Keychain - Get Password from Keychain - Delete Password from Keychain - Added new scripts to the EncryptAES example file, which demonstrate how to use the new external script steps of FileMaker Pro 16. The examples check if FileMaker Pro 16 is running and will select these new scripts. - Added support for online help for the functions and script steps of the plug-in. You can now easily get online help from the Troi website, by clicking the Help button (the small question mark button) next to the function description in the functions pane or the script step description in the script steps pane. Apart from these additions we fixed several bugs and made various further improvements. More detailed information on all changes and improvements implemented in Troi Encryptor Plug-in 4.0 can be found at: https://www.troi.com/products/encryptorplugin/ Pricing & Availability A fully functional demo version of Troi Encryptor Plug-in 4.0 is available for downloading at: https://www.troi.com/products/encryptorplugin/ Licenses cost US$ 79 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site. Upgrade information Version 4.0 needs a new registration. The upgrade is free for users who bought a license for Troi Encryptor Plug-in on or after July 5, 2016. Eligible users will be sent a new registration. Contact us if you have not received yours after August 18, 2017. Upgrades from licenses bought before July 5, 2016 are available from US$ 39 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site.
  13. dbservices

    FileMaker cURL Options

    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
  14. Hey, I started working with FileMaker a while ago and so far it's been pretty fun and fairly easy to learn because I worked with MySQL in the past. However, there are still a few questions I have. I'm used to having complete freedom when it comes to databases, because in Python or C++ for instance I would simply write my own queries and get whatever data I need, no matter if a database is related to another or not. Anyway, the flexibility is still what causes me some problems. I have the following problem. I'm working on an ERP (Enterprise Resource Planning) software for the owner of several restaurants. I need to have the following tables to start with: Restaurants Employees Jobs Visa Health Insurances Meetings Now, the person using the solution needs to be able to create as many restaurants, employees, jobs and meetings as they want and assign them to each other. For instance, Restaurant A is going to have 5 employees, Employee A, B, C, D, E and so on, and all these employees will have one or multiple (this is really important) jobs assigned to them. This process has to be flexible, so I can assign an employee to whichever restaurant and job I choose. You also need to be able to assign one or more visa to a job (and the assigned employee), the same goes for one or more health insurances. The next problem is about meetings. Each restaurant needs to be able to have meetings every once in while, which need the ability to keep track of employees that attend the meeting. So you should be able to select employees form a portal or card window (in FM16 for instance) and they will be added to another table MeetingAttendees or something similar. Again, this needs to be flexible so every restaurant can create meetings and check which employee is present. (I need to be able to create a layout to display the meetings and who has been present, if possible also to see who wasn't). Normally I would simply take the IDs and create tables that join these iDs together, however I'm not able to recreate this in FileMaker, if one relationship works, the other breaks for some reason. If anyone could give me a simple layout of what my database needs to look like, or if possible and not too much to ask an example in FileMaker. Your help is much appreciated. Thanks in advance, Mike
  15. Scriptable dialog plug-in adds new script steps and online help for FileMaker Pro 16.Alphen aan den Rijn, the Netherlands, October 23, 2017–Troi today announced the immediate availability of Troi Dialog Plug-in 7 for FileMaker Pro 16.What is Troi Dialog Plug-in?Troi Dialog Plug-in is a very powerful tool for displaying all sorts of dialogs in FileMaker Pro. The text of the dialog and of the buttons can be created dynamically by using a calculation or a scipt step. All from within FileMaker you can:- show an input dialog to let a user input data in up to 15 fields and up to 4 buttons- choose these input fields to be any of the following: simple text, password field, popup list or check box- show a list dialog or very big text dialog- show temporary flash screens- show a progress bar for lengthy operations- add a standard icon or your own custom iconsWhat is new in version 7?We rewrote Troi Dialog Plug-in for FileMaker 16 and it now has the following new functionality:- Tested and made compatible with FileMaker Pro 16.- Tested and improved compatibility with Windows 10 (Creators Update) and macOS 10.13 (High Sierra).- Rewrote and modernized the code in several places.- Made various minor changes to the example files to better work with FileMaker Pro 16.- Updated the User Guide and the Reference.fmp12 file.Extra features when running FileMaker Pro 16Version 7.0 adds the following new features when running in FileMaker 16:- The Dialog Plug-in adds script steps when running FileMaker Pro 16. You can select these script steps in the script steps pane in Script Workspace, or you can begin typing the script step name, then choose the script step from the list that appears. The script steps expand the possible actions you can perform with FileMaker Pro. The following script steps are added: - Show Big Input Dialog - Show Flash Dialog - Show Slideshow- Added new scripts to the BigInputDialog.fmp12, Flash.fmp12 and PresentImage.fmp12 example files, to demonstrate how to use the new external script steps of FileMaker Pro 16. The examples check if FileMaker Pro 16 is running and will then select these new scripts.- Added support for online help for the functions and script steps of the plug-in. You can now easily get online help from the Troi website, by clicking the Help button (the small question mark button) next to the function description in the functions pane or the script step description in the script steps pane.Apart from these additions we updated the Dial_PresentImage function for 64-bit (Mac OS only) and fixed a problem in the Dial_ListDialog function. More detailed information on all changes and improvements implemented in Troi Dialog Plug-in 7.0 can be found at: https://www.troi.com/products/dialogplugin/Pricing & AvailabilityA fully functional demo version of Troi Dialog Plug-in 7.0 is available for downloading at: https://www.troi.com/products/dialogplugin/Licenses cost US$ 59 per user. Details on developer licenses and multi-user discounts can be found on our web site. You can order licenses from our web site.Upgrade informationVersion 7.0 needs a new registration. The upgrade is free for users who bought a license for Troi Dialog Plug-in on or after October 1, 2016. Eligible users will be sent a new registration. Contact us if you have not received yours after October 25, 2017.Upgrades from licenses bought before October 1, 2016 are available from US$ 35 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from our web site.
  16. With the introduction of cURL options in FM16's Insert from URL script step I've been investigating the possibility of being able to save a copy of my FM solution directly to my Dropbox folder using the https://content.dropboxapi.com/2/files/upload element from Dropbox V2 API. I've successfully created the access token to pass through as part of this step and the Insert from URL script step successfully creates the stated folder and file in my Dropbox. However, the file size is always 0 bytes. I've tried 2 different methods METHOD 1 #Export a compacted copy of this file to Temporary Folder Set Variable [ $file_path ; Get ( TemporaryPath ) & "Solution.fmp12" ] Save a Copy as [ "$file_path" ; compacted ] #Set my cURL options to variable Set Variable [ $curl_header ; "curl -X POST https://content.dropboxapi.com/2/files/upload \\" & ¶ & "--header \"Authorization: Bearer " & PREFERENCES::Dropbox_AccessToken & "\" \\" & ¶ & "--header \"Dropbox-API-Arg: {\\\"path\\\": \\\"/DB2FM/Solution.fmp12\\\"}\" \\" & ¶ & "--header \"Content-Type: application/octet-stream\" \\" & ¶ & "--data-binary @" & $file_path ] #Dropbox URL Set Variable [ $dropbox_url ; "https://content.dropboxapi.com/2/files/upload" ] #Make Request - Set to variable adn then format to JSON field Insert from URL [ Verify SSL Certificates ; With dialog: Off ; $json ; $dropbox_url ; cURL options: $curl_header ] Set Field [ PREFERENCES:Dropbox_JSON ; JSONFormatElements ( $json ) ] METHOD 2 #Export a compacted copy of this file to Temporary Folder and then import to a container field Set Variable [ $file_path ; Get ( TemporaryPath ) & "Solution.fmp12" ] //note1 Save a Copy as [ "$file_path" ; compacted ] //note1 Insert File [ PREFERENCES::Container ; "$file_path" ] //note1 #Set variable following instructions on FileMaker website which states: # - Direct file access is replaced with a FileMaker variable prefixed by the @ character. # - To access a file, you can set the variable to a container field, which contains the file, then use that variable as the parameter of the cURL option. Set Variable [ $container_path ; PREFERENCES::Container ] #Set my cURL options to variable Set Variable [ $curl_header ; "curl -X POST https://content.dropboxapi.com/2/files/upload \\" & ¶ & "--header \"Authorization: Bearer " & PREFERENCES::Dropbox_AccessToken & "\" \\" & ¶ & "--header \"Dropbox-API-Arg: {\\\"path\\\": \\\"/DB2FM/Solution.fmp12\\\"}\" \\" & ¶ & "--header \"Content-Type: application/octet-stream\" \\" & ¶ & "--data-binary @" & $container_path ] #Dropbox URL Set Variable [ $dropbox_url ; "https://content.dropboxapi.com/2/files/upload" ] #Make Request - Set to variable adn then format to JSON field Insert from URL [ Verify SSL Certificates ; With dialog: Off ; $json ; $dropbox_url ; cURL options: $curl_header ] Set Field [ PREFERENCES:Dropbox_JSON ; JSONFormatElements ( $json ) ] JSON Response For Both Methods I get the following JSON Response for both methods { "client_modified" : "2017-05-16T11:22:47Z", "content_hash" : "e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855", "id" : "id:heJWQ1SWwJsAAAAAAcMWNw", "name" : "Solution.fmp12", "path_display" : "/DB2FM/Solution.fmp12", "path_lower" : "/db2fm/solution.fmp12", "rev" : "3a0412f00f58892", "server_modified" : "2017-05-16T11:22:48Z", "size" : 0 } Any ideas as to why the file is created but with no content. I've also tried this with a number of different file types (.png, .txt, .pdf) by manually inserting a file into the container and greying out the 3 steps marked //note1 above but the result is always the same.
  17. I was interested to read that FileMaker 16 now supports the ability to sign in with an HTTP POST. I was wondering if anyone had tested this yet? I'm looking at creating a custom login screen so any examples would be great. Thanks.
  18. Hey, I have a question about hosting my filemaker database. If I buy a license for 5 people form here: https://store.filemaker.com/filemaker-cloud , will I also need to purchase 5 normal FileMaker 16 Pro Client licenses so people can actually connect to the database? I don't quite understand how this works yet, maybe someone can help me out. Do I get the client licenses with the purchase of a server license? I need 5 people to be able to access it. Thanks in advance, Mike
  19. San Diego, CA - May 9, 2017 - Productive Computing, Inc., a Platinum member of the FileMaker® Business Alliance, is proud to announce that its entire suite of products is FileMaker 16 compatible. "Over the last several months our product development team has been hard at work preparing for today’s FileMaker 16 release. We are excited to have implemented FileMaker’s new external script step capability in all 11 of our plug-ins, which allows a developer to specify plug-in functions as script steps instead of as calculation results. Since this functionality is new in FileMaker Pro 16, this new feature will only be available when our plug-ins run in FileMaker Pro 16. Along with the new external script steps, we continue to support and include the traditional method of using our plug-ins as calculation functions for FileMaker Pro 16 and earlier versions. This ensures that scripts previously integrated with any Productive Computing plug-in will still be available and functional no matter which version of FileMaker a customer is running." Rachel Castillo, Products Manager, Productive Computing, Inc. "Compared to using traditional plug-in integration methods, applying FileMaker 16 external script steps within a solution improves development efficiency, provides clarity when identifying plug-in functionality from native FileMaker functionality, and assists with data entry validation. A developer now has the option to utilize the plug-in script steps at their discretion. With this release, we're excited to bring you the latest cutting edge tools available to further enhance and simplify your FileMaker integration experience with our extensive product line of solutions and plug-ins." Marc Larochelle, Chief Executive Officer, Productive Computing, Inc. To accompany this comprehensive update, each plug-in now features updated documentation. For a complete list of Productive Computing products that are compatible with the new FileMaker Pro 16 release, please see below: Solutions: Core4: A customizable CRM solution that allows users to efficiently manage areas including: contacts, calendars, tasks, correspondence, sales opportunities, estimates, invoices, inventory, projects, reports, and more. Core5 Starter Edition: Customizable starter CRM that comes ready to connect to your QuickBooks file. Manage contacts, sales, documents, and tasks on your desktop, laptop, or iOS device. Vessel Service Solutions: A vertical solution for the marine assistance industry that operates as a virtual command center to manage vessel assistance orders. Plug-ins: Outlook Manipulator: Exchange data with Microsoft® Outlook Contacts, Calendar, Tasks, Mail, and Notes for the "user’s" default folder, public, and shared folders within the Exchange Environment and with any Exchange mailbox. FM Books Connector: Connect QuickBooks® to your FileMaker solution and save time and energy by eliminating double entry of contacts, invoices, or sales transactions. 123sync: Accelerate the development of a personalized QuickBooks integration with your existing FileMaker solution. FM Books Connector Online: Using QuickBooks Online? You can reap all of the benefits of connecting your FileMaker solution to your QuickBooks Online file. Available for local or server-side deployment. Address Book Manipulator: Exchange data dynamically between FileMaker Pro and Macintosh's Contacts in a "one-to-many" format that handles group and individual contacts, multiple addresses, phone numbers, and e-mails. iCal Manipulator: Provides a bi-directional data exchange between FileMaker Pro and Apple Calendar / Reminders eliminating double entry and syncing FileMaker Pro with any iCal supported calendar type. eSign Signature Capture: Decrease labor and processing time of your standard forms and increase security for your organization by capturing signatures and binding them to information stored in your FileMaker solution. Biometric Fingerprint Reader: Allows for fast identification and secure verification capabilities that enable your FileMaker solution to recognize individual users without requiring passwords or card swipes. PDF Manipulator DC: Search text contained within a PDF document, extract data from PDF form fields, create a searchable document management system, and process forms faster by eliminating the need to hand key information into your solution. Change Printer: Automatically change printers, set optional printing attributes, coordinate large and complex print procedures, and switch between various types of printers/drivers such as: inkjet, laser, label, and PDF - all from your FileMaker solution. File Manipulator: Access, copy, move, rename or delete files and folders, as well as compress/extract and encrypt/decrypt file data directly from your FileMaker solution. Licensing: FileMaker Licensing: Purchase FileMaker Pro 16 today! Being Platinum Partners with FileMaker, Inc. we are able to work directly with FMI’s sales team to secure better pricing on new FileMaker Pro licenses and maintenance contract renewals than what customers have access to on their own. For more information on compatibility or product details please contact sales@productivecomputing.com or call (760) 510 -1200. Please download the latest plug-in to ensure compatibility with FileMaker 16. All users running the current version of the plug-in may upgrade to the most recent FileMaker 16 compatible version free of charge. To buy FileMaker 16 today please visit www.buy-filemaker.com. FileMaker Pro Support and Plug-in Integration: Do you have database enhancements you would like to have programmed? Want help getting a plug-in professionally installed into your FileMaker solution? We can help! The process is easy - complete our online Request For Quote form (RFQ) or call us directly at (760) 510-1200 and one of our certified developers can work with you on improving your solution today. About Productive Computing, Inc. Since 1996, Productive Computing, Inc. has been helping its customers become more efficient and profitable by implementing custom software solutions using FileMaker Pro. Utilizing FileMaker Pro as a rapid application development tool, their certified FileMaker developers can create custom applications that a business can run on their Windows or Macintosh desktop computers, in a web browser, on an iPad or iPhone or shared simultaneously on all of these platforms. Productive Computing, Inc. also produces Core4 CRM and Core5 Starter Edition, two off-the-shelf productivity solutions designed to automate your workflow, as well as a suite of FileMaker Pro plug-ins that allow FileMaker Pro to integrate with third party applications including Outlook, QuickBooks, Apple Contacts and Calendar, PDF forms, digital signatures, and biometric fingerprint scanners. In addition, Productive Computing, Inc. is a full-service FileMaker Pro hosting company. FileMaker hosting services allow customers to host their own FileMaker Pro solutions on Productive Computing servers in the cloud instead of purchasing and supporting the necessary server infrastructure themselves. These same servers also provide the infrastructure for customers who would prefer to subscribe to Productive Computing's Core4, Core5, or Vessel Service Solutions under a SaaS (Software as a Service) pricing model. Productive Computing, Inc. is one of only a few companies in the United States to have earned the highly respected Platinum level membership within the FileMaker Business Alliance and recently won the exclusive FileMaker Business Alliance Partner of the Year award. Productive Computing, Inc. 950 Boardwalk, Suite 205 San Marcos, CA 92078 www.ProductiveComputing.com sales@productivecomputing.com (760) 510-1200 Press Contacts: Productive Computing, Inc. Keith Larochelle (760) 510-1200 # # # ---------------------------------------------------
  20. dbservices

    FileMaker Data API

    FileMaker's REST API allows for integrating web solutions with FileMaker in new and exciting ways. Learn how to authenticate with a FileMaker file, and create, update, read, and delete records. FileMaker Data API David Happersberger dbservices.com
  21. dbservices

    FileMaker 16 Security Features

    FileMaker is constantly improving the security features of the FileMaker platform to better serve its users. Learn about new field-level encryption functions, and account authentication with Amazon, Google, Microsoft Azure Active Directory via OAuth. FileMaker 16 Security Features David Happersberger dbservices.com
  22. dbservices

    FileMaker JSON Functions

    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
  23. Updated file management plug-in is compatible with FileMaker Pro 16 and adds new functionality. Alphen aan den Rijn, the Netherlands, May 9, 2017–Troi today announced the immediate availability of Troi File Plug-in 9.0 for FileMaker Pro 16. What is Troi File Plug-in? Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker Pro database. Any files or folders stored on the computer can be accessed through the functions of the plug-in. All from within FileMaker Pro you can: get data from files that are on the disk of the computer into FileMaker Pro create files anywhere on the hard disk and put data from FileMaker fields into them manipulate files and folders on the disk: this includes creating, deleting, copying, moving and modifying files and folders get the size on disk, creation and modification dates and much more launch and reveal files directly from FileMaker Pro manage your images and movies, and read IPTC and Exif metadata from JPEG, Raw and PNG images What is new in version 9.0? Troi File Plug-in 9.0 has the following new functionality: Tested and made compatible with FileMaker Pro 16. Added new TrFile_GetFolderSize function, which can get the total size (in bytes) of a folder. Added new TrFile_AppendContentsToFile and TrFile_SetContentsOfFile function. These functions differ from the existing AppendContents and SetContents functions in that you can set the file to manipulate as a parameter in the function, instead of with the separate SetDefaultFileSpec function. (Mac OS) Added new TrFile_SetFinderComment function, which can set the text of a Finder comment (also called Spotlight comment) of a specified file or folder. You can see the comment with the Get Info command in the Finder. Renamed the TrFile_MetaData function to TrFile_GetMetaData, as to better reflect its functionality. Added possibility to use a container as the source parameter for the TrFile_GetMetadata function. Improved the TrFile_DragAndDrop function: you can now specify three different drop zones. Version 9.0 adds the following new features when running in FileMaker 16: The File Plug-in adds 36 script steps when running in FileMaker Pro 16. You can select these script steps in the script steps pane in Script Workspace, or you can begin typing the script step name, then choose the script step from the list that appears. The script steps significantly expand the possible actions you can perform with FileMaker Pro. Only steps that perform an action have been added as a script step. Functions that just return information (like for example TrFile_GetFileSize) are only available as an external function. Added new example file CreateFile-for-FMP16.fmp12, which demonstrates how to use the new external script steps of FileMaker Pro 16. Added support for online help for the functions and script steps of the plug-in. You can now easily get online help from the Troi website, by clicking the Help button (the small question mark button) next to the function description in the functions pane or the script step description in the script steps pane. Apart from these additions we fixed several bugs and made various further improvements. More detailed information on all changes and improvements implemented in Troi File Plug-in 9.0 can be found on https://www.troi.com/products/fileplugin/ Pricing & Availability A fully functional demo version of Troi File Plug-in 9.0 is available for downloading from the Troi web site at: https://www.troi.com/products/fileplugin/ Licenses cost US$ 99 per user. Details on developer licenses and multi-user discounts can be found on the web site. You can order licenses from our web site. Upgrade information Version 9.0 needs a new registration. The upgrade is free for users who bought a license for Troi File Plug-in on or after May 10, 2016. Eligible users will be sent a new registration. Contact us if you have not received yours after May 12, 2017. Upgrades from licenses bought before May 10, 2016, are available from US$ 59 per user. Upgrade prices for other licenses can be found on our web site. You can order upgrades from the web site.
  24. dbservices

    FileMaker Crosstab Reports

    Learn how to create cross tab reports using native FileMaker and through the use of a web viewer to make flexible and fast reports. Includes free sample file and demo! FileMaker Crosstab Reports David Happersberger dbservices.com
  25. Hey, I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not. I already have the following tables: Restaurants, Employees and Meetings So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent? Thanks in advance, Mike
×

Important Information

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