Hi, I get error 800 in the "Export Records" script step when executing it as PSOS.
The file path is set in a variable ($path) as a calculation:
This script works well when executing it to save the file to the local temporary folder (OS X El Capitan), but returns an error when executing it as PSOS (Windows Server).
I believe it can be a permissions issue, but I thought the temporary path was accesible from FM Server "by default". Anyway, any insights are appreciated, thanks!
I have a global variable that has been set from previous a script. This global variable is $$abc and has a value of 100.
I have two fields on Table A, Field1 and Field2. Field 1 has a value of abc, and field 2 is a calculation field with this formula: (Evaluate ( "$$" & Field1 ) ). The calculated result, in this case, should be "100" since that is the value of the Global Variable that I have set on the previous Script.
However, I don't know what I am doing wrong. I Evaluate the formula on data viewer and it evaluates it correctly, but on the calculation field, it is just not working. I have tried to set the formula as $$abc directly, and still, it does not perform the calculation on the field.
Any ideas would be much appreciated.
Thanks a lot in advance for your time.
I just solved the problem, it seems that calculation needs to be set to not store calculation results.
Thanks a lot for just reading this!
Has anyone had the following issue and might have a quick fix. I migrated client files from FM Server 13 residing on Mac Server to FM Server 14 residing on Windows Server. All went very well except one thing, which i would be grateful if someone could help me on. PREVIOUS STATE - The client had his files hosted on OX platform and with FileMaker 13 Server. - There is a container field in the records that would contain pdf files, these are 1 or more pages document files. - When the user dragged the file into the container field it would display as page thumbnail BOTH on Mac and Windows. AFTER THE MIGRATION TO WINDOWS SERVER - files still display thumbnails when dragged on MAC - the files are displaying FILE ICON when dragged into the container on WINDOWS. Tech boards are suggesting that Windows can not insert the file as picture into the FM container field, but there it happened before. Does anyone have any isight on this behaviour, is it documented anywhere? Thank you
I'm looking to create a script and place it in a button to exist on two layouts (BACKUP and MAIN), to accomplish the following when activated from either layout:
Copy current ACCTNUMBER
If current layout is MAIN
then go to BACKUP layout and show the same ACCTNUMBER record.
current layout is BACKUP
then go to MAIN layout and show the same ACCTNUMBER record.
....I'm sure it's a no brainer but right now I'm totally missing some small step to start the script ....help?
By Per Waagø
I seem to find variating answers to this topic, so here I try again.
How do I use a variable to perform a find in a script? I want to use the field contents of the current record to search for similar records.
Background: We send a lot of people out to different countries and I want to make a script that makes an excel sheet with various data based on the country field of the current record. Hence, if the current record is going to France, I want to see everybody that we currently have in France etc. However, we have two return dates so I need to do two searches:
1. Country+ departure date <=// + arrival date >=//
2. Country+ departure date <=// + Extended arrival date >=//
Is it really true that perform find cannot handle a variable?
Hope you can help.