In App Studio Forms there is the option to have multi-select inputs. I use these to allow business users to select multiple identifying keys to update at once. These entries are saved in a single line as comma-separated values which means they are not useful until processed through some form of ETL. I have received negative feedback from our business users about the lag between making an entry and seeing that update reflected.
I have been able to use a single entry form and a dataset view to achieve a low latency experience but very few of our form use cases would allow single entries.
My proposal is to allow us to save the multi-select fields, or possibly just one per form, in separate rows.
