kodama

Oh no worries, I didn't read anything as negative. Have a great week! :-)

I love FM, but I think it's ok to be honest that search and undo are fairly basic features in any code editor.

Missing code searching and undo are the biggest head slaps for me. My PHP-coding coworker thinks I am insane for being excited for line numbers! :-P

!GENIUS! Thank you!

Howdy! FM14 is exciting (except for the still-missing code searching)! One thing that is puzzling me is that when you are writing scripts and pop up a menu for script options (Enter Find Mode for example) and a button is hi-lighted as if you could hit return to press it. You can move from one option to another with the arrow keys, but I can't find a way to (for instance) check the pause checkbox with the keyboard. It really seems like you should be able to?

Fixed! We realized, that yes - you can indeed set an external drive as the container path, you just have to make sure that the database that you are using is actually stored in the path specified in the additional databases folders. At that point, you can specify any location for the external container.

Hello all! This is an annoying issue. I am trying to setup a container data path in FMS 13 on OS X 10.9. The directory is on a FW drive. No matter what I try, the server saves the files in FMS /Library subfolders. Here are the steps that I have taken: 1. Set the container data path in FMS to filemaker:/FMMedia/Media/ and successfully saved the changes. 2. Made sure the drive (FMMedia) and the folder (Media) have full read/write permissions for the fm server user, and even made it the owner. To test, I even tried setting the permission to read/write for all users. 3. Set up the manage containers with the correct path. 4. If I test the file non-hosted in FM client, it works great and saves the files as expected. Once I host it, there is no error when inserting a file in the container, but the files are saved in the /Library FMS directories again. I have tried many variations and still am having no luck, even trying to setup a test folder on the root of the main drive. Thank you kindly for any responses :-)

Ummm well actually that script kind of stinks in that you have to tell the calculation which fields have changed. Is there a way to tell which fields have been changed? (marked dirty)

LOL at the pic! Fitch - thanks for the reply. I guess that will learn me to read Sorry for the waste of time ;)

BTW - Here is the link to the original file from NightWing. http://www.nightwing.com.au/FileMaker/demos8/demo809.html It works fine as is, but trying to get the log to update with a commit script opens a jar of angry kittens...

(Are you son of flying pig sent to make people happy while they stand in line?) Why yes, fellow Portlander, I suppose I could, I just don't know what the script step would be, all of the obvious seem to do jack squat for me. Somehow, whatever happens when you click another field with your mouse is magically special when it comes to refreshing Text fields with inserted calcs...

I'm using a function from Nightwing to log changes in fields. The field that logs the changes is a text field with insert calculated result. It works fine if you click in another field after editing the field, or if you navigate to another record. But - This layout is set up to not automatically save changes, so my users like to use a Commit Record script. That's fine and dandy, except that the log field that tracks changes does not refresh when you commit via a script. I've tried throwing several things in the script before the commit step to trick the field into refreshing, but apparently nothing is the equivalent to clicking another field with a mouse?

FYI - I'll be doing this by just concat - ing all the code pieces & keywords with a function to find text between keywords (hopefully it works!). Thanks again for the replies and interest, people are great here! -D

I'm so busy at wotk right now, I can't give a proper reply, must create a website and fix the backup system and other things within 1.5 hours. Yay! Basically, I was working with html, using substitute to take when someone types "maintitle" in an html page (for instance) and turn that into <> and piece together all the field definitions and bits of html code to make a calc that basically outputs an html page for an email template from a calc. I got FMP to perfectly construct the calc to output the html, but the result is never actually recognized as a calc by FMP...

No, I am crazy, that didn't work. On to plan b (not the pill)....

I think I found a solution (Please tell me if there is a better way, I'm always doing 5000 things at work & feel like I'm taking crazy pills!) Fields: Name - Just text, set to john NameCalc - Set to "Hello ," & Name Create a layout text object: nameText (contents are just <>) Create another calc field: HelloCalc - Set to: GetLayoutObjectAttribute("nameText";"content")

The actual project is more complex than my example, I just wanted to keep my question more simple. I really do need the generated calc to be actually read as a calc. I know that I could just make a text object on a layout like: Hello, <> And get: Hello, John But, how can you actually get FMP to parse text like this into a calc?

Hello! So I have a calc that creates a calc. For example, the results can be: "Hello, " & FirstName and I need to somewhere actually get the "rendered" results of this result, as in: Hello, John Thanks!

As a follow up, I did end up needing the Actual driver for an MS SQL site, and it was smokin'! Very nice/easy setup, made a sweet solution to mass update, edit, & preview a MS SQL site in less than a day. No complaints about Actual whatsoever.

Hello kind FMP-ers! I don't know why, but I just can't seem to get along with this plugin. Whenever I try to send an invoice to QB, I keep getting errors that the data is out of order, or just "error". I really wish that Productive had more simple, functional FMP demo files on their site, instead of only the demo file that is not fully functional. All I need to do is: - Get customers from quickbooks with: listid balance - Get payments from quickbooks with: invoice number listid amount date - Push an invoice to qb with = listid (for qb customer) item (always set = misc) description amount date *Get invoice number back from QB Anyone had successful encounters with this plugin? Thanks! :-D

But you really can't, since only the MySQL one is supported on Windows...

Maybe part of the solution would be making them pay for the Windows connector as well...

My point is, simply: - MySQL Makes a free connector for OS X and Windows - FileMaker is advertising (big time) that they now connect to MySQL (among others) - In the fine print, you find that FileMaker can utilize the 1st party free MySQL connector made for Windows, but not the free 1st party one Made for OS X = Mac users screwed once more, even if only by $29.95 each (yes I know you have to pay for people's work, yes I believe Actual makes good connectors, yes I know software costs money, etc...) It's just a small example of something that happens time after time. I didn't even assign blame, it's just frustrating to deal with having to get permission, quotes, bidding, preferred vendor check, funding information, purchase requests, approval, etc.. for yet another item that you have to explain is needed only for Mac clients. I guess no one has ever dealt with the crap and superstition you have to put up with being a cross platform admin trying to keep your Macs?

Wow, clever response. Thanks for taking the time. I mean Vs Windows users who do not have to pay. It's something that happens time and again on the Mac and one more thing that makes it hard to keep a Mac infrastrucure in IT when managers complain about extra costs. It may be Filemaker's fault, or it may be the fault of the OS X connector made by MySQL being inadequate, either way the end result is the same.

For the Actual MySQL ODBC connector when MySQL makes one? It just seems like Mac clients get screwed once again. $29 is not much money, but when you're dealing with a cheap company with several Mac clients who need a purchase Vs. Windows clients that can have free access out of the box... ;)