You can fire a "crt.OpenSidebarRequest" request and provide the code of the sidebar to indicate which sidebar to open. 

handlerChain.process({
    type: 'crt.OpenSidebarRequest',
    sidebarCode: SOME_SIDEBAR_CODE,
    $context: {}
});

You can see this request plus others related to the sidebar here: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/platform-customization/freedom-ui/sidebar/overview 

Ryan

Ryan Farley,

Hi Ryan, Thanks a lot. Now I can open the sidebar page when I get a call from the component. But one more question remains: how can I make the sibebar page opened after reloading page and after login in system? I didn`t find the answer in Creatio academy

To do something like that you might need to either override the MainShell or MainHeaderSchema so that on initialize you send the request to open it (might need to use a setTimeout to delay and make sure the UI is all loaded)

To override the MailShell you'll need to enable the feature that allows you to override angular schemas - see this thread: https://community.creatio.com/questions/how-create-replacing-schema-freedom-ui-basepagetemplate

Ryan

I have something like that working (except I am using a hosted Google Spreadsheet) that is using make.com. I just execute a Make.com webhook from a process in Creatio, make.com receives that and then writes the line to the existing spreadsheet. All no code, so just thought I would mention. 

Ryan

Hi,

Yes, it is possible to write a row to the bottom of an existing spreadsheet from Creatio.

There's an official Google Sheets connector for Creatio available on the Creatio Marketplace: https://marketplace.creatio.com/app/google-sheets-connector-creatio

It enables two-way sync with Google Sheets and lets you:

-Automatically send data from Creatio to Google Sheets;

-Map sheet columns to Creatio fields;

-Use Google Sheets as a staging point between systems.

This connector is fully no-code and works with current versions of Google Sheets - all you need is a Google Cloud account.

Have a nice day!

Thanks.  However, we are not using Google Sheets, our corporate standard is Excel / MS Office.  Creatio would need to integrate with an existing spreadsheet used by our Operations department -- Is there a connector for that too?

This is a bug in Creatio. Contact support and they can apply a fix to your system. If needed, you can have them refer to the case I opened on this #SR-01400125. 

Essentially, there's a bug that incorrectly checks the dates for trigger emails (since trigger emails don't need a start date as they're started from the campaign)

Ryan 

...

Hello,

Thank you for reaching out. Ryan is absolutely correct.

This issue has been identified and a fix will be available in the upcoming Creatio 8.3.1 release. Once that version is available, you can update your site to resolve the error.

Alternatively, if you'd prefer not to wait, you can request that the fix be applied to your current version by contacting our support team directly.