sawhillr

Hi Steven, Let me explain a bit more. The server is mainly set-up as a general file server and the DB is mainly accessed/edited directly on the server Mac itself. This guy is going to be doing editing remotely and will be doing so when no one else is accessing the DB (locally or remotely). In the long run, we will switch to FM Server, but at this point it is not financially viable and the amount of remote need is minimal (1 remote user, no simultaneous users). Once the business picks up and there is need for remote access we will be able to switch over. Hope this helps clear up the situation. Thanks Roger Let me add, I can do this via Mac with no problems and it's just the browser having to go through the server via vpn that is killing us.

Please let me know if this is not the right forum for this question. Background: — We have FM Pro 10 Advanced loaded on a Mac OSX server in NY. — We have a contractor who has been hired to edit database content in Kentucky on a Windows Vista laptop running FM 10 Pro. — We have successfully set up a VPN connection and have remote access to the DB files (using favorite hosts and setting a local/internal IP address for the server network). Problem: When VPN connection is active, internet browser connection slows to a stand still (even though FM works fine) and he must have access to both while editing the DB as he uses browser to gather data entered into the DB. I am a Mac guy, but through a PC buddy of mine, I found that the PC tends to default to using the VPN connection for all internet traffic and was thus serving all traffic, including browser traffic, through the server in NY. So, I turned off Use remote gateway as default in the Network properties section on the PC. This immediately fixed the browser problem, but also killed FMs ability to see the remote files in Open remote. Does anyone know how to either: 1)get FM to see the remote files when VPN is on and Use remote gateway as default is off? 2)how to get the browser to bypass the VPN without it compromising FMs connection? thanks guys Roger

many thanks everyone. I freely admit my brain is still back in the days of the original flat file DB mentality of Filemaker. I have used it here and there over the years and have been thrust back into it to fend for myself. This project is probably too far up the river to go back and restructure but I appreciate the advice and will look into changing my ways going forward. For those that suggested GetField, I had tried it but with no luck, will go back and see if I missed something and/or try Evaluate. Again thanks for your patience and support

wouldn't surprise me if I suffer from basic design issues, have been self taught and my needs have grown sporadically over the years. Database 1 is a sports score DB that stores daily scores (up to 20 games per sport per record) for 6 different sports. Each field (MLB01, MLB02, etc) contains blob of data representing the 2 teams and their scores. Database 2 is a aggregator of data from various other DBs including the sports DB. For reasons too long to go into, I need to use a script that gets the score data from the sport DB and uses SetField to enter the data into the final fields which will be used by a variable data program to populate a document in a page layout program. bottom line, each game's data is currently in separate fields and now I need to get that data into the aggregator. Let me know if you need any more info. Thanks

I have a sequence of scripts that needs to repeat itself about 400 times. Each of the 400 versions should look at a different related field. A sample of the field name would be MLB01, MLB02, MLB03, NFL01, NFL02, NFL03, etc. In each case, the field name is called on multiple times within the script steps. I would like to build a variable to handle this so that I only need to set the MLB/NFL portion separate of the 01/02/03 portion. [color:blue]SetVar ($sport="MLB") SetVar ($num=1) SetVar ($fn="Sport::" & $sport & "0" & $group) [color:blue]$sport will stay the same for 20 iterations while [color:blue]$num will change every iteration. The [color:blue]$num change can be handled with a counter that resets [color:blue]$num at the end of each iteration. So, my problem is how to use a calculation to create a field name that acts like a field name. If I do as listed above, [color:blue]$fn will result in text that reads [color:purple]"Sport::MLB01" and not an identifier that calls the contents of the field. I have read several posts (here and elsewhere) that talk about this but have found no success with any of them. Can anyone help? Many thanks Roger

oh, right you are. It's been a long day. thanks.

BruceR, your loop and Tominator's repetition & decimal trick will work wonderfully together. Many thanks.Have been rebuilding another part of my logic utilizing the repetitions to make it easier for the rest of the build. This thought process does not come easily some days so moving slowly and testing often. Thanks for all your help.

THANKS

OK, getting my head around that. After playing with it a short bit I have one question to make sure I am getting this right. When I set the first repetition of $M (previously $M001), then I would set the Repetition value to 1. When I set the second repetition of $M (previously $M002), then I would set the Repetition value to 2. However, when I set the first script to 1, the listing of the script step omits the [1] from the variable name. Does this mean that $M is also the same as $M[1]?

Tominator, that's sneaky — I like it! And yes, my numbers are integers. I have never used repetitions, nor do I understand them, so I will do a bit of reading. If there are any quick tips you have on how they work or good samples to look at I'd appreciate the extra help. That said, even if I do not use repetitions, i can see how I can solve this issue using your initial decimal trick. again, thanks

I'll give it a try when I get back to the office and see how it works. Thanks for the advice.

good question. My first choice is to see the two variables battle to the death in a centrally located container field, but, I'm thinking that might be a bit much even for FM. My variables are currently named $M001 thru $M027. Based on the away things are setup, the higher numbered variables should be the priority over the lower numbered variables. thanks

Thanks DJ, haven't tried that function before.

is there a way to truly convert the contents of a field to title case instead of changing its style (which doesn't really change the contents)? I need to apply this to a headline field that is always in All caps from the source. The problem with changing anything to Title case using styles is that there may be a word that needs to be in all caps (EPA, USA, FBI) so someone has to manually fix them. But if you apply a style, there is no way to change just one word. Also, FM's Title Case function is a bit dumb, it sees a quotation mark as the first letter of a word and will then change what it thinks is the second letter, the first letter of the word, to lowercase. Thanks Roger

My customer aggregates a lot of text material (news articles) and in massaging all his data goes back and forth between MS Word and Excel with Excel being the last stop before importation into FM. This changes any curly quotes to normal quotes. I need to convert them back to curly quotes AFTER the data has been imported into FM. Does anyone know how to do this? I even tried a script that would copy the field data and then paste it back into the field but that did not work. Thanks

Hi all I have a script that is setting 27 numeric variables. I then need to find the highest value - which I can do with the Max calculation. But I also need get the text name of the variable that contained the highest value. The only way I currently know to do this would be to build a Case statement that has 27 lines with each doing something like this: $V1 > $V2 and $V1 > $V3 and $V1 > $V4 ; "$V1" ; $V2 > $V1 and $V2 > $V3 and $V2 > $V4 ; "$V2" ; $V3 > $V1 and $V3 > $V2 and $V3 > $V4 ; "$V3" ; This would be a massive 27x27 grid. I know there must be an easier function for this (like Max) that would return the field name instead of the value, but for the life of me I can't find it. Any and all help gladly and humbly accepted. Roger