fm_toxy

Hi Miss A!, Using global variables $$example means that they stay available in the background ready for use by another script. Which is great if you are about to call another script, but not so great if - you're not. As then they will sit around in your database until you quit your current session - or you clear them at the end of your script. Whereas, using local variables $example will clear automatically at the end of the execution of the current script. HTH

Hi Angus, Checking on serialio.com for your scanner, I found that it is compatible with SerialMagic Pro for the Mac which I use to handle my Intermec SF51s - turning them into a bluetooth keyboard wedge for barcode reading into Filemaker 11, 12, 13 on a pc or mac.. You do have to switch on a post-amble character for your scans, looking at my preferences, I have set a LF character, which I then trap in a triggerscript linked to the barcode entry field to process, but your post-amble character set may be different. Then you don't have to pause any script, since the scanner effects(?) a line feed - which starts the triggerscript. Which involves minimal clock cycles... The barcodes can be of any length and of any agreed standard. My Inventory system now happily digests EAN-128, UPC, JPN barcodes and Seareach Alphanumeric AssetTags. HTH

Personally, I would try to convince them about going down the ipad route, simply because Filemaker Go is free and already set in kiosk mode. And you can lockdown the ipad to run just the FM_Go app via apple configurator and running parental control on it. Has your client factored in the cost of 40 touchscreen desktops? and the maintenance and network upkeep for 3 years? Incidentally, the barcode reader app in FM_Go 13 would make an ipad swapout a breeze, as you could supply a barcode for each plinth and upon zapping said barcode, your FM_Go db could present the relevant data for that plinth. Would the plinths/museum artifacts be moved around? [so many additional questions]

how many licences of filemaker pro have you got? 1 licence in use on multiple machines? hence the lockout... [sounds like one licence got baked into a machine build] Or 1 licence per machine? therefore a site licence for n machines...

FMStudio pro is still available. 5 minutes googling provided me with this: http://www.fmwebschool.com/fmstudiopro.php $157 for the full version - compatible up to fmp 12. $89 upgrade from v1 and you can pay with all major credit cards or even paypal.

Hi Bikeman17, Based on your profile, you shouldn't need to install Helvetica Neue as this is a system font built into the mac. A second installation of Helvetica Neue may clash with the main system font - with the result that all window titles, filenames and other desktop furniture becoming blank. As for the PC, you may find that you have to adjust the tracking on your titles to bunch up the characters.

Hi fmforums! I'm drawing up a simple database management tool to manage multiple databases in FMP11. Nothing fancy, just the ability to assign users to multiple databases on FMServer 11, and then run a script to add these users to the assigned databases. I have created the following fields in my database table: Filename ExportFilename SvrLocation WinLocation MacLocation on the basis that the database filename would be recorded under filename and the full path to it would be recorded under WinLocation - if stored on a PC, MacLocation, if stored on a Mac and SvrLocation if stored on a server [just covering the bases] The script step that I'm having issue with is: Open File I was under the impression that Open File would allow me to provide a variable path similar to the Export File Script step. In that you can do: Set Variable $path = Database::MacLocation & Database::ExportFilename Export File using variable $path Is there some way that I could reproduce this flexibilty in the Open Path script step so that I wouldn't have to re-edit the script everytime a new database is created? Any suggestions would be appreciated.

try http://www.thebarcodewarehouse.co.uk/

I’ve seen this when the path to the pdf generation folder I made on the FMServer got moved or deleted by another 'helpful' member. I would agree with IdealData, is your clients $savepath identical to yours? If not, that would be the problem. Also, does your clients FMServer have write access to the folder?

You'd have to quote what NAS drive you’re using and what version of unix it is running. The above commands apply to Mac OSX, as far as I can tell.

Apologies for not replying sooner, your solutions sparked off other ideas. However, I found that the script wasn't picking up the current table name in a single script step. so I had to split steps thusly: Set Variable [$table; Value:Get ( LayoutTableName )] Set Variable [$table_flag; Value:$table & "::flag"] Set Variable [$field; Value:GetField ( $table_flag )] If [$field = 1] Set Field By Name [$table_flag; 0] Commit Records/Requests Exit Script [] Else If [$field = 0] Set Field By Name [$table_flag; 1] Commit Records/Requests Exit Script [] End If Once corrected, I was able to handle both unmarking a record and flagging it for deletion. …and some time after that, handle multiple randomly flagged records for unmarking and flagging for deletion. …and a bit after that, handling multiple flagged records for grouping, scripting email replies, canned guides… I now just have to update some 90 layouts with 30 individualised delete scripts to one script and I'll be a happy bunny! Oh and stick a marker button on each

Hi fmforums! It's been a long time since I last made a post, as just searching through the available content here has usually answered my questions [if I search long enough] I'm currently reworking my scripts so that they become universal in my database - less maintenance you see… And I would like to know whether anyone can shed some light on a rambling question I have? In all of the underlying tables, I have some regular number fields, such as: flag, delete, marker… Dependent on their auto-enter calculation at record creation, they’re either 0 or 1. I’m trying to change my script steps so that a script created is independent of any table, for example: table_alpha::delete table_bravo::delete table_charlie::delete …used to require three separate scripts to set each table record’s delete field, now just requires one script: Set Variable [ $t ; Value:Get ( LayoutTableName ) ] Set Variable [ $t ; Value: $t & "::delete" ] Set Field By Name [ $t ; 1 ] Commit Records/Requests However, I presently seem to be hitting a wall on getting a field’s contents based on a variable generated in the script, for example: table_alpha::marker table_bravo::marker table_charlie::marker allows me to mark several records at a time in different tables, but I want to be able to toggle its field value to 0 or 1, through a script. So following the above line… ( assuming table_alpha::marker = 1 ) Set Variable [ $m ; Value:Get ( LayoutTableName ) ] Set Variable [ $m ; Value: $m & "::marker" ] Set Variable [ $flag ; Value:GetFieldName ( $m ) ] … should return the value of "table_alpha::marker" to $flag if script is run from table_alpha, return the value of "table_bravo::marker" to $flag if script is run from table_bravo, return the value of "table_charlie::marker" to $flag if script is run from table_charlie then I would intend on continuing by testing $flag further along in the script If [ $flag = 1 ] do something Else If [ $flag = 0 ] do some other thing End If Commit Records/Requests However, I've tried the following versions of the script step in red, with the following results (assuming table_alpha::marker = 1) Set Variable [ $flag ; Value:GetFieldName ( $m ) ] = Error 5 - command is invalid Set Variable [ $flag ; Value:GetFieldName ( "$m" ) ] = table_alpha::marker, instead of value of table_alpha::marker Set Variable [ $flag ; Value:$m ] = table_alpha::marker, instead of value of table_alpha::marker Any suggestions would be appreciated.