stephaniellawless
Members
Content Count
24 
Joined

Last visited
Community Reputation
0 NeutralAbout stephaniellawless

Rank
member
Recent Profile Visitors

How do you find data from specific field contents?
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
Yes we are actually are on our way with the other script. Thanks for your help on that one. This is actually a different question. Thanks. I will keep working on it. 
How do you find data from specific field contents?
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
Yes it seems like I need a script. I don't need the running subtotals (of pools) to be shown on the layout. I need it for a more specific calculation, and yes, for a report. Ideas? Thanks! 
How do you find data from specific field contents?
stephaniellawless posted a topic in Finding & Searching
TWO questions from a newbie to Filemaker Pro. Question 1: How do I write a formula that performs a calculation on only one type of field content? For instance, in a field that I call, "unit_type," I have many text values (pool, riffle, glide, rapid, cascade). I only want to make calculations from the "pool" data. I already know how to use the "find" button to find all of the records with "pools" in that field, but I want to write it into a formula (preferred) or a script so I can create a more complex calculation for a summary page. Question 2: This is a question about using the Summary function when setting up fields. How do I set it up so that I can find running totals of data of a field in a set of records while simultaneously finding running totals of only a specific value in that same field in the same set of records? For example, I want to find the total unit area of all of the stream units I monitored while at the same time finding the total unit area of only the pools. I have a field called "unit_area" and a field called "unit_type." I created a field called "Total_Survey_Area," which is a running total of all of the unit areas, but how do I create another summary field that only grabs that same info from pools (without having to to "find" all the "Unit_type" fields that say "pool")? Thanks for the help! 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
ok after thinking about this, talking with a colleague, and hearing replies, this is what I want to figure out: Â I want to figure out how to find cumulative lengths between the values that say "pool" in a field called "unittype." The unit lengths of the pools themselves are irrelevant. My colleague created a function that combined all the other values in that field (riffle, rapid, etc.) so that when they show up, they would be listed just as one value, called "fast water." Â Now that he's created that, we want to find the cumulative lengths of "fast water" units. The lengths are found in a field called, "unit _length." Is there a calculation that could be written to find this instead of a script? If so, it would be very easy to finish the rest of the calculation.Â Â To answer some questions: Â What is the scope of the series of pools, riffles and glides? One Site ID or more than one? They are all values in one field called "unit_type" Â How do you calculate the average width? Â just the Â pools, or all the pools, riffles, and glides? Where is this calculation stored? The average width is a summary field that is calculated and displayed as a running average as more records are added.Â Â Is your database one flat table, or does it consist of related tables It consists of some related tables, but for this purpose, the table I'm working with will only need to be related to a future summary table.Â Â Does each pooltopool calculation need to be used, displayed, or reported elsewhere, or are they just a means to calculate theÂ Average_Active_Channel_Width? The pooltopool calculation does not need to be displayed or used elsewhere. They only are a means to calculate the ending result, pool frequency, which is the calculations/Average_active_channnel_width.Â Â I am a novice at all of this. Thanks for trying to help me clarify more. I'll post in table format the lists of records in the unit_type and unit_lengths fields again.Â Â Â 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
ah, thanks you both are getting this. Â The Average_Active_Channel_Width field is a summary field that has the same numerical answer for a set of records sorted by site name and data. So.... let's say the average Active Channel width for a certain set of records is 10. Then if I used the sample set below, my answer would be: 5.525Â Â The way I got to this was I added up the lengths between the pools (step 1), and got 28 and 82.5. I then divided each length by 10 (step 2). Finally, I averaged both the answers, which got me to 5.525.Â Â This is the script that I'd like to get to.Â Â doughemi what fields do I set up for the following:Â Set Field [ pools::pool.distance; $tot.dist ] Â Â Thanks! Oh and when I do add a "pool frequency" field to the layout, I do want it to be a running summary, so it changes as I bring up different sorted records. Just for the sake of understanding what I'm collecting data on, here is a snapshot of my data entry form for each record.Â 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
Thanks for this. The field that the names are in (pool, riffle, etc.) is called "unit_type." Is that what I should paste into here: If [ pools::type = "pool" ] The name of the table/layout is "habitat_entry_form." I'm also not sure what pool.distance is. (Set Field [ pools::pool.distance; $tot.dist ]) Thanks again for helping me work on this! I also rewrote my request below since i originally messed a number up: "...The answer for the 2nd pool unit would be 28. The answer for the third pool unit would be the sum of 17.5+33+23+9 (82.5). The next calculation I need to make is to divide each of these lengths by a SUMMARY field called Average_Active_Channel_Width. So, the second calculations would be 28/Average_Active_Channel_Width, 82.5/Average_Active_Channel_Width, etc. The end result will be the average of the answers above... Hope this helps... Also, the field column with the names (pool, riffle, etc.) is called "unit_type" and the field column with the numbers is called "unit_length." The layout is called "habitat_entry_form." 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
and.....I read my own table wrong. The length for the first pool is 0 because it is the start of the survey. The length for the second pool is 28, not 9.5. Apologies for the discrepancy. 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
To be more specific Â Here is the calculation:Â I need to add together the lengths of each unit between the "pool" units. The answer I need for each "pool" unit is this total length. For the screen shot below, I wouldn't have an answer for the first pool because it is the beginning of the survey. The answer for the 2nd pool unit would be 9.5. The answer for the third pool unit would be the sum of 17.5+33+23+9. The next calculation I need to make is to divide each of these lengths (the 9.5 and the second total) by another field called Average_Active_Channel_Width. The end result, which is pool frequency, will be the average of the pool distance lengths/Averaage Active Channel Width.Â How do I set up a script (?) to find these lengths automatically, and then use them in another calculation (the one I described above)? Thanks again!! 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
I meant that my original post was clear as mud. Yes thank you for your suggestion. However, I need to count running totals of lengths between each pool. I need to use those lengths to calculate the pool frequency by dividing the lengths by another field called "Active Channel Width". How do I write a script where I can do this? As you can see in my screenshot, there are other values in the "unit type" field that would need to added together. Those totals would equal the value I need for my pool frequency values. Thank you again for the help. I'm a novice with fm pro 13 
How to find specific characters/values in fields to perform calculations
stephaniellawless replied to stephaniellawless's topic in Finding & Searching
Yes, clear as mud indeed as I reread..... I would like to find out the frequency of pools (in the "unit type" field). In order to do this, one of the calculations I need to make is to find the lengths (in "unit length") between each pool. I have multiple records with different unit types, and I figured out how to write a script to just find the pools in the "Unit type" field, but cannot figure out how to find the lengths between the pools... Â Thanks again for the help! I posted a pic below 
How to find specific characters/values in fields to perform calculations
stephaniellawless posted a topic in Finding & Searching
Hi all, I'm hoping you can help here. I am trying to make a calculation on a layout. I need to calculate measurements of a specific drop down value that I write in a specific field. The value is called "pool." There are other values called "rapids" and "riffles" etc., but I need to write a calculation that finds running totals of the lengths between the "pools." Is it easier to run a script? If so, how to do I do this? FYI I have another field that gives unit lengths. Again, I want to calculate the unit lengths between the value "pool". I hope this is clear enough. Ideas? Thanks! 
Is there a tallymark function on Filemaker Pro 13?
stephaniellawless replied to stephaniellawless's topic in Script Workspace and Script Triggers
LaRetta I can't open your file with FP13. I'd love to see it. 
Is there a tallymark function on Filemaker Pro 13?
stephaniellawless replied to stephaniellawless's topic in Script Workspace and Script Triggers
Thanks for all of the suggestions. Mike's idea is closest to what I had in mind, but the number system (+ key) sounds like it could work very well. My colleague and I are going to work on our database and see how your suggestions work. 
calculating totals from specific records
stephaniellawless replied to stephaniellawless's topic in Calculation Engine (Define Fields)
Thanks for doing that. I apologize for posting twice. A hiccup. I'm trying to create calculations based on data collected along different reaches of streams. The calculations are sort of complex. For instance, I need to calculate the percent of combined substrates for the entire area of each stream. Since the streams are separated into units, I need to calculate the area for each unit and then find the cumulative totals. My problem is that the cumulative totals are required in my calculation, but the calculations don't work. Do I need to use the Get Summary function? I don't know how to use it. I'm sure this is clear as mud. Thanks for your help! 
calculating totals from specific records
stephaniellawless posted a topic in Calculation Engine (Define Fields)
Hi, I cannot figure out how to calcuate a total_length field that can be stored so I can use it in another calculations. I need to find a percentage of something within a length of transect I walked. The transect is broken into multiple units. Each unit has its own number and date. There are multiple records in my database with different units/dates, but I need to calculate a stored data field for the entire unit length of my individual transects so I can determine the total percentage of substrates, etc, along only that transect not others. The first thing I tried to do was when I created the cumulative length field, I clicked "summary" and then "fraction of the total of." The issue is that I am only allowed to click one subtotal field to link those records to my particular result. I really need to click two fields (date AND unit name) to make the database pull the correct records to be totaled. How do I do this??? Thanks so much.