Use a single survey entry to create multiple records in the same data table

AhnaMiller2 — Fri, 10 Apr 2020 19:14:43 GMT

I am looking to figure out a way I could possibly use a single survey entry to create multiple records in the same data table. For example, I have the following survey I am using to track the locations of assets moving from one location to another:

Naturally this data comes into a very concise table indicating how much of an asset has moved from one location to another location

ObjectID	Origin	Destination	Date	Quantity	Asset Year
1	1234	5678	3/29/2020 19:00	10000	2020
2	5678	6789	3/30/2020 19:00	1000	2020
3	12	6543	3/30/2020 19:00	1200	2020

I'm looking for a way I can manipulate this survey such that the data is entered as 2 different records- one for the incoming location and one for the outgoing location? This way when we export this data it is easier to create a pivot table tallying the number of assets in each locations.

Does anyone have any ideas of how this could be accomplished? I feel like I could potentially accomplish using something like repeats but am struggling to wrap my head around how to get this result

Transaction Number	Location	Date	Quantity	Asset Year
1	1234	3/29/2020 19:00	-10000	2020
1	5678	3/29/2020 19:00	+10000	2020
2	5678	3/30/2020 19:00	-1000	2020
2	6789	3/30/2020 19:00	+1000	2020

Re: Use a single survey entry to create multiple records in the same data table

JamesTedrick — Tue, 14 Apr 2020 21:43:40 GMT

Hi Ahna,

The normal way to modify this would be to make the main part of your form a repeat - see Repeats—Survey123 for ArcGIS | Documentation and Survey123 Tricks of the Trade: Repeats

Re: Use a single survey entry to create multiple records in the same data table

Andrew-Bowne — Thu, 29 Jul 2021 13:56:29 GMT

I'm looking to do the exact same thing however the main for is a standalone, nonspatial table that is not related to any other table. @JamesTedrick - Is this possible?

topic Re: Use a single survey entry to create multiple records in the same data table in ArcGIS Survey123 Questions

Use a single survey entry to create multiple records in the same data table

Re: Use a single survey entry to create multiple records in the same data table

Re: Use a single survey entry to create multiple records in the same data table