Is there a way in Survey123 or Field Maps to allow a user to select from existing sites, then add periodic data that would go into a related table? For a use case, say I'm doing water quality monitoring at a variety of sites in a watershed. I collect data at each site on a periodic basis, say every month. I want to be able to select the already existing site closest to my GPS location on a map or from a list, then add a record of the water quality attributes that would go into its own timestamped row in a related table. I would also like to be able to occasionally add a feature to establish a new site, then periodically add records for that site as well using the app.
The closest functionality I have seen reference to is Repeats, which use a related table. But I don't think what I'm thinking of is handled by the repeat functionality, since repeats are geared toward adding copies of the same inputs on a single form entry. What I want is to repeat the form entry for a single site an unlimited number of times without altering the attributes in the feature table for that site. This would be extremely useful for many scientific data collection purposes.
