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,453 profile views
  1. Thanks but none of that is even remotely helpful.
  2. Sure, if it was a date field. But this is a text field so that won't work.
  3. Ok, I think I understand. Like I said, create a relationship from the Inventory table to the bin table. Set the relationship to be the Bin in the Inventory table to relate to the Bin name and make that relationship "does not equal". But also set it so that the relationship does equal the key/foreign key for the item in inventory. Then, create a value list with the option "Use Values from field" and specify the BinName field. That will show you only bins where the item exists but excludes the bin it is currently in.
  4. No, that's not how I understood your question. I'll look at it again tomorrow and try to understand what you're trying to do. It would help if you uploaded a sample of the tables and what you're trying to do.
  5. Ok, create a table with one record for each bin in a field called BinName. Create a relationship from the Inventory table to the bin table. Set the relationship to be the Bin in the Inventory table to relate to the Bin name and make that relationship "does not equal". Then, create a value list with the option "Use Values from field" and specify the BinName field.
  6. Can you set the value list to be a related value and set the relationship to exclude where Bin = current bin?
  7. Are you trying to create Y2K all over again????? lol Substitute ( datefield; year(datefield); Right ( year(datefield); 2))
  8. case( datefield = get(currentdate);"Today"; datefield = get(currentdate)-1;"Yesterday"; datefield ) Must be an unstored calculation and type = text as noted above.
  9. 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.
  10. 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.
  11. 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...
  12. 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?
  13. 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.
  • Create New...

Important Information

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