Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About WF7A

  • Rank

Profile Information

  • Title
    Database Administrator
  • Industry
  • Gender
  • Location
    Lewiston, ID

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Wow, all good stuff! Thanks! ...and I'll check out your suggestion about the value in the related record in the morning--unlike you tonight, my brain's dead. : |
  2. Greets, all: I'm > this < close but just can't seem to nail it. I'm using a value list that concatenates from another table the values of city, state, and country--that's being used as a key--so it looks like this: Lewiston|ID|US Coeur d'Alene|ID|US Boise|ID|US As part of another calculation, I want it to extract whatever the two-letter state code is ("ID", in these examples) irrespective of the length of the city name. I got this far: Middle ( JOB::Company_City__lxt ; Position ( JOB::Company_City__lxt; "|" ; 1 ; 1 ) ; 3 ) ...but I can't figure out a way to dump the pipe ("|") character so I don't end up with "|ID". Also, since the calculation will always result in the format, "|two-letter state|two-letter country", would using the Right text function be more elegant/effective to grab the state code? Cheers, Rich
  3. Perfect! Thank you!! (...and thanks to Ocean West, too--that's a good technique to use, too.)
  4. A picture's worth a dozen posts, so I attached a couple of screen shots. In the first screen shot, the two, highlighted fields--in what is to be the first record--in the portal are highlighted because they're empty. After entering a record, the one-record requirement has been met so I don't need the subsequent rows in the portal highlighted, so that's what I want to accomplish--de-highlighting those empty/subsequent portal rows.
  5. *snip* "Wouldn't it make more sense to highlight the required fields in the first empty portal row, where the next entry will take place?" Yes and no. The portal is required to have at least one record in it, hence the yellow field fill to alert the user that "Hey, you need to put enter at least one record here." What I figure would happen if a subsequent portal row had highlighted (empty) fields is that the user would think, "What should I do? It's showing that it's required but I don't have any more records to enter." I suppose I could set change the default in the portal setup where "Allow creation of records..." is disabled so users wouldn't see an empty portal record. I'll have to think about that.
  6. Greets, all: I want to use a Conditional Formatting calc to apply to a set of (required) fields in a portal so that empty ones are highlighted in the first row of a portal, only. (The logic is that the portal must contain at least one record, so only first row needs to be used as a flag to users.) I tried using Get ( ActivePortalRowNumber ) in the calc but the problem is that unless a portal row is active it doesn't have row number. Any ideas? TIA for your help!
  7. Beauty! Thanks!! I didn't know that the List() function follows the sort order. Good to know! At first I created a value list of the calculated (Ingredient_Qty_Unit__lct) field and using ValueList Items(), but that picked up all the values and listed them for every recipe. Oops. So, either my thinking was wrong or I messed on the relationship.
  8. Greets, all: Is there a way to alphabetize values when using the List function? If you open the attached quick-'n'-dirty solution I'm building for my wife (Click a recipe [Multigrain...] then click VIEW button at top), you'll see the list of ingredients but I'd like them alphabetized. Note that the VIEW page will end up becoming printable, so no portals because they won't be able to self-expand to accommodate a long ingredients list. I'm sure the answer's simple...which is a good thing since I'm simple-minded, anyway. TIA for your help! Grace Recipes.fmp12
  9. I thought I was going down the right path but I confounded myself with the Filtered portal's filter calculation. What I want the Filtered portal to show is all the unique values used so far in the ValueToDisplay field stored in the ChildTable, and for those values to appear in the Filtered portal for all the parent records. Did I mess up the tables' schema, the filter, both...? I suspect a global field has to be used somewhere, but I'm not sure where. *sigh* Thanks in advance for your help! test.fmp12
  10. Greets, all: I'm trying to wrap my head around how to enable users to perform Finds when the values are stored in a child table. The attached is a portal with two fields, KeywordMarker and KeywordText; the former is used as Boolean field to store 1s and 0s, and the latter is to capture Keyword text. The idea is to have users tick the KeywordMarker field that incorporates a button that fires a script to toggle the contents of that field (to 1 or 0, represented by an X or null). The button would be placed (inside/outside?) the portal where another (radio button) field would have two options for the users to choose, Exact (for exact find of the parent records that contain only the ticked values and none else), or Wide which would pull up all parent records that have the ticked keywords an any other keywords that happen to be recorded for the parent record. A Find would then look for the 1s in KeywordMarker to create the found set. (Using Contrain afterward, if an Exact find is chosen.) Originally, I had a single, checkbox'd, Keyword field in the parent record that users would tick to select the different values but the they were limited by number (since a checkbox'd field can't expand to accommodate additional values), and I read somehwere that performing "exact" and "wide" finds would be problematic using a single field containing many values, hence the reason why I went the child, one-to-many table route. So, am I on the right track and if so, how do I pull it off? Cheers, Rich
  11. I'm racking my brain with this one. I put together a summarizing report (sub-summarized by date range then test code (i.e., 5002, 5003, 5004, 5005) but where I'm getting hung up is in the last two columns, % Above Passing (score) and % Below Passing (score). As you can see, the numbers repeat themselves for each date range sub-summary...and for some strange reason, the 5003 averages are identical to the 5002 averages, but they shouldn't be. To calculate the % Above Passing (score) and % Below Passing (score) numbers, respectively, are these calculated number fields: PercentAbovePassAvg: ( ( AvgPass_ScoreAbovePassing__lxs - TEST_CODE::MinPassingScore__lxn ) / TEST_CODE::MinPassingScore__lxn ) * 100 ...and... PercentBelowPassAvg: ( ( TEST_CODE::MinPassingScore__lxn - AvgFail_ScoreBelowPassing__lxs ) / TEST_CODE::MinPassingScore__lxn ) * 100 I suspect that I need a Summary field but the only radio button choice I can think of to use is Average each of those calculated number fields but that doesn't work (at least the way I have it coded). So, my questions are: How/Do I set up a Summary field, if needed, to determine each test code's averages for above and below the Minimum Passing Score, and how do I prevent the numbers from repeating themselves in each data range'd subsummary? Cheers, Rich Printout1.pdf
  12. I like it! I suspect the Assessment team--who'll be using this--won't want to read every Indicator at length so considering my audience that's an elegant solution.
  13. Not yet, but they'll be stored externally--I'm still putting the solution together so there's no captured data to worry about.
  14. (This might be more for the Script forum but since this will be taking place in Web Direct--where some script steps won't work with script triggers (e.g., OnObjectKeystroke)--I thought this would be the best place for my query; if not, moderator please move this thread to a more appropriate forum.) Here's the problem (please see attachments): I have a layout with a list that includes the field, Indicator, that varies widely in length; I have the Inspector > Sliding & Visibility set for Slide up based on: Also resize the enclosing part. In Preview Mode it looks much better than in Browse mode, BUT, I want to assign two, separate scripts where if the user clicks the Course number it takes them to its related table and if s/he clicks on a proposed button it'll show them that course's artifacts. (I'm trying to get SuperContainer to work but am having setup problems with it at the moment.) There are two ways to go in my thinking: In Preview Mode, how would you get a script to work (in Web Direct) to accomplish the above, OR, is there some way to to shrink-to-fit the Indicator field in Browse mode? TIA for your help! Rich
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.