Jump to content

MorFologist

Members
  • Content Count

    89
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MorFologist

  • Rank
    member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

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

  1. Thanks Barbara! Sorry you had to suffer being the guinea pig to bring us this very helpful tip!
  2. I found it just lops off the last word of the tool tip; so I add a bogus word at the end!
  3. Refined so it doesn't mind a partial filled portal, and my hard coding for the portals. Let( [ CountTotal = Count(parent::children); StartN = 1; EndN= 25; RunTot = children::Quantity_srun]; GetNthRecord ( RunTot ; If (CountTotal < EndN; CountTotal; EndN) ) - Case ( StartN > 2 ; GetNthRecord ( RunTot; StartN - 1 ) ) ) Thanks again!
  4. RUNNING total! Beautiful, many thanks! Yes, a child report would be a no brainer (except for pesky alignment issues), but this will make the user very happy.
  5. I have a print form set up to print multiple pages. It uses several tabs, showing the related records in a portal with a finite number of rows on each (1-25, then 25-50, etc.), and the print script switches tabs as needed for the count of related items. I now need to place a quantity total below on each tab, summarizing just the quantity field from related records of the portal range shown on that one tab. So I need to a field to calc sum(quantity) from related records 1-25, and another for 25-50. Trying to find something more graceful than a written out Get Nth, given I am recursive-challenged. No sort on the portal, this is just based on count 'range' of related records as entered order. This is real just about summarizing the records by range, and the portal itself is irrelevant. Of note, it's a preprinted triplicate form on a roll fed strike printer, and requires precise graphic alignment, so would prefer to maintain the tabbed pagination rather than redo and face alignment issues to utilize summary breaks just for this one new addition.
  6. Did you see this? http://www.filemakermagazine.com/videos/the-separation-model-part-12-barcode-scanning.html let me know if the technique (to return to the text field) turn out to be applicable to FMGo.
  7. I'm not sure how to approach this. I see I can use patterncount to count on a single string, but not any (is valid?). Within a given text string, I want to substitute "A" for every Nth occurrence of any whole word matching an item in list "B". Example: He walked to the store, checked his pocket and realizing he forgot his wallet, he groaned. result Bob walked to the store, checked his pocket and realizing he forgot his wallet, Bob groaned. List in B, count any of: He he his His A= Bob
  8. Did you resolve? This has come to plague the one XP user in our group. It cleared after a restart, so I suspect memory issues. The PC is slow and glitchy otherwise, so I suggested IT should tune it up. I'm not using the new Window command, but opening a second file.
  9. Trying to install the demo on a weekend is such fun. I had the same error, and finally fixed when a stop/start of the server revealed that I had moved the folder the jar file was unzipped to. Now I have a coffee cup with an !. Progress!
  10. I had the urge to add commas (up to a 7 digit number), but I'd love to see a trimmer way to do that. Let ( [_TheAmount = YourTable::YourNumHere ; _WholeNumber = Int ( Round ( _TheAmount , 2 ) ) ]; case( length( _WholeNumber)=3;_WholeNumber; length( _WholeNumber)=4; Left ( _WholeNumber ; 1 ) & "," & Right ( _WholeNumber ; 3 ); length( _WholeNumber)=5; Left ( _WholeNumber ; 2 ) & "," & Right ( _WholeNumber ; 3 ); length( _WholeNumber)=6; Left ( _WholeNumber ; 3 ) & "," & Right ( _WholeNumber ; 3 ); length( _WholeNumber)=7; Left ( _WholeNumber ; 1 ) & "," & Middle ( _WholeNumber ; 2 ; 3 )& ","& Right ( _WholeNumber ; 3 )) & "." & Right ( "00" & Round ( Abs ( _TheAmount ) * 100 , 0 ) , 2 ) )
  11. LOL! Your English was perfect. Where were you an hour ago? (and why did I not think to try that). Thanks! I still needed to sub out the ¶ for # to maintain my text blocks, so not truly a waste of time.
  12. The result of List(field) comes out in record creation order. Is there any trick to control that? I'm populating a single calculated text field in the main file with a list of field data from a 'many' relationship (thru a join table), and would like to allow the user to control the sort order of the result by modifying a field within the table the list is pulled from. Looking into "create a value list based on values of the field in question, make it a conditional value list based on the relationship ID... then use ValueListItems() to return only the unique values. Works best in a script." That worked. As the target field to make a list from was a calculated text block, itself with a list from yet another field, : , I had to replace all ¶ with # so I could sort the field as a single item, then subbed them back after using VLI().
  13. Hi, I found your file interesting. Did you every resolve your needs? I wondered why you used the "flag=1" relationship for a constant over just a [X] relation. I am playing with allowing my UI (target) to create the data record (source) via relationship; typing in a data field to create the record (your sample required typing an id as a lookup). I had been looking at verifying that my UI record ID lists matched the data, and found your "list missing" method useful. Thanks! For curiosity, I applied my setup to your file and it seems to have resolved your issue.
  14. Hi Steven, Do you think FM11 has improved the structure enough to not have to use ESA? -Karen
×
×
  • Create New...

Important Information

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