sboard0599

This works within eaqch record but I need to find these values for a collection of records. Each operation is it's own record. I also have the start and finish times in the header which migh be causing another problem.

I have a scheduling db that allows users to enter start and stop time for the jobs they are working on. The fields for time are a portal to a timesheet db that i use to produce daily time sheets for the employees. i have a script set up where the user enters his name and the date. the script then finds and sorts(based on time) all of the records for that user and for the date I need the time sheet for. In the header of the timesheet db, I need beginning and ending fields to show what time the employee started and ended his day. This is always the first start time and the last end time of the day. I need to have those time appear in the header. I was am trying to create a field that picks up the first start time and another that picks up the last end time but am not having much luck. Any help would be great.

I have a time field that automatically enters the time a job is started. I need to convert that time to 100unit hours. An example would be 2:30 pm would = 14:50, 9:45 am would = 9:75. I thought this would be easy but I am having trouble. Any ideas?

I am trying to buld a DB that calculates my inventory. I have 6 inventory items. I have a Codes.fp5 file that I have all of the items and the item codes and beginning inventory numbers in. I have my transaction file set up to record indivdual uses of inventory items. I have a beginning and ending inventory field and an inventory_used field in a sub-summary part of the layout set to sort by inventory item. What I would like to achieve is a sub total of each item used(which I am getting) and then have that subtotal subtracted from the inventory item. I am getting the total of all items subtracted from each item. I need to subtract the total of item A from the begnning balalnce of item A. Now I have the totak of A, b & C subtracted from A and so on. Any ideas?

I have a DB in which I have a portal showing records in another DB. It basically tracks operations and the times they were performed. The portal shows all of the operations from a certain job. I am building a schedule that will show the last operation from that job. How do I find the last portal record based on time and date of operation. Right now it always finds the first operation.

I have a field sitting in a header area that I cannot modify. It is a numeric filed that i want to be able to enter an inventory number in but cannot get the field activated. This is being done in a DB that was already existing that I hve edited. Has anyone else had this problem?

Thanks, but I just cant seem to get these portals to do anything for me. II am really just guessing on how they really work. Could you give me more detilaed info? I am looking to combine many records into one, listing a user and all the software on his machine. I now have 2o records all listing the same user, each record showing a different program.

I have a DB that has individual records for each user and application on his or her workstation. For example, record 1 is user 1; application A; record 2 is user 1; application b; record3 is user 1 application c. I want to create a new DB that will gather all the info and let me see, in one record, all the software on user 1's machine, reading something like user 1; application a; application b; application c. Any ideas out there?

I have 7 people associated with a group. Each has their own password. I want to be able to search based on who logged in, not based on the group. Is this possible?

I have written a script that will find a certain set of records in another db based on a certain job number. Is there a way to find a set of records based on which password is used. Basically, how do I tell FM to use the password used to login to the file in a script?

I got it to work by telling the applescript to do scripts in each of the db's. Phish_URL_Repo_new.zip Phish_URL_Repo_new.zip Phish_URL_Repo_new.zip

I am trying to write a script that will get a job number in one db and find info about that job in another db. Basically, I find the job in question, copy the job number in the number field, activate the other db, go into find mode, paste the copied job number from the original db into the job field in this db and then perform the find. The script works when I run it as a standalone Applescript, but when I embed the script into a script I made in FileMaker in the orignal db it stops working as soon as my other file is activated. Any help out there?

I have a database that contains a bunch of unorganized info. I want to create a new file to get it better organized. I would like to know how to easily transfer the info back and forth. I would like to be able to enter an employee name into the new file and have it pick up all of the info in the record from the original DB. I should note that there are no value lists in the original. I noticed that when I create a value list based on fields from other files it gives me a nice alphabetized list. I wonder if there is a way to get that info out into a list of its own

I have a database that contains a bunch of unorganized info. I want to create a new file to get it better organized. I would like to know how to easily transfer the info back and forth. I would like to be able to enter an employee name into the new file and have it pick up all of the info in the record from the original DB. I should note that there are no value lists in the original. I noticed that when I create a value list based on fields from other files it gives me a nice alphabetized list. I wonder if there is a way to get that info out into a list of its own

I have created a page that will reside on our www site. This page will be used to input customer info. i will then want it to be downloaded to my fmpro file that resides on my network here. Can someone give me some help doing this or can you point me in a direction that will help me out. Thank you very much. ------------------

Does anyone know if there is a way to get FileMaker to interface with Quickmail. I have read that it only works with Claris email programs. I was hoping there might be a third party plugin.

I have just installed Server 5 on an NT machine. This is an upgrade from 3.0 on the MAC. The interface is much different than the repvious version, particularly the way you activate files. I put the files I want to share into the main folder and it worked, but there must be an easir way to administer this program.

I am trying to create a button, that when activated, will pop up a window on the screen with info from another database. I want the info to be hidden when not wanted. My problem is figuring out if it can be done. ------------------

I am trying to write a simple script or calculation that will match an CSR's name with her email address. i want to choose her name from a list and then have her email appear in another field. I have entered all of their names in one value list and entered all of their email addresses in another. I am trying to write a calculation (if csr name =xxx, then email address=xxx@chamlaf.com). I cannot get this to work. Any ideas for me?