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
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|