Sheet Triggers??

[#1]

Hi ,

I have a requirement.

PFA attached QVW which explains the requirement.

Thanks

[sorrakis01]

HI,

Check please,

Regards

[#3]

Thanks for reply.

Is it possible to activate sheets and redirecting to respective Sheet by selecting the ID, as we dont provide users to select Party. Also we have many ID. Attached QVW was just a mock up.

[Kushal_Chawda]

You can use the field event trigger (Activate Sheet) on field Party

See the atached

[sorrakis01]

Yes,

You can create triggers of all List Tables.

Regards

[#6]

Hi,

Suppose on Sheet1 , if user select ID 5 is it possible to redirect user to Sheet2?

Likewise on Sheet2 , if user select ID 1 is it possible to redirect user to Sheet21?

[sorrakis01]

Hi,

You need to do the same that party but on ID, but you need to get the name of the activated sheet (you can use:

SubField(GetActiveSheetId(),'\',2) to get it).

Check on the example.

Regards,

[sorrakis01 · Accepted solution]

Hi Robert,

You could resolve the problem?

Regards