Perform a search by name and give all selections made by that name

[Dave_Beaumont]

Hoping for some help!! I have a google sheet that collects data from indviduallys on a weekly basis I was hoping to create something where the user can enter there name in a search box and it will show every entry they have added throughout the whole of the spreadsheet??

Any help would be massively aprecciated!!

Cheers

[khuslid]

Do you want to do this in Appsheet or in the spreadsheet?

[Dave_Beaumont]

In appsheet so people can use an app to see what selections they have made in the past

[khuslid]

Ok.
The search function i Appsheet works really well.
So if every entry regarding the person also collects either useremail or name, the search should work great.
When entry of a record, just make sure to have a column for either useremail() or name. You can have this filled in automatically by using initial value. Eg: USEREMAIL() or LOOKUP(USEREMAIL(), Emplyees_table, Email, Name)