Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Cable last won the day on August 15 2015

Cable had the most liked content!

Community Reputation

3 Neutral

About Cable

  • Rank
  • Birthday 04/29/1974

Profile Information

  • Industry
  • Gender
  • Location

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Windows 10, Server 2018

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

2,398 profile views
  1. case( datefield = get(currentdate);"Today"; datefield = get(currentdate)-1;"Yesterday"; datefield ) Must be an unstored calculation and type = text as noted above.
  2. It worked! I also wrote a calc to tweak the speed based on the total length of news items so it will dynamically adjust as stories are added during the day. Appreciate the help.
  3. I'm going to try that. Attempt 1 failed but I think I was just trying to cram too much into one (I was putting all the stories in one div instead of breaking them out). Thx.
  4. Ok, that helped. I went with this code I found: "data:text/html," & " <!DOCTYPE html> <html> <head> <title>News Ticker Demo</title> <style> @keyframes ticker { 0% { transform: translate3d(0, 0, 0); } 100% { transform: translate3d(-100%, 0, 0); } } .tcontainer{ width: 100%; overflow: hidden; } .ticker-wrap { width: 100%; padding-left: 100%; background-color: #FFFFFF; } .ticker-move { display: inline-block; white-space: nowrap; padding-right: 100%; animation-iteration-count: infinite; animation-timing-function: linear; animation-name: ticker; animation-duration: 30s; } .ticker-move:hover{ animation-play-state: paused; } .ticker-item{ display: inline-block; font-size: 3rem; padding: 0 2rem; } </style> </head> <body> <div class=\"tcontainer\"> <div class=\"ticker-wrap\"> <div class=\"ticker-move\"> <div class=\"ticker-item\">Lorem ipsum dolor sit amet, consectetur adipiscing elit.</div> <div class=\"ticker-item\">Aliquam consequat varius consequat.</div> <div class=\"ticker-item\">Fusce dapibus turpis vel nisi malesuada sollicitudin.</div> <div class=\"ticker-item\">Pellentesque auctor molestie orci ut blandit.</div> </div> </div> </div> </body> </html> " Now, what would be the best way of replacing the "latin" placeholder text with news? My problem is that there can be anywhere from 5-200 news stories to put into the ticker and that the number of stories can change during the day. At first I thought I'd just brute force it and loop thru all the news stories and put them into one text field to scroll but I'm hoping there's a more "mathy" way of doing it...
  5. I have a FileMaker solution that powers an internal "TV network". It runs over Intel Compute Sticks which have FileMaker installed on them and are connected to TVs mounted to the wall throughout the facility. A FileMaker script runs through various layouts and steps thru records on each layout. This lets us show a calendar, weather report (in a web viewer), company news, birthdays, customer feedback, employee recognition, and pictures. I would like to add a news ticker to the solution, like you'd see on CNN scrolling across the bottom. I have a table with the news stories in it. Since you can't run more than once script at the same time, I have a script set on the server to step through the news stories. For each story it uses "set field" to put the story in the field one letter at a time, then cuts off the left side when it gets too long. I then set the solution to open a floating document window at the bottom to display the layout that has the new field on it. In theory, it should then appear that the story scrolls across the screen. It doesn't really work. It is jumpy and sometimes just doesn't show at all. This is the gist of the script for the ticker: Loop Set Variable [$message; Value: (news story)] Set Variable [$letter; Value: 1] Loop Set Field [Data::News;Right(Data::News;68) & Middle ($message; $letter; 1)] Commit Records/Requests Refresh Window [] Pause/Resume Script [Duration (seconds): .05] Set variable [$letter; Value: $letter+1] Exit Loop If [length($message) < $letter] End Loop Set Field [Data::News;Right(Data::News;68) & " | "] Commit Records/Requests Go to Records/Requests [(If ( Get(RecordNumber ) = Get(FoundCount);1;Get(RecordNumber ) + 1)] End Loop I've tried it with various pause durations, with/without the refresh, and with/sithout the first Commit. Nothing works the way I want. Has anyone successfully implemented such a thing?
  6. Is anybody else seeing an issue with exporting to .xlsx in FMP 18? I have a scripted find/export that has never been a problem before. But, ever since I updated to FMP 18 I sometimes get errors with the Excel spreadsheet that is created. As you can see in the attached, if I make my changes and hit save it says I have to Save a Copy (if I use the same name it saves over the top of the open file just fine) because the original spreadsheet was an "older version of Excel". If I open it and try to save immediately, I get an error saying a "new version [is] available". I am using FileMaker Pro 18 on a Windows 10 machine and have Office 365 Premium.
  7. Did you ever get this figured out?
  8. I have a similar issue and today I finally traced it to the fact that even though I specify the domain to the server if I add the file as a favorite it will try to use the "server.local" path and show the orange lock. If, instead, I start to open the file, specify the domain, then right click on the file before opening it I can add it as a favorite and it holds the domain.
  9. No, I don't really use many of those and quite a few of the users don't do anything that would call one. Some research back to FMS 14 showed it was happening sporadically even back then and attributed to DNS issues. Just odd that it seems to be happening all of a sudden.
  10. I'm having more and more problems with users getting the error that they can't modify a record because they're already modifying it in another window. Except that they aren't. When I look at the server admin console, though, I'm seeing multiple connections for each user. One guy is showing 32 connections! Anybody have any idea what is going on? Windows Server 16 FileMaker Server 16
  11. Is anybody else having major problems with FileMaker Server 16? I'm having certificate problems, connection issues, scripting errors and now major calculation errors. It started out with repeated errors stating that my SSL certificate (which worked just fine in FMS 15) wasn't being recognized and I kept getting the "cannot verify server's identity) error. I keep having problems with multiple stranded connections. For example, there have been times when I know not one single person is logged in (because we've been closed for hours and hours) and yet there will still be dozens of connections on the server. Then when I look at the detail some of them will be for the same user showing as being connected six or seven times. A reboot fixes. Then starting yesterday I started having problems with calculations giving completely wrong answers. For example, I have a chart that bounces sales numbers against a sales goal. The report this morning showed one salesperson had a goal of $32,479 and actual sales of $32,770. The chart showed that she is at 3% of her sales goal. Not. Even. Close. If I run the report manually, it is just fine. I also have a problem with some scripts. For example, I have one that checks a table for items that have been inactivated and deletes prices in a related table. Except instead of doing that it is just randomly deleting hundreds to thousands of prices. Again, if I run the script manually it works just fine. Only a problem when the server runs it. Something seems to be majorly wrong with Server 16. I'm close to declaring it a bust and going back to FMS 15. I just really hate to lose the new PDF generator (from the server) which I have been needing for years.
  12. Log viewer shows errors up the yin-yang...
  13. I'm having multiple connection issues with FileMaker Server 16 running on a Windows 2016 VMWare server. Background: I had my solutions running on a virtual server hosted with FMS 15. I started to have problems with overnight scripts not running and random slowness. My VMWare vendor suggested moving FileMaker to a new virtual server. I figured as long as I was moving I might as well upgrade to FMS 16. That process was completed yesterday. The old server was called Bloodgood and the new one is Bonsai. I'm still having problems with my overnight scripts running and I think they're related to additional problems I'm having. I have a SSL certificate for the server. When I log into a database using FMPA 16 on the server, I get repeated errors that "the connection to fm.willowaynurseries.com:5003" is not encypted". I'll check off the box to always permit connection and hit the connect button and the lock will turn green. After a bit (seconds to minutes) the lock will turn orange and I'll get the connection message again. It is noteworthy that the SSL cert is ties to willowaynurseries.com and when the server was on Bloodgood if I tried to connect using the Remote button and let it find the local.Bloodgood server over the network I would get the connection error message but it didn't specify a port and once I told it to allow the connection I'd have no further problems. Also, if I open one of the overnight scripts, it shows that same message but also shows that scripts referenced in other databases are "unknown" (see attached). As I scroll through the script it will also pop up an "open file" dialogue box, but won't tell me what file it is trying to open. Even more oddly, none of this happens if I'm using FMPA 16 on my computer. Only if I use it on the server. Does anybody have any idea what might be happening or how to troubleshoot/resolve?
  14. Ok, yes, you're right. That put me onto the (clunky) solution for me. I already have a keybaord shortcut set to switch from the custom menu to the standard one. If I do that keyboard shortcut first, then the ctrl-alt-s works. Not as easy as just clicking one button as before but it will work, thanks!
  15. It ends up being extra work either way. Either I modify the login scripts to recognize me and put the menus back or I add a special button bar and hide it for everyone but me. All because of a new "feature". They should have just left it alone but apparently forgot to consult me.
  • Create New...

Important Information

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