Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a trigger set on my sheet which automatically selects a field when opening the sheet.
Trigger Action: Select in Field
Field: Source
Search String: Car
I want to be able to lock this field including the search string no matter what selections are made on this sheet.
Is this possible?
Thanks.
Add a Lock Field action after the Select in Field action.
I've tried this but it doesn't work.
How do I enter the field and the search string - ie: Source = 'Car'
Which does not work 0 the select or the lock? the two actions work for me.
The select in field works a treat but the lock doesn't work.
If I clear the selections the field and search string that I want to lock down disappears.
Lock applies to the current selection in that field. That's why you make the selection for Source and then Lock Source.
I have the trigger set to make the source selection when opening the sheet including the search string of "Car" then I want to lock it down.
Trigger Action: Select in Field
Field: Source
Search String: Car
Trigger Action: Lock Field
Field: Source
This doesn't work for me - what am I doing wrong?