Greets, and a happy, holiday season to all.
This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command:
"cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" )
...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error message in the Script Debugger, " Command is unavailable (for example, wrong operating system or mode)".
So, I'm trying to figure out why the command's failing--could it possibly be it's because I'm using FMP (PC) in VMWare's Fusion PC emulator (v10.1.4, running in OS Mojave) instead of on a "real" PC? Any ideas for a tweak/fix?
Does anybody know how we can workaround this behaviour of FileMaker Server/Client 15 on Mac/Windows:
If we are inserting an image into a container field which stores the files externally and the filename is more than 50 characters, FileMaker strips the filename. I know that we cannot change this, but the problem is that another field which stores the filename for InDesign does not get attention to this.
Is there a way to read the stripped containerfield-filename of FileMaker so that we do not have problems with longer named images?
Thanks for any help…its driving me crazy :-(
Good evening people. As the title states, I am a complete newbie to FileMaker Pro. I've done some fairly extensive work with Excel, but this is my first experience with databases.
For now, I'm looking for advice and suggestions. I promise I will have plenty of "how do I... " questions later, but for now I need to pick a direction to go in with my new project. I've spent a bunch of hours viewing Intro to FileMaker tutorials on YouTube and I've experimented with creating a couple test databases. If this is not the correct forum for this question, please let me know.
So, my wife and daughter are heavily involved with riding horses. I've been drafted into being on the Board of Directors for our state Quarter Horse Association (Quarter Horse is a breed like Thoroughbred or Clydesdale). The first thing I discovered is that they have NO association membership database of any sort. What they do have is simply a file folder of applications for members, one folder for each year. Me being an I.T. geek by trade, I know there is a better way. I've at least entered the info into a spreadsheet (my specialty) so we have the info electronically to be able to reference current membership status during our shows.
I wish to create a database for the membership, which I've done so far. It has basic info - name, address, etc. I have an ID field that automatically increments with each record - seems to be a strong recommendation in the tutorials I watched. I have a field that combines the first & last name fields which I plan on using for looking up membership info, sending renewals, etc later. I also have a membership year field and here comes my first question. When I renew a member for the new year, I want to keep the previous year's record in the database - should I ever want to print a report for 2016 membership in 2019 for instance, I can. So I figure I need a static member ID field that is separate from the record ID field I already have that can be linked to another database which will hold that member's horse information. Is it possible to have a field that will increment serially when I add a new member but will copy from the previous year's info when I renew a member for a new year?
I'm looking for any and all suggestions - links to videos that might help - suggestions for a better way of accomplishing my goal, anything at all. I'm not a programmer so I don't have that background FYI.
By Roark Holz
Hello, I am wondering if someone can help me understand how external container fields work in FileMaker 15. For testing purposes I have created a very simple database shared from our FileMaker 15 Server, the database has two fields, a single text field and a single container field. I have set the container field to store files externally which works, the files end up in a subfolder on the FileMaker server where the database itself resides.
Now I would like to change the external location where the files associated with the container are stored, I found a section in the manual called "Managing external storage of container data" but this is where I am running into a problem. While logged into the database as the admin user I go to File-->Manage Containers. There is one location listed under Base Directories: "[hosted location]/Container Test/" however all of the buttons that I should be able to use to manage my containers are grayed out (New..., Edit..., Delete and Transfer Data...). The only buttons in there that work are cancel and OK. It seems like a permissions problem but I am logged in as the admin user with full access.
Can anyone tell me what I might be doing wrong?
Ultimately I would like files uploaded to my container fields to be stored on a file share, either referenced by UNC path or by mapping a network drive.
Thanks in advance for any assistance anyone can provide.