Is there a possibility to drop sheets dynamically based on user?

[Anonymous]

Hi Team,

As our application has several sheets and plenty of objects in them, it has become very heavy. Not all sheets are required for all users. Therefore is there a possibility to drop sheets based on user LogIn? I am not talking about hiding sheets here.

Can we only have the sheets required by the user when he logs in? Please let me know.. This is urgent..

[sarvesh]

Hi..

You can delete this sheet from App.

Regard's

Sarvesh Srivastava

[vardhancse]

Section access for sheet level can be done.

If hiding was not the requirement, then you can create separate dashboards for the user types.

In general will follow section access to hide and show the sheet.

If you are more concerned about space try to split the dashboards based on some field using document chaining.

[sasikanth]

Hi,

If you have Publisher in setup then go for " Loop and Reduce" option.

it will divide the Large application into several small apps based on the given FIELD.

[Anonymous]

Apply section access on sheet level like below

=if(Match(OSUser,'dev','lakky'),1,0)

Regards,

Devendar