<html>
<body>
Dear All,
Anyone can help with one app sheet,
I have created an app from AppSheet which helps to my team update theire location day wise latest percentage. i was used two tables for this. 1st one is "Reference" which is used for referenced data another one is "Master", team updated data will save in Master sheet. Below are the columns i was used
Time_Stamp => Today(), State(Enum) => Reference[State], Location(Enum) => Reference[Location], Sublocation(Enum List)=> SubLoc[Sublocation], Update=> Text
When team tried to update multiple SubLocations at a time, then data will saved in google sheet with Coma separated Sublocations. But i need to save this as individual row per each subtype. Below are the screenshots for your reference.
</body>
<html>
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |