Utilize pulldata to show multiple rows or "table"

OscarSepulveda_III — Tue, 08 Aug 2017 02:01:10 GMT

I am wanting to utilize the #pulldata function to show multiple rows of data instead of just one. The end user would choose a communications plan with the radio frequencies populating various functions.

In the table below, if the user chose 'ALAMEDA', then listed would be the 'FUNCTION_RANK' followed by the 'FREQ_TYPE_ZONE_CH'. Any help would be appreciated, as I want this form to work off one choice not multiple.

COMMPLAN	FUNCTION_RANK	FREQ_TYPE_ZONE_CH
ALAMEDA	COMMAND 1	LAC V3 VHF [ ZONE: 1 CHANNEL: 3 ] [ ZONE: 2 CHANNEL: 1 ]
ALAMEDA	COMMAND 2	LAC V4 VHF [ ZONE: 1 CHANNEL: 4 ] [ ZONE: 2 CHANNEL: 2 ]
ALAMEDA	COMMAND 3	LAC V5 VHF [ ZONE: 1 CHANNEL: 5 ] [ ZONE: 2 CHANNEL: 3 ]
ALAMEDA	CMD/TAC 1	VER V1 VHF [ ZONE: 1 CHANNEL: 55 ] [ ZONE: 2 CHANNEL: 4 ]
ALAMEDA	CMD/TAC 2	XLE V2 VHF [ ZONE: 1 CHANNEL: 82 ] [ ZONE: 2 CHANNEL: 5 ]
ALAMEDA	TACTICAL 1	VFIRE22 VHF [ ZONE: 1 CHANNEL: 61 ] [ ZONE: 2 CHANNEL: 6 ]
ALAMEDA	TACTICAL 2	VFIRE23 VHF [ ZONE: 1 CHANNEL: 62 ] [ ZONE: 2 CHANNEL: 7 ]
ALAMEDA	TACTICAL 3	VFIRE24 VHF [ ZONE: 1 CHANNEL: 63 ] [ ZONE: 2 CHANNEL: 8 ]
ALAMEDA	TACTICAL 4	VFIRE25 VHF [ ZONE: 1 CHANNEL: 64 ] [ ZONE: 2 CHANNEL: 9 ]
ALAMEDA	TACTICAL 5	VFIRE26 VHF [ ZONE: 1 CHANNEL: 65 ] [ ZONE: 2 CHANNEL: 10 ]
ALAMEDA	TACTICAL 6	VTAC11 VHF [ ZONE: 1 CHANNEL: 56 ] [ ZONE: 2 CHANNEL: 11 ]
ALAMEDA	TACTICAL 7	VTAC13 VHF [ ZONE: 1 CHANNEL: 58 ] [ ZONE: 2 CHANNEL: 12 ]
FOOTHILL	COMMAND 1	ANF VHF [ ZONE: 1 CHANNEL: 21 ] [ ZONE: 3 CHANNEL: 9 ]
FOOTHILL	COMMAND 2	LAC V3 VHF [ ZONE: 1 CHANNEL: 3 ] [ ZONE: 2 CHANNEL: 1 ]
FOOTHILL	COMMAND 3	LAC V4 VHF [ ZONE: 1 CHANNEL: 4 ] [ ZONE: 2 CHANNEL: 2 ]
FOOTHILL	COMMAND 4	LAC V5 VHF [ ZONE: 1 CHANNEL: 5 ] [ ZONE: 2 CHANNEL: 3 ]
FOOTHILL	COMMAND 5	LARTCS3V VHF [ ZONE: 1 CHANNEL: 37 ] [ ZONE: 7 CHANNEL: 5 ]
FOOTHILL	TACTICAL 1	NIFC T1 VHF [ ZONE: 3 CHANNEL: 11 ] [ ZONE: 7 CHANNEL: 6 ]
FOOTHILL	TACTICAL 2	NIFC T2 VHF [ ZONE: 3 CHANNEL: 12 ] [ ZONE: 4 CHANNEL: 11 ]
FOOTHILL	TACTICAL 3	VFIRE22 VHF [ ZONE: 1 CHANNEL: 61 ] [ ZONE: 2 CHANNEL: 6 ]
FOOTHILL	TACTICAL 4	VFIRE23 VHF [ ZONE: 1 CHANNEL: 62 ] [ ZONE: 2 CHANNEL: 7 ]
FOOTHILL	TACTICAL 5	VFIRE24 VHF [ ZONE: 1 CHANNEL: 63 ] [ ZONE: 2 CHANNEL: 8 ]
FOOTHILL	TACTICAL 6	VFIRE25 VHF [ ZONE: 1 CHANNEL: 64 ] [ ZONE: 2 CHANNEL: 9 ]
FOOTHILL	TACTICAL 7	VFIRE26 VHF [ ZONE: 1 CHANNEL: 65 ] [ ZONE: 2 CHANNEL: 10 ]
FOOTHILL	AIR-to-GROUND 1	AG 59 VHF [ ZONE: 3 CHANNEL: 14 ] [ ZONE: 4 CHANNEL: 14 ]
FOOTHILL	AIR-to-GROUND 2	LAC AG VHF [ ZONE: 1 CHANNEL: 15 ] [ ZONE: 2 CHANNEL: 16 ]
FOOTHILL	AIR-to-GROUND 3	XLC AG VHF [ ZONE: 1 CHANNEL: 80 ] [ ZONE: 7 CHANNEL: 15 ]
FOOTHILL	EMERGENCY 1	AIR GUARD VHF [ ZONE: 1 CHANNEL: 16 ] [ ZONE: 3 CHANNEL: 16 ]
FOOTHILL	COMMAND 1	ANF VHF [ ZONE: 1 CHANNEL: 21 ] [ ZONE: 3 CHANNEL: 9 ]

Re: Utilize pulldata to show multiple rows or "table"

JohnathanHasthorpe — Tue, 08 Aug 2017 03:02:41 GMT

Hi Oscar,

Pulldata will return a value from a single column only. To achieve the above, then you will need to create a new column in the .csv that contains a concatenated version of FUNCTION_RANK and FREQ_TYPE_ZONE_CH. You can then use pulldata to return this string to the user.

Regards

John

topic Utilize pulldata to show multiple rows or "table" in ArcGIS Survey123 Questions

Utilize pulldata to show multiple rows or "table"

Re: Utilize pulldata to show multiple rows or "table"