jim shelton

Using FM13ADV on Windows. I have quite a number of new accounts to setup in Security. I wrote a script, like I have done before. The password needs to be two lowercase letters followed by a series of number like ag45689. This calculation is producing uppercase letters no matter how I try. No text formatting, add lowercase formatting, remove text formatting. I would rather not enter each one by one. Thanks, Jim

We are all Windows users with XP, Windows7 and Windows8.  I am attempting to complete a script that creates a nest of 1 folder with 3 subfolders on another server. The script will create the folders on my desktop but not on the other drive.  Path to location is: http://fdsmsvws01/DIAPP  Top Level Folder for example would be: Test One Request  Sub Folders would be: Analyst Design Program  I have tried changing http: to filewin:, but result was unsuccessful.  Currently the users have to remote access to the location.  Script steps attached.   Help would be appreciated. Jim

I have this calculation that begins with Product Name then list attributes about the product under the name. I have indent set at -145 for first line and 145 Left. Works well except when product name is longer than one line. The attached file shows the calculation, my soft returns are not working after the first time. thanks

If this is in the documentation, I am missing it. So tell me where. With RemoteScripter, the PDF is inserted into the Container field and it is taking the IWP User several refreshes at their web browser to view the inserted file. The container field is setting on the same record as the IWP User. Assistance is appreciated. Thanks, Jim

We are using FM12 Adv. Need to place a created PDF in a container field for IWP users. We are using 360WorksRemote Scripter and it works fine with their test file, but not our live file. We set a variable, $file, before we begin to create and append the PDF. This is always inserted on Windows Server. We have tried $file=Get(DesktopPath) & Business::BusinessName & ".PDF ------ Works okay to Set Field for container, but IWP users cannot see it. plus file name has C:UsersAdministratorsDesktop before the actual PDF name. What should be the actual Insert File script step and the Variable for $file? thanks, Jim

I am not seeing how that would work as there are currently 12 layouts with some layouts max on length. I am not even sure if making a report would work either. thanks, Jim

There are 88 subheadings. I started a script that goes to last page, and looks for the last subhead. The thought was to walk upwards from there. But unfortunately I am stuck as verifying the page number. If there was only a way to test if not on current page returns a 0. The wording of each subheading is known and cannot be altered by the user. Jim

Hello, We have a long document as a single record. I am trying to build a table of contents when we save as PDF. I need to determine the page number of the subheadings, which are fields. I have a script that pulls the subhead and its correct page number, but only if I can get it to the correct page by go to last then go to previous. The problem is I do not know what page the field will be on. Under the subheads are numerous sliding up fields. thanks, Jim

I have lost the code I had for putting AccountName and Password into the url for IWP log in. Also I would like to bypass the screen that lists the available databases. Filemaker 12 thanks, Jim

That was it! Thanks. Guess I was standing too close to the trees.

