Consolidating Multiple Repeats into a Single Table Layer

[BelindaPurser]

I have an Inspection Form we are using in the Field that includes multiple Repeats when reporting issues and the actions taken to remedy them.

Is it possible to consolidate all the Repeats into one Table Layer instead of Individual Table Layers?

At the moment I have a total of 48 Repeats all within different Groups and Questions

The Layout is:

Group 1

Question 1, Repeat Action 1

Question 2, Repeat Action 2

Group 2 

Question 1, Repeat Action 1

Question 2, Repeat Action 2

etc.

[Neal_t_k]

Can you show an example of what you want the end data to look like?  For instance in your layout example is Question 1 from Group 1 the same question as Question1 from Group2 or is it just the first question from each group. Some clarification on what you are trying to achieve would help with some ideas for consolidation.

[ZenMasterZeke]

Could you try 1 repeat with multiple groups? I haven't really thought this through, so not sure how that would play out.

[BelindaPurser]

begin group	safety	<b><font color='blue'>SAFETY</b>
note	hzrd_mgmt	<b>HAZARD MANAGEMENT</b>
select_one list_yes_no_na	hzrds_mngd	Are Hazards Identified & Managed Adequately
select_multiple list_hzrds_issues	hzrds_issues	What are the Hazard Issues? (Select all that apply)</b>
text	hzrds_issues_other	Other
select_one list_yes_no_na	hzrds_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_hzrds_action_tkn	hzrds_action_tkn	Hazard Action Taken (Select all that apply)</b>
text	hzrds_action_tkn_other	Other
text	hzrds_uhf	UHF Channel Changed to:
select_one list_yes_no_na	hzrds_fup_reqd	Is Hazard Follow-Up Action Required?
image	hzrds_photos	Hazard Photo/s (if required)
begin repeat	rpt_hzrds	Hazard Action Details
geopoint	hzrds_location	Hazard Location
select_multiple list_hzrds_fup_actions	hzrds_fup_actions	Hazard Follow-Up Actions (Select all that apply)</b>
text	hzrds_fup_actions_other	Other
date	hzrds_fup_duedate	Hazard Action Due Date:
text	hzrds_action_comp	Hazard Action Completed By:
date	hzrds_comp_date	Hazard Completion Date:
text	hzrds_doc_ref	Hazard Document (CM) Reference:
end repeat
note	first_aid	<b>FIRST AID</b>
select_one list_yes_no_na	first_aid_adeq	Are First Aid Personnel & Equipment Adequate
select_multiple list_first_aid_issues	first_aid_issues	What are the First Aid Issues? (Select all that apply)</b>
text	first_aid_issues_other	Other
select_one list_yes_no_na	first_aid_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_first_aid_action_tkn	first_aid_action_tkn	First Aid Action Taken (Select all that apply)</b>
text	first_aid_action_tkn_other	Other
select_one list_yes_no_na	first_aid_fup_reqd	Is First Aid Follow-Up Action Required?
image	first_aid_photos	First Aid Photo/s (if required)
begin repeat	rpt_first_aid	First Aid Action Details
geopoint	first_aid_location	First Aid Equipment Location
select_multiple list_first_aid_fup_actions	first_aid_fup_actions	First Aid Follow-Up Actions (Select all that apply)</b>
text	first_aid_fup_actions_other	Other
date	first_aid_fup_duedate	First Aid Action Due Date:
text	first_aid_action_comp	First Aid Action Completed By:
date	first_aid_comp_date	First Aid Completion Date:
text	first_aid_doc_ref	First Aid Document (CM) Reference:
end repeat
note	comms	<b>COMMUNICATIONS SYSTEMS & PROTOCOLS</b>
select_one list_yes_no_na	comms_adeq	Are Effective Communication Systems & Protocols Being Utilised?
select_multiple list_comms_issues	comms_issues	What are the Communications Issues? (Select all that apply)</b>
text	comms_issues_other	Other
select_one list_yes_no_na	comms_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_comms_action_tkn	comms_action_tkn	Communications Action Taken (Select all that apply)</b>
text	comms_action_tkn_other	Other
select_one list_yes_no_na	comms_fup_reqd	Is Communications Follow-Up Action Required?
image	comms_photos	Communications Photo/s (if required)
begin repeat	rpt_comms	Communications Action Details
geopoint	comms_location	Communications Location
select_multiple list_comms_fup_actions	comms_fup_actions	Communications Follow-Up Actions (Select all that apply)</b>
text	comms_fup_actions_other	Other
date	comms_fup_duedate	Communications Action Due Date:
text	comms_action_comp	Communications Action Completed By:
date	comms_comp_date	Communications Completion Date:
text	comms_doc_ref	Communications Document (CM) Reference:
end repeat
note	ppe	<b>PERSONAL PROTECTIVE EQUIPMENT (PPE)</b>
select_one list_yes_no_na	ppe_adeq	Is the Personal Protective Equipment (PPE) Adequate?
select_multiple list_ppe_issues	ppe_issues	What are the PPE Issues? (Select all that apply)</b>
text	ppe_issues_other	Other
select_one list_yes_no_na	ppe_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_ppe_action_tkn	ppe_action_tkn	PPE Action Taken (Select all that apply)</b>
text	ppe_action_tkn_other	Other
select_one list_yes_no_na	ppe_fup_reqd	Is PPE Follow-Up Action Required?
image	ppe_photos	PPE Photo/s (if required)
begin repeat	rpt_ppe	PPE Action Details
geopoint	ppe_location	PPE Location
select_multiple list_ppe_fup_actions	ppe_fup_actions	PPE Follow-Up Actions (Select all that apply)</b>
text	ppe_fup_actions_other	Other
date	ppe_fup_duedate	PPE Action Due Date:
text	ppe_action_comp	PPE Action Completed By:
date	ppe_comp_date	PPE Completion Date:
text	ppe_doc_ref	PPE Document (CM) Reference:
end repeat
note	fire_equip	<b>FIRE EQUIPMENT</b>
select_one list_yes_no_na	fire_equip_adeq	Is the Fire Equipment On-Site & Operational with Adherence to FPC Fire Guidelines?
select_multiple list_fire_equip_issues	fire_equip_issues	What are the Fire Equipment Issues? (Select all that apply)</b>
text	fire_equip_issues_other	Other
select_one list_yes_no_na	fire_equip_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_fire_equip_action_tkn	fire_equip_action_tkn	Fire Equipment Action Taken (Select all that apply)</b>
text	fire_equip_action_tkn_other	Other
select_one list_yes_no_na	fire_equip_fup_reqd	Is Fire Equipment Follow-Up Action Required?
image	fire_equip_photos	Fire Equipment Photo/s (if required)
begin repeat	rpt_fire_equip	Fire Equipment Action Details
geopoint	fire_equip_location	Fire Equipment Location
select_multiple list_fire_equip_fup_actions	fire_equip_fup_actions	Fire Equipment Follow-Up Actions (Select all that apply)</b>
text	fire_equip_fup_actions_other	Other
date	fire_equip_fup_duedate	Fire Equipment Action Due Date:
text	fire_equip_action_comp	Fire Equipment Action Completed By:
date	fire_equip_comp_date	Fire Equipment Completion Date:
text	fire_equip_doc_ref	Fire Equipment Document (CM) Reference:
end repeat
note	fire_regs	<b>FIRE REGULATIONS & WARNINGS</b>
select_one list_yes_no_na	fire_regs_adhd	Are the Fire Regulations & Warnings Being Adhered to?
select_multiple list_fire_regs_issues	fire_regs_issues	What are the Fire Regulations Issues? (Select all that apply)</b>
text	fire_regs_issues_other	Other
select_one list_yes_no_na	fire_regs_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_fire_regs_action_tkn	fire_regs_action_tkn	Fire Regulations Action Taken (Select all that apply)</b>
text	fire_regs_action_tkn_other	Other
select_one list_yes_no_na	fire_regs_fup_reqd	Is Fire Regulations Follow-Up Action Required?
image	fire_regs_photos	Fire Regulations Photo/s (if required)
begin repeat	rpt_fire_regs	Fire Regulations Action Details
geopoint	fire_regs_location	Fire Regulations Location
select_multiple list_fire_regs_fup_actions	fire_regs_fup_actions	Fire Regulations Follow-Up Actions (Select all that apply)</b>
text	fire_regs_fup_actions_other	Other
date	fire_regs_fup_duedate	Fire Regulations Action Due Date:
text	fire_regs_action_comp	Fire Regulations Action Completed By:
date	fire_regs_comp_date	Fire Regulations Completion Date:
text	fire_regs_doc_ref	Fire Regulations Document (CM) Reference:
end repeat
note	fbs	<b>FIREBREAKS</b>
select_one list_yes_no_na	fbs_clr_trfcbl	Are the Firebreaks Clear & Trafficable?
select_multiple list_fbs_issues	fbs_issues	What are the Firebreak Issues? (Select all that apply)</b>
text	fbs_issues_other	Other
select_one list_yes_no_na	fbs_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_fbs_action_tkn	fbs_action_tkn	Firebreak Action Taken (Select all that apply)</b>
text	fbs_action_tkn_other	Other
select_one list_yes_no_na	fbs_fup_reqd	Is Firebreak Follow-Up Action Required?
image	fbs_photos	Firebreak Photo/s (if required)
begin repeat	rpt_fbs	Firebreak Action Details
geoshape	fbs_location	Firebreak Location
select_multiple list_fbs_fup_actions	fbs_fup_actions	Firebreak Follow-Up Actions (Select all that apply)</b>
text	fbs_fup_actions_other	Other
date	fbs_fup_duedate	Firebreak Action Due Date:
text	fbs_action_comp	Firebreak Action Completed By:
date	fbs_comp_date	Firebreak Completion Date:
text	fbs_doc_ref	Firebreak Document (CM) Reference:
end repeat
note	equipment_machinery_clean	<b>MACHINERY & EQUIPMENT CLEAN</b>
select_one list_yes_no_na	mchnry_equip_cln	Is the Machinery & Equipment Suitably Clean & Maintained (Including Guards)?
select_multiple list_mchnry_equip_cln_issues	mchnry_equip_cln_issues	What are the Machinery & Equipment Cleanliness / Maintenance Issues? (Select all that apply)</b>
text	mchnry_equip_cln_issues_other	Other
select_one list_yes_no_na	mchnry_equip_cln_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_mchnry_equip_cln_action_tkn	mchnry_equip_cln_action_tkn	Machinery & Equipment Cleanliness / Maintenance Action Taken (Select all that apply)</b>
text	mchnry_equip_cln_action_tkn_other	Other
select_one list_yes_no_na	mchnry_equip_cln_fup_reqd	Is Machinery & Equipment Cleanliness / Maintenance Follow-Up Action Required?
image	mchnry_equip_cln_photos	Machinery & Equipment Cleanliness / Maintenance Photo/s (if required)
begin repeat	rpt_mchnry_equip_cln	Machinery & Equipment Cleanliness / Maintenance Action Details
geopoint	mchnry_equip_cln_location	Machinery & Equipment Cleanliness / Maintenance Location
select_multiple list_mchnry_equip_cln_fup_actions	mchnry_equip_cln_fup_actions	Machinery & Equipment Cleanliness / Maintenance Follow-Up Actions (Select all that apply)</b>
text	mchnry_equip_cln_fup_actions_other	Other
date	mchnry_equip_cln_fup_duedate	Machinery & Equipment Cleanliness / Maintenance Action Due Date:
text	mchnry_equip_cln_action_comp	Machinery & Equipment Cleanliness / Maintenance Action Completed By:
date	mchnry_equip_cln_comp_date	Machinery & Equipment Cleanliness / Maintenance Completion Date:
text	mchnry_equip_cln_doc_ref	Machinery & Equipment Cleanliness / Maintenance Document (CM) Reference:
end repeat
note	machinery_fitness	<b>MACHINERY FITNESS</b>
select_one list_yes_no_na	mchnry_fit	On Visual Inspection, is 'Machinery Fit for Work'? (e.g. Tyres, Hoses, Guards, Oil Leaks, Windscreen Damage etc.)
select_multiple list_mchnry_fit_issues	mchnry_fit_issues	What are the Machinery Fitness Issues? (Select all that apply)</b>
text	mchnry_fit_issues_other	Other
select_one list_yes_no_na	mchnry_fit_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_mchnry_fit_action_tkn	mchnry_fit_action_tkn	Machinery Fitness Action Taken (Select all that apply)</b>
text	mchnry_fit_action_tkn_other	Other
select_one list_yes_no_na	mchnry_fit_fup_reqd	Is Machinery Fitness Follow-Up Action Required?
image	mchnry_fit_photos	Machinery Fitness Photo/s (if required)
begin repeat	rpt_mchnry_fit	Machinery Fitness Action Details
geopoint	mchnry_fit_location	Machinery Fitness Location
select_multiple list_mchnry_fit_fup_actions	mchnry_fit_fup_actions	Machinery Fitness Follow-Up Actions (Select all that apply)</b>
text	mchnry_fit_fup_actions_other	Other
date	mchnry_fit_fup_duedate	Machinery Fitness Action Due Date:
text	mchnry_fit_action_comp	Machinery Fitness Action Completed By:
date	mchnry_fit_comp_date	Machinery Fitness Completion Date:
text	mchnry_fit_doc_ref	Machinery Fitness Document (CM) Reference:
end repeat
note	equipment_fitness	<b>EQUIPMENT FITNESS</b>
select_one list_yes_no_na	equip_fit	Is the Equipment Available 'Fit for Purpose'?
select_multiple list_equip_fit_issues	equip_fit_issues	What are the Equipment Fitness Issues? (Select all that apply)</b>
text	equip_fit_issues_other	Other
select_one list_yes_no_na	equip_fit_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_equip_fit_action_tkn	equip_fit_action_tkn	Equipment Fitness Action Taken (Select all that apply)</b>
text	equip_fit_action_tkn_other	Other
select_one list_yes_no_na	equip_fit_fup_reqd	Is Equipment Fitness Follow-Up Action Required?
image	equip_fit_photos	Equipment Fitness Photo/s (if required)
begin repeat	rpt_equip_fit	Equipment Fitness Action Details
geopoint	equip_fit_location	Equipment Fitness Location
select_multiple list_equip_fit_fup_actions	equip_fit_fup_actions	Equipment Fitness Follow-Up Actions (Select all that apply)</b>
text	equip_fit_fup_actions_other	Other
date	equip_fit_fup_duedate	Equipment Fitness Action Due Date:
text	equip_fit_action_comp	Equipment Fitness Action Completed By:
date	equip_fit_comp_date	Equipment Fitness Completion Date:
text	equip_fit_doc_ref	Equipment Fitness Document (CM) Reference:
end repeat
note	access_roads	<b>ACCESS</b>
select_one list_yes_no_na	access	Are Existing Access and Internal Roads / Tracks / Firebreaks, Clear & Trafficable at the End of the Day?
select_multiple list_access_issues	access_issues	What are the Access Issues? (Select all that apply)</b>
text	access_issues_other	Other
select_one list_yes_no_na	access_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_access_action_tkn	access_action_tkn	Access Action Taken (Select all that apply)</b>
text	access_action_tkn_other	Other
select_one list_yes_no_na	access_fup_reqd	Is Access Follow-Up Action Required?
image	access_photos	Access Photo/s (if required)
begin repeat	rpt_access	Access Action Details
geoshape	access_location	Access Location
select_multiple list_access_fup_actions	access_fup_actions	Access Follow-Up Actions (Select all that apply)</b>
text	access_fup_actions_other	Other
date	access_fup_duedate	Access Action Due Date:
text	access_action_comp	Access Action Completed By:
date	access_comp_date	Access Completion Date:
text	access_doc_ref	Access Document (CM) Reference:
end repeat
note	fences_structures	<b>FENCES & STRUCTURES</b>
select_one list_yes_no_na	fences	Are the Fences & Structures Protected Adequately?
select_multiple list_fences_issues	fences_issues	What are the Fences & Structures Issues? (Select all that apply)</b>
text	fences_issues_other	Other
select_one list_yes_no_na	fences_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_fences_action_tkn	fences_action_tkn	Fences & Structures Action Taken (Select all that apply)</b>
text	fences_action_tkn_other	Other
select_one list_yes_no_na	fences_fup_reqd	Is Fences & Structures Follow-Up Action Required?
image	fences_photos	Fences & Structures Photo/s (if required)
begin repeat	rpt_fences	Fences & Structures Action Details
geotrace	fences_location	Fences & Structures Location
select_multiple list_fences_fup_actions	fences_fup_actions	Fences & Structures Follow-Up Actions (Select all that apply)</b>
text	fences_fup_actions_other	Other
date	fences_fup_duedate	Fences & Structures Action Due Date:
text	fences_action_comp	Fences & Structures Action Completed By:
date	fences_comp_date	Fences & Structures Completion Date:
text	fences_doc_ref	Fences & Structures Document (CM) Reference:
end repeat
note	felling_techniques	<b>FELLING TECHNIQUES</b>
select_one list_yes_no_na	felling	Are the Felling Techniques Adequate?
select_multiple list_felling_issues	felling_issues	What are the Felling Techniques Issues? (Select all that apply)</b>
text	felling_issues_other	Other
select_one list_yes_no_na	felling_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_felling_action_tkn	felling_action_tkn	Felling Techniques Action Taken (Select all that apply)</b>
text	felling_action_tkn_other	Other
select_one list_yes_no_na	felling_fup_reqd	Is Felling Techniques Follow-Up Action Required?
image	felling_photos	Felling Techniques Photo/s (if required)
begin repeat	rpt_felling	Felling Techniques Action Details
geoshape	felling_location	Felling Techniques Location
select_multiple list_felling_fup_actions	felling_fup_actions	Felling Techniques Follow-Up Actions (Select all that apply)</b>
text	felling_fup_actions_other	Other
date	felling_fup_duedate	Felling Techniques Action Due Date:
text	felling_action_comp	Felling Techniques Action Completed By:
date	felling_comp_date	Felling Techniques Completion Date:
text	felling_doc_ref	Felling Techniques Document (CM) Reference:
end repeat
note	landing_management	<b>LANDING MANAGEMENT</b>
select_one list_yes_no_na	landing_mgmt	Is the Landing Management Adequate?
select_multiple list_landing_mgmt_issues	landing_mgmt_issues	What are the Landing Management Issues? (Select all that apply)</b>
text	landing_mgmt_issues_other	Other
select_one list_yes_no_na	landing_mgmt_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_landing_mgmt_action_tkn	landing_mgmt_action_tkn	Landing Management Action Taken (Select all that apply)</b>
text	landing_mgmt_action_tkn_other	Other
select_one list_yes_no_na	landing_mgmt_fup_reqd	Is Landing Management Follow-Up Action Required?
image	landing_mgmt_photos	Landing Management Photo/s (if required)
begin repeat	rpt_landing_mgmt	Landing Management Action Details
geoshape	landing_mgmt_location	Landing Management Location
select_multiple list_landing_mgmt_fup_actions	landing_mgmt_fup_actions	Landing Management Follow-Up Actions (Select all that apply)</b>
text	landing_mgmt_fup_actions_other	Other
date	landing_mgmt_fup_duedate	Landing Management Action Due Date:
text	landing_mgmt_action_comp	Landing Management Action Completed By:
date	landing_mgmt_comp_date	Landing Management Completion Date:
text	landing_mgmt_doc_ref	Landing Management Document (CM) Reference:
end repeat
note	rd_warning_signs	<b>ROAD WARNING SIGNS</b>
select_one list_yes_no_na	rd_signs	Are the Road Warning Signs Adequate?
select_multiple list_rd_signs_issues	rd_signs_issues	What are the Road Warning Signs Issues? (Select all that apply)</b>
text	rd_signs_issues_other	Other
select_one list_yes_no_na	rd_signs_compliance	Does this Matter Constitute a Non-Compliance?
select_multiple list_rd_signs_action_tkn	rd_signs_action_tkn	Road Warning Signs Action Taken (Select all that apply)</b>
text	rd_signs_action_tkn_other	Other
select_one list_yes_no_na	rd_signs_fup_reqd	Is Road Warning Signs Follow-Up Action Required?
image	rd_signs_photos	Road Warning Signs Photo/s (if required)
begin repeat	rpt_rd_signs	Road Warning Signs Action Details
geotrace	rd_signs_location	Road Warning Signs Location
select_multiple list_rd_signs_fup_actions	rd_signs_fup_actions	Road Warning Signs Follow-Up Actions (Select all that apply)</b>
text	rd_signs_fup_actions_other	Other
date	rd_signs_fup_duedate	Road Warning Signs Action Due Date:
text	rd_signs_action_comp	Road Warning Signs Action Completed By:
date	rd_signs_comp_date	Road Warning Signs Completion Date:
text	rd_signs_doc_ref	Road Warning Signs Document (CM) Reference:
end repeat

[Neal_t_k · Accepted solution]

@BelindaPurser Attached is an idea for you.  You have a lot of redundancy in your groups, It appears you have the same amount of questions with just the slight wording differences and of course group name.  You could approach this as a nested repeat, with each group item being the parent repeat.   Using count-selected() and selected-at(), You could automatically set the number of parent repeats and set each of those items to each of your groups.   You could then make master lists for Issues, action_tkn, and actions and use a choice filter to filter them to the group selection.  Make at least one of the questions required in the parent repeat so users can't skip them.

Survey123 Tricks of the Trade: Choice Filters - Esri Community

 This would drop your backend down to 3 tables.

That said, user would have to get use to a "page" type format instead of a scroll.

[BelindaPurser]

Thank you, 

This looks like a much better solution. 👍