Imagine this scenario:
At 4:47 p.m. Fred in sales opens the company’s FileMaker system and navigates to the contact list layout. He selects a contact and clicks a button to print a report of communications in the last three months. A beach ball icon spins for a few seconds, but nothing prints. Assuming something is wrong with the printer, Fred submits a ticket with the IT support desk and goes home for the day.
The next morning, Carrie in marketing wants a list of contacts added to the database in the last month. She logs in and perform a find, but strangely, no contacts show up. She tries again a different way, but gets the same result. Manually scanning the contact table confirms her suspicion: the records are missing. She submits an urgent support ticket to have the most recent backup restored. As the developer of the database, you receive this request minutes later.
With the long list of new features being released in FileMaker Pro 17, one item that piqued the interest of my inner geek was this new function: Get( UUIDNumber ). This new function is useful because now you can store your UUIDs in a Number data-typed field instead of having to use a Text data-typed field. My hypothesis is that storing Numbers in the database will take up less space in the file. (I’m not sure where I got that notion, but it’s stuck with me for a while now…perhaps it was the Tech specs from an older version, where it described the minimum size needed to store numbers vs. text.)
It was good to see folks again this month, for another meeting at AppWorks command HQ. (I missed last month’s meeting, unfortunately. I was looking forward to hearing the stories from Pause on Error.) Here are some of the highlights.
There are big changes in the licensing of FM 17. AppWorks’ own Shawn Prado has a thorough article covering that topic. When you purchase a 5-user license you get 3 copies of Server now. That raised an interesting question: Does this mean you can put one of those on FileMaker Cloud with the BYOL option, instead of buying one through the FM Cloud interface? It used to be that when you used the BYOL option your server license would get converted to FMCloud and NOT be returnable to standalone server installations at a later date if you moved off the cloud. This then led to some discussion on hosting and server environments.