poeben

Thanks for the quick replies. The data consists of the following: Employee name and 3 sets of start/end times (and a few calculations not relevant to the script: total hours worked, pay rate, cost, billing cost) For any given day there can be up to 30 employees working, each with different start and end times. The idea is when a group of employees have the same times (which happens frequently) you would only have to input the info for one employee. Thanks again for the help.

I know there are probably numerous ways this could have been designed better, but this is what I have to work with. I have attached a sample of one of the simpler scripts. Basically the script will fill in an employee's hours for a specific day. Employee's working the same hours will be filled in based on the previous employee's times. This way the times of 30 employees can be entered only once per unique time (hours vary greatly on a daily basis.) It doesn't seem all that complex: If field A is empty [clear fields A1-A6] if field B is not empty AND field B1 is empty [copy value of fields A1 thru A6 into B1 thru B6] if both fields are empty [do nothing] This same action occurs for up to 30 employee fields. Hopefully this makes some sense...

I have gotten myself into a rather tedious scripting scenario. I have a rather large script (about 300 steps, many of which are repetitive.) Is there a way to speed things up at all when duplicating large numbers of steps. I would take any of the following suggestions: 1. Export the script to plain text and re-import when finished. 2. Copy blocks of the script and move them as a block (I can only seem to move one step at a time, not a block) 3. Any way to actually enter code directly, not via point and click. I am running FileMaker Pro 8.5. I have a feeling I may need FileMaker Advanced to do some of these things...please tell me I'm wrong. Thanks in advance

I'll try to give a quick example of my goal. First the relevant info: field01, field02, ..., field50 - each has a drop-down menu where you can choose null(default), qty5, qty10, or qty15. What I am trying to do is, for example, if I select 'qty10' in 'field25' it would fill in the value 'qty10' in field25-field34. Now my thinking was along the lines of a PHP type program, using variables to address the fields and some sort of i++ loop. But I am finding out Filemaker doesn't really work that way, or at least doesn't seem to make it easy. My attempt thus far has been: Set Variable [$i; Value:Right (Get (ActiveFieldName) :2)] //gets numerical value of 'field' if [Get (ActiveFieldContents ) = "qty10" then I would do something like this (some type of PHP-esque while statment) While $i; Set Field [tableName::field . $i; qty10] $i++; //and this would loop as necessary But, I have not found a way to refer to incrementing (or individual) field names using concatenation or any other techniques. I did see a reference to using a Global variable and a calc field, but I didn't understand what they were saying. Any ideas? Hope this made some sense with my disregard to syntax. Thanks for reading, poeben

Hi, Hopefully this will make sense and be easy to answer. I am creating a schedule in FM for our employees. Due to the nature of our business, there can be any number of employees on for a given shift (from 1-20 people), as well as multiple shifts per day. I would like to set everything up like a spreadsheet, each person in it's own field. I would like to have, by default, 4 spaces for personnel with the ability to add more as necessary for that particular day. I was thinking along the lines of a button to add another row and a button to move to the next day. Another option is to automatically have one blank field following the full ones, and when that is filled one is added below it. Can anyone help, or point me in the right direction? Thanks in advance.