Search Ref type column with groupby view

[camellia26]

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?

[TeeSee1 · Accepted solution]

Hi

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?advanced=false&allow_punctuati...

You can do a search on "dependent dropdown" in the community.

or start from this help doc

https://support.google.com/appsheet/answer/10099318?hl=en

I am sure you find what you are looking for.

[camellia26]

>TeeSee

Thank you for your info. I checked the page below and the sample app "Lead Tracking" is very useful for me.

https://support.google.com/appsheet/answer/10106620

https://www.appsheet.com/templates/An-app-to-add-and-update-sales-leads?appGuidString=2f43eb0a-1dbf-...

At the moment, there seems to be no way to show a drill-down dropdown, but I'll try use two dropdowns to realize similar UI.