I’m trying to build a mapping function between API fields and local fields. I tried loading the API fields in a repeating group and added an input field to represent the local field for mapping.
But the issue I’m facing is how to save each field value with its mapped field. Since the inputs are generated dynamically, they don’t have individual names for each input field.
I know there’s an option to achieve what I want through custom JavaScript manipulation, but I’m researching if there’s a best practice for handling this kind of issue.
You can use key-value pairs to store this. Ideally, I use this to mimic a NoSQL DB (where you need not have a strict schema and can dynamically specify table attributes)
I generally implement key-value pairs in 2 ways:
- either has a list of texts, or
- a list of objects with 2 fields (key and value) in a single parent object
Let me know if this would work for you