There are over 400 Groups, so I have the three globals which are populated from a list with values separated by a <cr> My script does not seem to be gathering the data from the group global on the Extend. I have tried it two ways. Method A Perform find handles the first Group and the other criteria. This step works Enter Find Mode Set Field [staffing::gMatchTwo; GetValue($OrgList;2) Extend found set Method B Perform find handles the first Group and the other criteria. This step works Set Field [staffing::gMatchTwo; GetValue($OrgList;2) Extend found set

Using Filemaker 11 on Windows, writing a script to run a report. Script is working if I only search for a single group or all groups along with either one, two or all three of the types. How can I extend the find to allow the User to search for either 2 or three Groups? There will be the same Types selected for each group. I have captured the list of Groups as a varialbe with each value separated by a <cr>. thanks, Jim

We have the license for 360 Works. Email is handled by Exchange. There are specific emails that will need to be saved within our FM solution. We are running FM12. With Thundermird I can drag n drop an email into a container field then export field contents and see the entire email. With Outlook I only receive the email header. Does someone know how to tackle this problem? thanks, Jim

I hope this is in the correct area. We have a portal to where each record the User can select Contact Type(phone, fax, email, cell phone, etc) then they can enter the correct info in the field Contact Data. I need to know if Email is in their Contact Type and if so what value is it so I can locate it in the list of Contact Data. thanks, Jim

fields are named s001, s002, etc. Perhaps that is why I am getting specified field name cannot be found with GetRepetition ( GetField ( Market::s008 ) ; 5 )

Sure, we are trying to verify is a booth is booked. The user already selects a booth from a value list of customer values which is nothing but a list of all booths (276) of them. When a booth is booked a transaction number is placed in the 5th repetition of a field with the booth's name (example:001) I would like for script to alert the User than the booth is booked. To do this is would have to find the booth field and see if 5th rep is empty or not. The booths are not records only fields. So each event (over 90) has 276 booth fields on it. Confusing to me. Hope this helps. Jim

In a script I have a variable that holds a calc that build a table::field. The field comes from User input. I need to try to show a list of the field contents as the fields are all repeating with 10 repetions. I will be using a loop to locate the field from the 280 repeating fields on the record. Help. Not my creation. thanks, Jim

In a script I have Set Variable for a list of scores. Example: 8 14 18 16 21 20 24 27 I am writing a loop to count the times a value occurs in the list. Then go to the next value. I tried PatternCount, but it counted 20 when I was looking for count of Value=0. $CurScore is the individual Value. PatternCount ( $List ;$CurScore & "¶") thanks, Jim

We have people in the field who need to get job instructions, enter data that will eventually become part of the main FM solution. The field users do not usually have Internet access. Running FM Server Advanced 11 for hosting files and FM 11 Pro on internal workstations. We thought of iPod Touches because of price and then add FMGo, put a simplified copy of db on each iPod. Then daily or weekly import new jobs information and export the completed job information. But I read on Filemaker.com that FMGo cannot export. Can FMGo on an iPod export records? If not, what would be a better plan to accomplish our task. thanks, Jim

This maybe the wrong forum section. How does FM IWP allow access when Port 80 is not open on the firewall? We are trying to trace why a plugin is not working. Is the correct port open. thanks, Jim

We have PDF files located in Filemaker_Server_11\Data\Documents\WorkOrders. I need for outside and remote Users to view, open, print these files. If I physically upload the file to a SuperContainer Web Viewer all of that can be accomplished. Is there a way I can move, import, insert etc this file into the superContainer Web Viewer via a script? thanks, Jim

I decide to just use SuperContainer to resolve the issue. thanks, Jim

The client is all PC based. Their FM File is hosted at FMGateway. We need a web viewer so PDFs can be viewed. Client has PDF files on a local server. FMGateway stated: "The PDF files need to be uploaded through FTP to the users account. You can then access it through a special subdomain (not 31.fmgateway.com, that's just the FileMaker Server). Once the files are uploaded through FTP into the "httpdocs" directory, it should be very easy to calculate a URL to them." Then they stated: "They can upload their pdf files to the httpdocs directory of their FTP account. They can then use their domain or subdomain with any subdirectory and file name to view the file." I made a network connection to the FTP and placed a file there. When I attempt to view through the web viewer I see parts of my own desktop. I could use some real help with this one. thanks, Jim

We have a solution in FM 11 hosted by FM Server (switching to FM Server Advanced soon). Outside contactors need access to DB to view, edit data and view documents and upload new documents. Some have iphone, some have blackberry, some with other smart phones and many carry laptops. How should we approach this endeavor? Should we create second set of layouts setup for phone usage? thanks, Jim

Okay, this is my first project using SuperContainer and it is inconjunction with FM11. I need to create a folder by Projects::Proj_Num. Then rename each image with Projects::Proj_Num & Document::DocumentName. The documentation is not clear to me for this. Help will be appreciated. Jim