• Problems with Template Studio atm?

    Daniel Heldt
    Daniel Heldt
    Does anyone else have problems with Template Studio atm? Yesterday all worked fine. But today it crashes every time when i try to save an new expression...
    • Answered
    • 6 months ago
    • OpenGround | gINT | Keynetix
    • OpenGround Forum
  • Output Condition

    Pedro
    Pedro
    I need to give an exit condition for an object in a report in which the field is text, I apply the following but it doesn't work: <<Calc(<<TABLE.Field>> = "4-MP.-blablablabla")>> It doesn't work for me either: (<<TABLE.Field>> = "4-MP.-blablablabla")…
    • 6 months ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • OG Template Studio - Text Function Format Options

    Joseph Ang
    Joseph Ang
    Hi all, I'm looking for a full list of the formats available for the text function. Excel Functions I know the basics from excel apply, however there appear to be some special formats that aren't standard. For example within the Discontinuities Data…
    • 10 months ago
    • OpenGround | gINT | Keynetix
    • OpenGround Forum
  • Template Studio - Can you reference a description in a picklist?

    Joseph Ang
    Joseph Ang
    Hi all, I noticed that within a Data Label Object, you can select the description (from the picklist) as a header. Is there a way to use that value to write expressions? For example, my goal is to have an automatic legend for each borehole log that…
    • Answered
    • 11 months ago
    • OpenGround | gINT | Keynetix
    • OpenGround Forum
  • Importing and excel file with multiple sheets

    Will Zimmerman
    Will Zimmerman
    I am currently trying to optimize my time using gINT, by importing borehole data from excel into gINT. I've already done the practice exercise, and understand how to use the expressions to pull data from excel. The issue is, the current excel workbook…
    • over 1 year ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Trouble with an IFF Statement.

    Mike Ebert
    Mike Ebert
    I have the statement <<IIf(<<ANALYTICAL_RESULTS.Analyte>> = "VC",<<ANALYTICAL_RESULTS.RESULT>>,"False")>> I am using this as a conditional statement to show groundwater results for a certain analyze. This statement keeps resulting as False when I…
    • over 2 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Is there an Expression that will test for specific text ?

    Terry Boutelle
    Terry Boutelle
    Hello, I am trying to add a condition in our log report, in the USCS Symbol column, not to print out the data there if the Sediment Type field at the same depth contains the text "Similar to above". I tried the following: <<IIf(<<STRATIGRAPHY.Sediment…
    • over 6 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Load multiple rules Modules

    Martin A.
    Martin A.
    I have a general piece of code used in many of my rules modules. To clean it up I have tried to move the code to a Public Sub. My problem is how to activate the second rule module. -- I have found the error, never mind..
    • Answered
    • over 9 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Mysterious empty lines in Lists/Component Descriptions

    Pat Cummings
    Pat Cummings
    Mike, I just had the same experience with a ListBuildSepTrim function that included a CompDesc expression. The solution in that case turned out to be: Use a Component Description Format table to build the complete list of elements (instead of ListBuildSepTrim…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Mysterious empty lines in Lists/Component Descriptions

    Pat Cummings
    Pat Cummings
    Diezdaux, how are you entering the bottom of borehole line? Is this entered as a "bogus" lithology entry at a depth below the bottom of the hole, or is it handled by the report as a boundary text element? The former can be caused by the same issue as…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: SQL function in report.

    Pat Cummings
    Pat Cummings
    You are so close! The IIf clause has an optional "if not true" argument that follows the argument when the conditional is true. So your expression: <<IIf(<<METHOD.Description>><>"SPT/C",_ <<Format(<<CALC((<<METHOD.Recovery>>/(<<METHOD.Bottom>>-…
    • over 11 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: If Statement

    Pat Cummings
    Pat Cummings
    Megan, is the field name in BASIN FILL really "Gravel Size (largest)"? Or is that a caption for that field? Also, the condition you are testing against is a text value, so it needs to be delimited with quotes: = "boulders", for example. Finally, the expression…
    • over 11 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: More than one Foreign PointID Expression

    Pat Cummings
    Pat Cummings
    PeeKee, please let us know how you plan to use the associated points - will they simply be listed in the report, or will you use the foreign point(s) as a source of other report information? For example, you can use different foreign PointIDs as the…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: More than one Foreign PointID Expression

    Pat Cummings
    Pat Cummings
    "...I’d like to show CPT and lab test results [for] up to seven associated points for one borehole..." So in that case, you will probably need a loop from 1 to the count of the associated points to establish a single value for the list item position…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Calc Function Fails if One of the Calculated Fields is Empty

    Pat Cummings
    Pat Cummings
    An experienced user asked why the expression <<Calc(<<DRILLDATA.Depth>> + <<DRILLDATA.Length>>)>> only appears to work when there is a Length value in the DRILLDATA table. (The Depth field is required, so it would not be empty.) ANSWER : The “Calc…
    • over 11 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • View related content from anywhere
  • More
  • Cancel