My DailyReports app can add daily works as items to each report, like one daily report has work A and work B(each item is recorded at WorkDetail table). In work detail items, I can input “place” column as a Ref item from Places table.
When trying to add a place(“Farm” below), I can see search bar and suggestions(existing items; place A, B and C) but every items are enumerated from the beginning to the end of records. I hope to select a value with groupby view, like Area A → Farm A and B, Area B → Farm D and F.
I tried to use Slice feature but it doesn’t work as I want. Can you tell me how to do that?
