millmaine

I had already checked that the path was valid. Got the user to run a script that retuned the file path. All as it should be. On the windows computer we have run a FMP export script with error-logging on which results in an 800 error — "Unable to create file on disk." The user gets the following alert from Filemaker: "WC2282021-C-63768442785.csv" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk." That seems to indicate that FMP doesn't know what's causing the error — only that it can't create the file. The user has asked whether McAfee antivirus might have some bearing on it. What do you think?

My two favourite experts at odds!! The problem manifests itself by no file being exported when Windows machine is being used. I will add some error capture alerts to the script. An added difficulty is being 1000km away from the operator and not having a Windows computer myself.

I have a script where I want to export a csv file and I would like it to work on both mac and windows. At the moment it works fine on macs but is not working on Windows. I have a script step to create a variable $path1 Substitute ( Get (DesktopPath) ; "Desktop/" ; "" ) Then in Export Records script step in "Specify Output File" I have: filewin:/$path1/Dropbox (Millmaine)/Finance/FROG_Invoices/CREATIVE/$invoice_name filemac:/$path1/Dropbox (Millmaine)/Finance/FROG_Invoices/CREATIVE/$invoice_name I have checked with our operatives and the directory sequence after $path1/ is consistent (i.e. nobody has any additional folders/directories). Our DB is hosted on Filemaker Cloud. Any idea why it's not be working for those on Windows?

You're correct. It is a text field with calculated value. This is because, for some categories, the user will enter the information. For other categories, I want it to be entered automatically. I have resolved the issue with a script. I see your point about creation date rather than current date and will adapt the script accordingly. Thanks. It still puzzles me why the calculation works when it is stand-alone but doesn't work when encased in an IF or CASE.

I have table called Resources that contains a field named "Name". There are a number of other fields but the relevant ones are a field named "Category" and field named "Project". I want "Name" to be a calculated value. If I use the following simple calculation it works fine: (Right(Year ( Get(CurrentDate )); 2)) &"-"& (Month ( Get (CurrentDate ))) &"-"& Substitute ( Project ; " " ; "_" ) & "-RetargetingPixel" This is the result: 21-02-Project_Name-RetargetingPixel However, if I enclose the same calculation in an IF or CASE function, for example: If ( Resource_Category = "Retargeting Pixel"; (Right(Year ( Get(CurrentDate )); 2)) &"-"& (Month ( Get (CurrentDate ))) &"-"& Substitute ( Project ; " " ; "_" ) & "-RetargetingPixel"; "Test" ) and choose "Retargeting Pixel" as the Resource Category the result is: 21-02--RetargetingPixel What happened to my Project? Actually. I may have figured this out — to a point. It works fine if I'm in the actual Resources table. The problem occurs when a record is created in the Resources table via a portal in a related table. Operationally, that's the way I'd like it to work but it could it be the Project field (also a calculated value) is not populated before the Name field calculation runs. Is there a way of ensuring that calculation occurs first or would I be better off using a script to populate the Name field?

Hi Extreme, The whole script is pretty long and specific to our company, however the critical steps are: Early in the script: Set Variable [ $path1 ; Value: Substitute ( Get (DesktopPath) ; "Desktop/" ; "" ) ] Set Variable [ $filename ] Then when you get to the Save Records as PDF script step the Specify Output File should be: filewin:/$path1/Dropbox/Folder/$filename filemac:/$path1/Dropbox/Folder/$filename Where I have used "Folder" you could put the name of the folder of your choice or you can create folder names as variables as part of the script.

Don't worry. I have figured this out using Get(DesktopPath) to identify where the shared folder will be on each user's computer, saving that as a variable, then including that in the filepath when saving PDF.

I have seen various articles and videos that explain how to upload a file from a Filemaker Container to Dropbox using the Dropbox API. However I would like to create a script so that a user can save a pdf directly from Filemaker to a shared Dropbox Folder. Any tips?

The scripted loop may be the case re the continuing lockout. I'll look into that. My real query is why does the option to send a message to the other user appear but never work. It seems to have been that way since at least FM7. During that time we've moved from peer to peer, to FM Server, to FM Cloud for AWS to FM Cloud. The same circumstance has always offered the send message option and it has never seemed to work. It's not referred to any documentation that I can find.

Over the years, we've run into a situation where two people try to access the same record at the same time. A message is displayed saying "Name (username) is modifying this record. You cannot use this record until Name (username) is finished." Two responses are offered "Send Message" and "OK". If you click "OK", the message simply comes up again, so as well as being locked out of the record you are effectively locked out of using Filemaker. If you click "Send Message" a dialogue appears headed "Message to Send" with a field enabled for a message to be written. Despite having tried this many times over the years, nobody has ever received the message. Does anybody know more about this?

All good. Figured it out using Case.

We have a table of Items. Each Item has a Category field. Each Item has a Size field. Depending on the Category, the Size may or may not be required. I am trying to use "Validate by Calculation" on the Size filed so that an alert is shown if it is empty when the Category requires that it should be completed but no alert is shown if the Category does not require it. So far I have had no success. I'd welcome any tips.

Thanks again. You're right it works fine when using a Schedule layout with a portal to Line Items, however the updating issue occurs if using a Line Item layout with the "Item Count Invoiced" field in a sub-summary by Schedule. Any tips for this?

Thanks. Did as you suggested and made "Invoiced" a Number field (with checkbox ) and then used Sum. It works, however I find that I sometimes need to click in the Sum field to force it to show the updated calculated amount. Is there a reason why it doesn't always automatically refresh when the Invoiced field in related record is updated?

I have a table "Schedules" which shows related records from "Line Items". When viewing a Schedule there is an "Item Count" field which shows how many Line Items are in that Schedule. Each Line Item is marked with simple Y/N Radio button when Invoiced. I would like to have a field on the Schedule that shows how many of the related Line Items have been invoiced. I can do it with a script but would prefer a calculation if possible...but I just can't work out how.