I've created a form which collects some common data, and then multiple requests, each with their own data. For example, I'm collecting the requestor's name, and 25 bits of data they want added into our system. The 25 bits of data all share the same properties, but it's very unwieldy to have all on a single row in the intake sheet.
To better format the resulting data, I'd like to create a new row in a separate sheet for each of the requests. I've created a DataMesh config for each request (just 2 so far), which grabs the common data and the request data, then sticks them into matching columns in a new sheet. This should result in one form submission turning into 25 rows, each with the requestor's name, and each row having the unique data for each request. This works in my head, but in practice I can't get the DataMesh configs beyond the first one to create new rows. Config 2 claims that the existing rows should be unaffected because "data already exists and is consistent with Source sheet," but the data in these columns are not the same as the source sheet. The only data that are the same are the lookup values.
I can't find any more detailed documentation of how to use DataMesh, and I feel like I'm fundamentally misunderstanding how lookup values work, so if anyone could set me straight, I'd greatly appreciate it. Thanks.