Bikur Cholim בקור חולים

Wednesday, November 30, 2016

Unsupported Features in FileMaker Cloud

Unsupported Features in FileMaker Cloud

With all this awesomeness why wouldn’t I want to use FileMaker Cloud!? One might ask. There are really only a handful of specific scenarios that FileMaker Cloud may not be a good fit for you and your organization.
  • External Authentication — FileMaker Cloud does not support external authentication via Active Directory/Open Directory. It does, however, support custom app authentication via FileMaker user accounts.
  • Server Side Scripts — FileMaker Cloud does not allow server side scripts to run which means you’d need your own dedicated machine of FileMaker Server.
  • Custom Web Publishing with PHP and XML — If you are, or are wanting to integrate with your website for instance, FileMaker Cloud does not support PHP or XML.
  • More than a Week of Backups — As previously stated, FileMaker Cloud comes automatically equipped to have a backup run every 20 minutes and stores a week worth of backups. If you were to want more than one week, you’d need to manually preserve specific backups.
  • Plugin Support — If you are using any plugins in your application, you’ll need to make sure they have a new version that supports Linux for the FileMaker Cloud.

Monday, November 28, 2016

How to delete unnecessary Fields in FileMaker

Export the Field/s to Excel and press Ctrl+Down. 
If the Field is empty it will go down all the way to the last Cell of the current Column. 
Now press Ctrl+Up and if the Field is empty it will go up all the way to the first Cell of the current Column (which is the Field Name). 
Continue with going down and up until you reach the last populated Column.
However if the Field is not empty then instead of hitting the bottom or the top of a Column it will stop at a Cell that contains some Data.
Highlight the Field to distinguish it from the other - Empty - Columns and do the same with all Columns containing Data.
Before continuing with this procedure,
it would make sense of course to back up the file, so that in case you make a mistake you will have the backup file to fall back on.
Now you're ready to delete the empty Fields in FileMaker: Ctrl+Select the Fields in Manage Database and hit the Delete button.