Hi all,
I'm running into some limitations on end of borehole text. Please find thought process and attempts below.
1. For reference, end of borehole text goes into this field within the Depth Columns setting. I noticed that by default, there's an expression written here that pulls details from the LocationDetails group.
Default expression: 'Terminated at '+text(fixed([LocationDetails.FinalDepth],2,false))+' ft. '+if(isblank([LocationDetails.TerminationReason]),'',[LocationDetails.TerminationReason]+'.')
2. My goal was to create two headers within LocationDetails.
2a. The first field would be a LongText string field allowing data entry staff to override text printed at the end of the borehole log.
2b. The second field would a string calculation field that would build a sentence based on data entered. This field would only print if the first field has nothing entered.
'Borehole terminated at a depth of ' + text(fixed([LocationDetails.FinalDepth], 1, false)) + ' feet bgs.\n' +
if(count([AggregateAll.ProgressByTime.DepthWater]) = 0, 'Groundwater was not encountered.\n', 'Groundwater was encountered at a depth of ' + text(fixed(first([AggregateAll.ProgressByTime.DepthWater]), 1, false)) + '.\n') +
if(count([AggregateAll.SPT.BlowsMain1]) > 0, 'Blow counts recorded for every 6 inches of drive (or fraction thereof) with a 140-lb automatic trip hammer / 30-inch drop.\n', '') +
if(count([AggregateAll.WindowSampling.Pressure1]) > 0, 'Pressure (psi) recorded to advance D&M Piston, Shelby Tube, and Pitcher Barrel Samplers.', '')
This formula does not work as a header calculation because the 'count' and 'first' functions are log only functions. https://docs.bentley.com/LiveContent/web/OpenGround%20Cloud-v12/en/GUID-2E79ABFA-3652-461D-B855-B4188721A6A2.html
3. I tried skipping the header calculation expressions and putting the expression directly within template studio. This worked, however because the field is ShortText, you cannot copypaste carriage returns into it.
4. After succeeding in step #3, I noticed that the End of Borehole text always prints center aligned even if the Header or text objects (in this case [DescriptionBar]) are left aligned. Furthermore within the Depth Column settings there is no option to change alignment of the text. I tried setting the entire column(s) to left align with no success.
5. This isn't an issue, I am just listing it here for documentation for other OG users. After rewriting the End of Borehole expression to include the override for Data Entry staff, I noticed that writing '\n' into the field does not print a carriage return on the PDF. In this scenario, LongText string fields will accept carriage returns from Data Entry with the following rules.
I have a few questions:
Hi Joseph,
At the moment no. I'll add this as an enhancement
I don't think its planned. I'll check and if it's not I'll add it as an enhancement.
Again, I'll add it as an enhancement.
Martyn
Hi Martyn,
Two more enhancement request on this topic.
1. Currently the end of borehole text expression has no error checking. You can input whatever broken expression into it and it will let you save. Afterwards when you run a quicklog, if the expression has an error, nothing will print to the end of borehole text. Please add error checking to this field.
2. End of Borehole text ignores report template body boundaries. This is a critical error. The text should rollover to the next page.