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

653
2
04-10-2020 12:14 PM
AhnaMiller2
Occasional Contributor

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 NumberLocationDateQuantityAsset Year
112343/29/2020 19:00-100002020
156783/29/2020 19:00+100002020
256783/30/2020 19:00-10002020
267893/30/2020 19:00+10002020
0 Kudos
2 Replies
JamesTedrick
Esri Esteemed Contributor

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

0 Kudos
AndrewBowne
Occasional Contributor III

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?  

0 Kudos