Daily driver attendance log form

[YANKEES0242]

Would like to create a better form for our drivers ideally one where you can choose your route and then select yes or no for pickup. Some routes have only 2 and max is 8 clients. I created this(see attached pictures) But when it goes to the google sheet all the clients picked up go into the same cell making it really had to create an easy user form for my boss to see who was picked up or not!

[dbaum]

If you're just seeking a way to present more legibly the list from each row's "Picked up" column, try a technique like the following:  Concatenate values with a delimiter: How to simula... - Google Cloud Community .

Consider also using a different data structure to begin with where each "Picked up" name is stored separately: The "item-detail" data pattern - AppSheet Help. 

[Joseph_Seddik]

Have a separate Clients table, with a unique ID key column, and a Client Name column marked as Label.

Your Picked Up column should be an EnumList with base type Ref pointing to the Clients table. This is what you should use in Form views.

For all other views, create a virtual column of type List and an app formula: [Picked Up]