Yogi Bear

Hello, We have just moved our FM CRM from being hosted on a P2P network to Filemaker server 14. Going forward we also want to attaché documents to clients. As these attachments might be large, it might be an idea to have them stored in an external container. There is a default container linked to the DB but I can't edit it or change the location. (See picture). Ideally I would like to specify a UNC path and have them stored in a separate folder on our Fileserver. 1. Am I correct that there is no way to change the location, or am I missing something? 2. Is there way to change the name of the path? i.e. the original DB name was invoices but now is called something else. Where do I look? 3. What do other people recommend for storage of attachments? Our old CRM generated thousands of files totalling ~ 15Gb over 4 years. I just can't seem to find very much info on this topic on google. Feel free to to send me lmtgfy.com link Platform: Filemaker Pro 14 / FMS 14 running on Windows 2012R2 Best regards, JS

Hi, We're trialling using Ipads to access our custom CRM system. The Database is hosted on a Filemaker server and we're working directly with it (4G or Wifi). Everyhting works well and I'm surprised how little effort it took to make some custom layouts and integrate. On the Ipad there are a couple of layouts where staff can do searches (e.g. Client list). As per our desktop layout, there is a "Find Mode" button to put FM into find mode, the query is entered, and then we get the result. This works fine when I log in as an Admin user (which I am). It does not work for users who are not admins. FM Go enters find mode, the users enters the query, but when you click go on the onscreen keyboard the find is not executed and FM Go stays in find mode. Is there anything I'm missing? Thanks, in advance, JS BTW Using Filemaker Server 14 / FM Go 14.01 and there are no permission issues when clients use the Desktop FIlemaker to perform similar searches.

Thanks for your quick response! Your suggestion of moving to next object by enabling "Return" under the inspector worked. However, if I run the script using OnObjectExit as the trigger it went into a never ending loop just creating records. Not sure why? Doing some more research, I found that adding: Exit Script [Result: False] to my original script fixed it. There is an explanation at http://forums.filemaker.com/posts/87c74253ef which states: Is this within a script performed by a script trigger? If so, that could explain it. The Exit Script [False] step cancels the pending event that fired the script trigger and might be an event that would otherwise put the cursor in a different location as it takes place after Go To Field. You can look up "setting up script triggers" in FileMaker help to see a table of all triggers and which perform scripts before the triggering event and which perform them after the triggering event. although how this relates to my script / layout I'm not entirely sure? Best regards, JS

Hello, We have a simple Filemaker solution which tracks stock we order from suppliers (Item ID (unique Key), Description, Category, Invoice, Serial Number, Date, etc) which we used to track stock and print labels from. (Table: Stock Items) I would like to make an improvement to this by adding a stock take functionality. As we barcode the items and print the Item ID I would like someone to be able to walk around the shop and scan each barcode and then we can generate reports from there. The barcode scanner is setup to add a carriage return at the end of the scan to move on to the next line. I have setup a table called "Stocktake". We just want to enter the Item ID and then other fields can be looked up. (see attached screenshot). The issue I have is that I struggle for FM to create new records. What I have setup is created a script which makes a new record, and sets the focus to the field Stocktake:Item_id - New Record/Request - Go to Field [Stocktake::Item_ID] I have then added a trigger to the Item_ID field which on "OnObjectSave" runs this script. I have two problems: 1. If I type in a stocknumber the record is entered into the table, the script runs (can check it using tools), a new record is created but when the script finishes the focus is not on the Item_ID field. In fact there is no field that has focus applied. However, if I manually click on "New Record", or manually run the script the focus is on the field Item_ID for entry for the next item. 2. I notice that the record only is recorded if I press "Enter" on my numeric keypad. If I press "Enter" on the main keyboard it will not save the record. I am aware that on a Mac these keys are treated differently. What do I need to configure here? The scanner we use for barcodes has been configured to add a carriage return but this appears to be the same one as the main enter key and does not enter records. I must just be doing something simple wrong. If anyone could give me some guidance it would be greatly appreciated. Platform is Filemaker 12 Advanced running on Windows.