Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I load DomainUser and Sheet in script. The application contains three sheets in GUI. When USER1 opens the application I wan't the sheet USER1 (SH02) to be activated, when USER2 opens the application I wan't the sheet USER2 (SH03) to be activated.
I've added two triggers on open:
1. Select in Field: DomainUser with search string =Upper(OSUser())
2. Activate Sheet: Sheet ID =Sheet
This doesn't work. Any ideas?
Before reloading the script, change the field DomainUser to your DOMAIN and USERNAME (in UPPER CASE).
/Magnus
Its getting more and more strange. Suddenly my app didnot work neither.
Now I added a "select possible - Sheet" before activate sheet.
Try this. Currently it works in my app.
I've tried this earlier but no success. In what state do you save your app?
I save frojm the sheet dashboard.
Try an action "clear all" at first action on open document
I've tried this as well...
I am running out of ideas. Sorry!