cdr-dev

Wim, Thanks for the insight. I was thinking ODBC might be a possibility, but what OLE DB Driver would I select from Excel? I have found a couple of ODBC drivers in searching. Which is the easiest to work with for this type of situation? Actual Technologies has a pretty slick interface for their driver but do not indicate if ODBC can pull out of Filemaker. They only mention the big dogs like MS SQL, Oracle, etc. Thanks!

I was looking around for a way to have a field in my database to be able to export to a specific field in Excel. IE: Field "Install Date", to export via script into an Excel Template(.xls) called. "TN Change Form", into cell "A7". Any ideas how to make this work? Is this a SQL related question or can a special type of calculation make this work. Thanks in advance. Chris

Question, apologize for jumping in so late. Are you trying to use a shared database from the FM "fat" client installed on the desktop through the "Open Remote" process? Can it be accessed this way? How would it be done? Chris

What I have is a layout for the user to enter a "Start Date" and a "End Date". Both fields are defined as a global. The user has a field where they can select the "procedure" they wish to report on. Once all the fields are entered, they will click a button that performs this calculation and displays the total number of procedures they have selected. I would prefer to use a string but how would I define it so that I can pull the values from the two date fields?

Hi, Has any tried to do a report where they have a form the user enters a start date and a end date from two different fields and create a report based upon the range of information? I am having a time trying to figure out the scripting. I know that if you use one field you could enter for example: 5/1/05...5/31/05 and that will give you the range of dates for the month. Now I want to use two different fields (defined as globals of course!) to get the same report where the user just enters the dates and their criteria selection. Thanks! Chris

I am not sure what would be the best way to set this up. I have a relatively simple Oncall schedule database that has 5 fields: -Name -Specialty -Beeper -Start Date -End Date I'd like to be able to create a report that would show the dates inbetween the Start Date and End Dates. So if they enter 2/28/05 for start date and 3/4/05 for a end date, it shows them scheduled for 2/28, 3/1, 3/2, etc... This may not be the right forum for this and I apologize if it isn't but since this is strictly a report type thing, I though this might be the appropriate place to post. Thanks for your help! Chris

Gotcha! Pause the script for 1 second and bam...there it is....

That makes sense. Good point! The calc would be as described to validate if "Contract" or "vacant" were selected from the drop down list, to show the second window with the 2 date fields for entry and an ok button to close the window. Your script example above works but the only issue is how to trigger it after data entry has been performed? In the validation tab for the field, it doesn't give you the option to validate by script unfortunately.

I don't think you would want to loop it.. What would the loop serve as??

I am working on a DB for employee tracking and I have a field called "Employee Status". I have a drop down of 5 items. 2 of wich are the words "Vacant" and "Contract". If I select either of those two words, a second window pops up and asks for two date values that must be entered. If I write a calculation for the "Employee Status" field and define as such. How should I modify my script to where it will bring up a second window that allows me to enter the Request Date and Expiration Date? They can be both assigned the same because they both represent the same result if either is selected. Let("Vacant" and "Contract" = 1), If "Employee Status" = 1, Then open layout "Date menu" Then the two dates would be entered, user would click OK, and close the window. Simple, but what would be the best method to write this?

The Set Field line appears to be having some problem determining the current date with future appointments that are entered. ScriptMaker sets the line up as Set Field[Appointments::Apptdate; " > = "& Get ( CurrentDate )] Is the format of the line, the problem, or do I have some other consideration to look at?

I am about wiped out trying to figure out the easiest way to do this. Here is what I am trying to accomplish. I have a layout that is for scheduling appointments and I want to view dates that are available by viewing the schedule from todays date, on forward. I want the user to find open dates even if they are scheduled up to 6 months later. They view the schedule in a columnar report that lists dates/times. How can I setup a script to where when they click a button, that it will run the script and show all dates/times that are scheduled and not leave any out and display the results in a columnar report? Many thanks! Chris

Stanley, How did you get FM mobile to run a script for your implied method for doing a find on the item scanned? I have FM Mobile 7 and can find no option for looking up data in that fashion. Chris

Well, after an entire afternoon of programming, we finally got everything to talk. Received the scanner program from Symbol, loaded the app, loaded FM Mobile 7 and all is working beautifully. This is a good one to get for scanning solutions.

After talking with Symbol about this, there is a scanner program that is missing from the applications folder. Supposedly they were going to email it to me yesterday but it didn't arrive yet. There is no configuration page that you scan with this scanner, it is all internal on the ROM. I found that odd too because most of the ones I have worked with in the past (specifically terminal attached scanners) have config pages you have to scan. This one is ready to use. Pretty cool.