Select to view content in your preferred language

Issues creating a report template using a table format

116
1
07-31-2025 06:29 AM
TimWeisbrod
New Contributor

This is my first time trying to create a report template.  I am not sure how to fix this error and I am looking for suggestions on that.  I used the downloadable report template to provide syntax to insert into the following table, I keep getting the same error (Error: An error occurred when checking the report template. Failed to parse $(XXXayla_3_sample_is_taken_to) since XXXayla_3_sample_is_taken_to cannot be found in the current parsing scope.). 

                                                                              

 

 

LOG OF TEST PIT NUMBER - ${hole_number_and_depth}

 

 OWNER: ${owner}

SURFACE / HOLE TOP ELEVATION: ${surface_elevation_feet}

FLOOD PRONE AREA: ${flood_prone_areas}

 COUNTY: ${county}

 PRACTICE: ${practice}

PERCHED WATERTABLE ELEVATION: ${perched_water_table_elevation_f}

TOP OF PERCHING LAYER ELEVATION: ${top_of_low_permeability_perchin}

 LAT/LONG: ${lat_long}, ${type_in_latitude_longitude | appearance:"multiline"}

 EQUIPMENT: ${equipment}

SEASONAL HIGH WATER TABLE ELEV. : ${seasonal_high_water_table_eleva} WETLANDS NEAR SITE: ${wetlands_near_the_site}

LANDSCAPE POSITION: ${landscape_position}

SOIL MAP UNIT: ${soil_map_unit}

 LOGGED BY: ${logged_by}

OBSERVED SUBSURFACE SATURATION ELEV. :${observed_significant_subsurface}

OBSERVEDFREE” WATER ELEVATION: ${observed_free_water_elevation_f}

NATIONAL MAP BEDROCK: ${national_bedrock_geology}

BEDROCK ENCOUNTERED: ${predominate_bedrock_type_encoun}

 DATE: ${date_and_time}

TOP OF WEATHERED BEDROCK ELEVATION: ${top_of_weathered_bedrock_elevat}

TOP OF COMPETENT BEDROCK ELEVATION: ${depth_to_competent_bedrock_feet}

KARST TYPE - NATIONAL MAP: ${united_states_karst_map}

KARST FEATURES WITHIN 1000 FT: ${are_there_karst_features_sinkho}

DEPTH

USCS

GRADATION

PLASTICITY

MUNSELL COLOR AND %

MOISTURE

STRUCTURE

GEOLOGY

ADDITIONAL COMMENTS

SAMPLES

 

 

 

FROM

 

 

 

TO

 

 

 

SYMBOL

 

 

 

GROUP NAME

 

 

 

% B

 

 

 

% C

 

 

 

% G

 

 

 

% S

 

 

 

% FINE

 

 

Non, Slightly, Low, Medium, High.

 

 

 

MATRIX

 

 

 

REDOX.

 

 

Dry, Slightly Moist, Moist, Very Moist, Wet.

 

Stratified, Laminated, Fissured, Slicken-sided, Blocky, Pris- matic, Lensed, Massive.

Alluvium, Slope Alluvium, Colluvium, Glacial Till,

Glacial Lake Sediment, Outwash, Residuum, Loess, Bedrock.

Dilatancy: None, Slow, Rapid; Odor (mention if unusual); Consistency (Mention if very soft or soft in wet condition); Location of Seepage and Other Items such as caving or sloughing of pit and how the water enters the pit; Description of lenses and / or mixed materials encountered.

 

 

 

FROM

 

 

 

TO

 

 

#

(FT.)

(FT.)

(i.e-ML)

(i.e.-Silt w/Sand)

>12"

3"-12"

3"-1/4"

1/4"-#200

<#200

(90% 10YR 4/4)

(10% 10YR 5/2)

(FT)

(FT)

${beginning_depth_of_layer_1_in_f}

 

${ending_depth_of_layer_1_in_feet}

 

${layer_1_unified_soil_classifica}

 

${layer_1_full_uscs_group_name_wi}

 

${layer_1_boulders}

 

${layer_1_cobbles}

 

${layer_1_gravel}

 

${layer_1_sand}

 

${layer_1_fines_200_sieve}

 

${plasticity_pi_of_layer_1}

 

${layer_1_matrix_color_percent_of}%

${field_129}

${layer_1_concentrated_redoximorp}

${field_75}%

 

${layer_1_reduced_redoximorphic_f}%

${field_78}

${layer_1_moisture_estimate}

 

${layer_1_soil_structure}

 

${geology_of_layer_1}

 

