360Works at DevCon 2018: Discount Extended!
We had a great time at the 2018 FileMaker Developer Conference in Grapevine, Texas. Nothing gets the 360Works team more excited than demonstrating our products and meeting other FileMaker Developers! We are pleased to announce that we will be extending our DevCon discount until Friday, August 17, 2018. Enter code DEVCON18 at checkout and receive 15% off of your purchase!
Use the product table below to learn more about your favorite products and take advantage of the discount.
At DevCon this year, Joe Martin demonstrated the brand new 360Deploy 2 for completely automating deployment of development changes to a production server and Jesse Barnum demonstrated a new version of MirrorSync, version 5, which has more convenience for end users and over 40 improvements to reliability, speed, and stability.
At our booth, the MirrorSync Setup Station allowed many DevCon attendees to return home with a fully functional sync setup and Richard Carlton Consulting gave out free FileMaker 17 training books at our booth this year!
Click on any of our product links below to learn more or use the discount:
Product Name Product Description 360Deploy Automated, simple deployment of new database versions Charts Easy-to-use charting for FileMaker CloudMail Send and track email marketing campaigns Email Send and receive text and HTML emails in FileMaker DocuBin Document and digital asset management FTPeek FTP upload and download from your FileMaker database JDBC SQL access with JDBC Compatibility MirrorSync Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases Plastic Payment processing plugin RemoteScripter Trigger scripts on FileMaker Pro from the web or IWP SafetyNet FileMaker Server offsite backup Scribe Read and write PDF, Word, and Excel files ScriptMaster Adds many new functions & create custom plug-ins SuperContainer A better container field Web Assistant Access internet resources, URLs, and fill out web forms Web Services Manager Publish FileMaker scripts as XML Web Services Zulu FileMaker calendar sync Stay updated with 360Works
Am I righting in thinking I can use a case statement to evaluate two fields and return an answer into a third field ie: Field A has the number 27 in it. Field B has the number 32 in it. Could the case statement look at the difference and put the difference in Field 3.The difference being 5?
I’m also trying to get this to do the math on data entry, so the figure in Field A is 27 but when the user enters the new figure in Field B (i.e 32), it looks at that difference between A and B, copies the difference of 5 to Field 3 and then also copies the figure 32 from Field B into Field A thereby updating Field A to the new value.
Help, suggestions or thoughts will be greatly appreciated.
I have inherited a database in Filemaker 12 on Windows, but I am completely new to databases. I have a script which generates and saves a pdf for each person using fields from their record. This works well.
I then have a second script which is meant to email each of these pdfs to the corresponding person. I have included screen shots of the script and the "send mail" options.
When I tested it by putting only my own email address in the To: box, it sent me hundreds of emails each with a different name in the text, and the correct corresponding pdf attached, as expected.
Very embarrassingly, when I tried to send the pdfs out, it sent an email to each person with the right name in the body of the text, but all with the same email attachment (for the first person in the list)! What did I do wrong?
Thank you in advance for any advice you can offer.
I am not a FileMaker power user by any stretch of the imagination, nor does my question relate to any particularly sophisticated use of the program, so I hope others here will forgive and bear with me.
I formed a band my junior year of college with guys who have remained my best friends throughout all of the subsequent 46 years. Though we’re scattered in different parts of the country now, we reunite at least twice a year to make music again, and for the past 23 years we have recorded songs together at these reunions.
I created a FileMaker database to chronicle these recording sessions, and all of the songs done at each of them. The record for each song contains the fields you might expect: Title, Songwriter; Original Artist (for songs we didn’t write ourselves); Year; Session; Lyrics; and a repeating field for personnel — i.e., who sang and played what on each song. Each band member also has a Comment field so he can share his feelings about the song or memories of the recording session for it.
We store the master copy of the database in Dropbox, and all can access it at any time — though I’ve put a system in place to ensure that no more than one person at a time can modify or add data to the file, to avoid the dreaded “conflicted copy” syndrome.
Each record in the database also has a Container field for the recording it pertains to. To avoid the unthinkable bloat that would result in storing 23 years worth of .wav files in the database, I naturally used FileMaker’s “Store only a reference to this file” feature for this field.
The music files themselves reside on a 128GB thumb drive. The plan was to strike exact copies of this Master thumb drive for each band member that they would physically insert into their own computers, so the the song associated with a given record would play when they access the database and double-click the Container field.
Perspicacious readers may now guess where I’m headed. I am the only one of the five of us who is on a Mac system. My Master thumb drive, as well as a copy I struck from it, works perfectly for its intended purpose. I have taken the copied drive from home (where it was created) and used it with no problems whatsoever on my work Mac. No matter which Mac I use, as long as I access the database from Dropbox and have the thumb drive inserted in that Mac, all is well — since the Mac automatically “sees” and can instantly access any external device plugged into it.
My bandmates, however, are all on Windows systems — and as my closest friend feared, when I sent that copy of the thumb drive to him. it did not work in the same way, due to Windows’ convention of assigning a letter to any external device plugged into a Windows-based machine. It appears a Windows system needs a strictly defined file path to locate the music files on the thumb drive. And a different letter is likely to be assigned to this drive in each person’s machine, based on how many other peripherals he has plugged into it at any given time.
My obvious question: is there any way around this issue? Is there some way to tell a Windows system “Look for the music files referenced in this database on the ‘F:’ drive” (or whatever drive is appropriate)? Or is each individual member doomed to manually relinking each one of the 280 or so music files that I so carefully linked on the master thumb drive?
Only my closest friend I referenced has a degree of computer savvy, so I was hoping to make this entire process as easy as possible for all concerned. Thank you very much in advance for any help that can be given.
P.S. The database was created in FileMaker Pro 11.
By john renfrew
WHen testing out High Sierra I am getting a Jav app in the dock every time I run FileMkaer with Scriptmaster. Closing doesn't seem to remove the app..
It crashed the other day a couple of times so I ended up with three icons there
What is this, can can it not be so???