Get a summary from a drop down

[galea]

Hi - i would like to ask please i have a drop down list field with repetition, how can i get a summary which shows only the fields that are filled in.

ex i have 5 repetitions of this field if a record has the 5 filled and another has only 3 filled how can i get a summary of the 8 filled fields rather than showing me the 10 of which 2 are empty?

THanks for your help!

[Søren Dyhr]

It's not absolutely clear what you mean by summary here ... similar goes with the drop down list with repetition. Both contains words meaning specific things in the tool - which leaves a something to be desired explanation wise.

If you are summarizing records all having 5 repeaters, will the summary also cantain 5 fields ... provided you gets away from the default shown in the encircled with red area from the dialog shown above. I can't get into my head where the 10 comes from?

Couldn't you when the urge is to make questions so abstract as this, upload a template showing your problem and only this, to eliminate the guesswork. Or simply change behaviour to fully descripe your context and purpose ... since the lions share of developers here won't use repeaters for other purposes than utility-tasks.

Uploading the file you're working with at present won't do I'm afraid, because the time it takes to digest whims of naming conventions and often even attempts to pull the tool as such of the database realm, makes it a near imposible task to do, for even quite expirienced developers.

Your use of repeaters might have seemed obvious, but since this is a relational database shouldn't they have been used in the first place, since it violates the mathematical approach to the workings of an agile base - there is a violation of 1NF which only should been ignored when you know all the rules.... and knows when and when to break them. This is usually called VIRTUE, which seems contra-dictionary to the term novice.

--sd