we are a community group in UK trying to create a list to honour the fallen of the two world wars.. we have researched this and using excellent coding from here https://infoinspired.com/google-docs/spreadsheet/filter-rows-if-search-key-present-in-any-cell-in-that-rows-in-google-sheets/ have shared a test version here https://docs.google.com/spreadsheets/d/1VyKI4LjtK9QwF88n6VlttLGudTLJoNHnr1e_LHADyuU/edit#gid=1952012505 we have protected all but B1:D1 and anyone typing in here "Smith" "Brown" etc sees the relevant records
Our question is "can we do this so more than ONE person can use it at a time WITHOUT affecting the other users? I am aware it may not be a feature that is possible on google sheets so would value your recommendations -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/f79df943-4a44-4835-aca6-a2a4bac44c20n%40googlegroups.com.