${field_10 | appearance:"multiline"}

 

 

${layer_1_sample_is_taken_from}

${layer_1_sample_is_taken_to}

${layer_1_sample_name}

${beginning_depth_of_layer_2_in_f}

 

${ending_depth_of_layer_2_in_feet}

 

${layer_2_unified_soil_classifica}

${layer_2_full_uscs_group_name_wi}

${layer_2_boulders}

 

${layer_2_cobbles}

 

${layer_2_gravel}

 

${layer_2_sand}

 

${layer_2_fines_200_sieve}

 

${plasticity_pi_of_layer_2}

 

${layer_2_matrix_color_percent_of}%

${layer_2_soil_matrix_munsell_col}

${layer_2_concentrated_redoximorp}%

${field_114}

 

${layer_2_reduced_redoximorphic_f}%

${field_112}

${layer_2_moisture_estimate}

 

${layer_2_soil_structure}

 

${geology_of_layer_2}

 

${additional_comments_about_layer | appearance:"multiline"}

 

${layer_2_sample_is_taken_from}

 

${field_104}

 

${layer_2_sample_name}

 

${beginning_depth_of_layer_3_in_f}

 

${ending_depth_of_layer_3_in_feet}

 

${layer_3_unified_soil_classifica}

 

${layer_3_full_uscs_group_name_wi}

 

${layer_3_boulders}

 

${layer_3_cobbles}

 

${layer_3_gravel}

 

${layer_3_sand}

 

${layer_3_fines_200_sieve}

 

${plasticity_pi_of_layer_3}

 

${layer_3_matrix_color_percent_of}%

${layer_3_soil_matrix_munsell_col}

${layer_3_concentrated_redoximorp}%

${field_143}

 

${layer_3_reduced_redoximorphic_f}%

 

${field_141}

${layer_3_moisture_estimate}

 

${layer_3_soil_structure}

 

${geology_of_layer_3}

 

${field_135 | appearance:”multiline”}

 

${layer_3_sample_is_taken_from}

 

${ayla_3_sample_is_taken_to}

 

${ayla_3_sample_name}

 

${beginning_depth_of_layer_4_in_f}

${ending_depth_of_layer_4_in_feet}

${layer_4_unified_soil_classifica}

${layer_4_full_uscs_group_name_wi}

 

${ayla_4_boulders}

 

${ayla_4_cobbles}

${layer_4_gravel}

 

${layer_4_sand}

 

${layer_4_fines_200_sieve}

 

${plasticity_pi_of_layer_4}

 

${layer_4_matrix_color_percent_of}%

${layer_4_soil_matrix_munsell_col}

${field_169}

${layer_4_concentrated_redoximorp}

 

${field_167}

${layer_4_reduced_redoximorphic_f}

${layer_4_moisture_estimate}

 

${layer_4_soil_structure}

 

${geology_of_layer_4}

 

${field_163 | appearance:"multiline"}

 

${layer_4_sample_is_taken_from}

 

${layer_4_sample_is_taken_to}

 

${layer_4_sample_name}

 

General Comments: ${general_comments | appearance:"multiline"}

 

 

 

BORING DEPTH:${depth_to_the_end_of_the_boring} ELEV. :${elevation_of_the_end_of_the_bor} REFUSAL TYPE: ${reason_for_ending_the_boring}

DISCLAIMER: ALL SOIL CLASSIFICATIONS FIELD CHECKED. IF CONCLUSIVE SOIL CLASSIFICATION RESULTS ARE REQUIRED FOR ENGINEERING PURPOSES THEN SEND A SAMPLE OF IT TO THE LAB.

0 Kudos
1 Reply
TylerGraham2
Frequent Contributor

What that is saying is it can't find a matching field in the layer to pull data from. This can happen a couple of ways.

First, make sure the field name matches exactly, for example if you have a field "Location" and in the template call ${location} you'll get the error. Looking at your table is the "ayla" part of the name supposed to be "layer"?

Make sure you're using squiggly brackets {} and not parenthesis () when calling fields in the template.

Also, if the field is in a repeat and you call it outside of the repeat table/layer you'll get the error. If you have a repeat called "locations" with a field named "Location" you need to open and close the repeat table.

${#locations}

{Location}

${/}

Conversely if you opened a repeat and forgot to close it with the ${/} you'll get the error.

And finally, sometimes it just hates you. I've found that if you open repeats or if statements in a table it gets really finicky throws that error because it doesn't like that you used a Word header style to open it and closed it with the formatting set as a body style.

0 Kudos