Trigger and GetActiveSheetId()

alexantone — Tue, 24 Mar 2015 17:37:15 GMT

Hello

Can i use this script in a trigger (active sheet)?

My script :

=if(GetPossibleCount(MYField)=1,GetActiveSheetId()='SH06')

Tank you

Re: Trigger and GetActiveSheetId()

maxgro — Tue, 24 Mar 2015 19:19:15 GMT

it depends on what you want to do

GetActiveSheetId returns the ID of the active sheet, something like

and I think

GetActiveSheetId()='SH06'

is always false

if you want to chech SH06

=subfield(GetActiveSheetId(), '\',2)='SH06'