I've tried everything I can think of, but the "Max to" item only shows up in one list, even though there's data for every sample. And the "plasticity" and "toughness" items are not appearing in the resulting list at all. Can anyone see my error?
<<ListBuildSepTrim(_ ", ",_<<B>><<U>><<STRATIGRAPHY.Geological_Description>><<B>><<U>><<B>> ,_<<IIf(<<STRATIGRAPHY.Gravel>>, <<STRATIGRAPHY.Gravel>>% gravel,)>>,_<<IIf(<<STRATIGRAPHY.Sand_Coarse>>, <<STRATIGRAPHY.Sand_Coarse>>% coarse sand,)>>,_<<IIf(<<STRATIGRAPHY.Sand_Med>>, <<STRATIGRAPHY.Sand_Med>>% medium sand,)>>,_<<IIf(<<STRATIGRAPHY.Sand_Fine>>, <<STRATIGRAPHY.Sand_Fine>>% fine sand,)>>,_<<IIf(<<STRATIGRAPHY.Fines>>, <<STRATIGRAPHY.Fines>>% fines,)>>,_<<IIf(<<STRATIGRAPHY.Max>>, to <<STRATIGRAPHY.Max>>,)>>,_<<IIf(<<STRATIGRAPHY.Plasticity>>, <<STRATIGRAPHY.Plasticity>> plasticity,)>>,_<<IIf(<<STRATIGRAPHY.Toughness>>, <<STRATIGRAPHY.Toughness>> toughness,)>>,_<<STRATIGRAPHY.Color>>,_<<STRATIGRAPHY.Moisture>>,_<<STRATIGRAPHY.HCL>>_)>>
Thanks,
Terry
Hi Terry,
The optimal way to setup building a material description from multiple fields is to setup a component description library table. put your code there and then reference that in the report.
Below is a link that describes the process with a video showing how.
Answer Verified By: Kirk Johnson
Thank you! I looked at the video. Where would I find the Library Data Table that is shown in the video?
(I’m working under the gun here)
TABHA
It is something you would create under Data Design... Library Table... Or you may already have one called Description Soil Lithology that you could edit. I'll call you we should be able to set it up pretty quick
Component Descriptions allow you to combine the data in multiple fields into one description on output. There are many ways to do this and they are documented in this Help file. These methods allow you to build your own rules. With the gINT built-in model for component descriptions you lose a little flexibility but gain dramatically in the ease of setting up the model, implementing it, and maintaining it.
The model is composed of three parts:
Data Design►Library Tables
In Library Tables you need to set up a table. Call it whatever you wish and name the key field whatever you wish. For ease of maintenance, we recommend that you mark the Hidden Counter property at the lower right for the key field. This hides the key field and, on saving in Library Data, the program supplies numeric values for each row corresponding to the row order. In this way you can change the order of the components by just right clicking in the gray column left of a row and dragging it to the desired position.
Data Design►Library Data
Perform your input here. To make expressions easier to create, change the Data Template property (above the grid) to the appropriate file and use the Data Tool at the upper right to paste your field names into the appropriate grid cells.
Reports
The ComponentDesc function is used to print the completed descriptions.
This helped enormously! The parts that were missing from the video were 1) putting a Component Description expression in User System Data
<<ComponentDesc([Soil Lithology Description], true, false)>>
and 2) and adding the User System Data entry to the log template.
Voila!