Jump to content

McScripta

Members
  • Content Count

    35
  • Joined

  • Last visited

Community Reputation

0 Neutral

About McScripta

  • Rank
    member

Recent Profile Visitors

756 profile views
  1. McScripta

    Puzzled by search result format

    you are indeed right! I was not telling you of the the script trigger... bad McScripta, bad. Totally wasn't on my radar. Excellent detective work Commet. Thank you.
  2. I have a single, unrelated table I am viewing as list in Browse mode (all records showing) I enter Find mode and input search query in one of the fields (I already know there is a record with that value, in fact it only matches one single record). When I hit enter, FM goes to that record but while still displaying the entire list of records (preceding and following my target record). My "found" record is basically an item on a long list of all records. Is that normal behavior? I want to see only one item on my found list – the only one record matching the search query...
  3. ...I can hardly follow what I'm doing here myself. Thank you for your input!
  4. I've considered that but my implementation requires Sum result to be picked up downstream via portal. I'm not working with a classic report layout. SOLUTION: I moved my calculation field into the portal itself (since that was the implementation I needed in the first place), then it's just a matter of Sum() function targeting the portal field I needed to get total of. Since the portal already limits the records to the common value via relationship, that fixed my issue. Thanks.
  5. McScripta

    {{FoundCount}} value in field

    Excellent! Thank you both
  6. I'm using {{FoundCount}} to get count of filtered records in a portal. This works well when just displaying the count on the layout but I'd like to use that figure as output to a field (regardless if this needs to be a calculation field or just number). How do I have a field track count from a portal?
  7. I have a list of records where I'd like to sum values from one of the fields but "in groups". Each group effectively shares a value in another field. If those other common values match, records in that subset of records are summed. Here's an illustration of my data set and the calculation I'm trying to find. Common value Summed value Sum result (calculation field) 1111 5 8 2222 10 33 1111 3 8 2222 10 33 2222 13 33 Thank you!
  8. Please disregard, crossed posts. That was in regards to your earlier suggestion about applying current formatting on export. This worked perfectly: Let ( t = Sum ( Time Sheet::Hours ) * 3600 ; SerialIncrement ( "00" ; Hour ( t ) ) & SerialIncrement ( ":00" ; Minute ( t ) ) & SerialIncrement ( ":00" ; Seconds ( t ) ) ) Thanks all for pitching in and your help!
  9. ...that doesn't seem to do it. My field is type Calculation with calculation result set to Time
  10. yes, that is my case. I was hoping that the padding could be rolled into the same calculation I'm already performing Sum ( Time Sheet::Hours ) * 3600
  11. I actually need this field as one to export to tab-separated text therefore I have to have the padding in raw value of the field itself...
  12. Thanks, that does it. ...would you know how to pad the hours with a leading zero? Currently it displays as 1:45:00, I'd rather have it as 01:45:00
  13. I have a calculation field that sums time from a portal. Because the portal defines time units in decimals, so does my calc field but I need it to convert the decimals into proper format: hh:mm:ss (ex. 1.75 hours needs to show up as 01:45:00) My current code: Sum ( Time Sheet::Hours )
  14. I'm trying to implement an If statement in my calculation. It works fine as below but that limits found field values only to the specific string - "Part A". I need to be able to also catch values that may have text following the string I have specified, i.e. "Part A and something else". Any suggestions appreciated. If ( tableName::fieldName = "Part A" ; resultOne ; resultTwo )
×

Important Information

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