I am having some trouble on how to design a schema for a collection I want to store with Firebase. Essentially, users on the app will be able to complete some questionnaires, and I would like to store these results on the backend, namely when the questionnaire was completed, and their score.
The issue is that some questionnaires do not result in only one score, but rather multiple, so using a single score property is not possible. Since Firebase does not require all documents in a collection to be the same, I was thinking of using a dictionary mapping score names to the resultant score, but it seems that FlutterFlow does not support this, rather it has to be a fixed data type.
With regards to this, I tried to use a list of fixed data type of { scoreType: String, score: Int }, which I could then filter for the single property I want to display by scoreType, however I can't seem to do this in FlutterFlow? The only other solution I thought of was to use a list of integers, which I think would work, but this would require knowing at which index each score is stored and ensuring that this is consistent.
Any help with this would be greatly appreciated, thanks!