1. What is the issue? Please be detailed.
I'm currently working on pre-loading form data from a CSV file. However, I've run into a problem with a nested array object that varies in size. The CSV file contains an array with JSON objects that I need to extract and render based on user choices from previous questions. While I am able to render the entire array, I'm struggling to extract the values in a structured and readable way.
2. What steps can we take to reproduce this issue?
Our team is attempting to manage this data using a repeat group, based on our research and assumptions. I have included a screenshot of the form, with the relevant data highlighted. Our goal is to parse and transform this data effectively. Can you provide some guidance on how to accomplish this?
The data highlighted is what needs to be transformed if possible.
3. What have you tried to fix the issue?
Up to this point, we have been attempting to isolate the object within the first element, but we haven't had any success yet. Our next step would be to isolate the first key-value pair within the isolated object. Is this possible? Any suggestions or guidance would be much appreciated.
4. Upload any forms or screenshots you can share publicly below.
Here is the form file
building_form_pc(1).xlsx (11.3 KB)
Here is the CSV
building_asset.csv (12.9 KB)