Looking for solution for Forms to add multiple rows to a sheet
I have a problem that I'm trying to find a solution for. We are looking to collect Patient Day information from up to 180 Hospital facilities for them to be able to report on # of days per unit in their facility. There could be up 20+ units that users would have to enter data for and completing individual forms (20 times) is not going to work for the users, to the point that they will not use this to report from.
So we are going to give them the option to select multiple units and report the days for those units, but the issue is on the back end when it comes time to reconcile the data so that it can then be uploaded to our Analytics solution.
I've searched and found these possible solutions, but they are old and hard to understand:
Here is a sample of what we're trying to accomplish.
User will have the option to select multiple Units and enter a number of Days for that unit.
When submitted, it currently only creates 1 row in the spreadsheet with the multiple values in the Unit Cell
Preferably we would like it to show:
If I can get it to this, then I can create a column called Unit Days and do a join across the Test Unit 1 Days through the Test Unit 3 Days to populate this new column and hide the Test Unit 1, Test Unit 2, Test Unit 3. As such:
I hope that this kind of gives you an idea of what I’m trying to do.
I did submit an enhancement request, but who knows when that will ever be implemented.
Any help that someone may be able to provide would be greatly appreciated.
Thank you for looking