#Developers0 discussing

The this.omniNavigateTo() function triggers a page navigation event. When used inside an LWC embedded within an OmniScript, it often bubbles up and causes the entire OmniScript container to refresh or re-initialize, looking like a "reload."

Solution:

Instead of this.omniNavigateTo(), use the

1. If moving to the Next Step:

javascript
this.dispatchEvent(new CustomEvent('omninesxtstep'));

If updating data:

javascript
this.omniApplyCallResp({ "yourData": "value" });

Why it happens: omniNavigateTo is designed for PageReference navigation (like moving from Salesforce Page A to Salesforce Page B). When you call it, the framework assumes you are leaving the current context, so it reloads the component wrapper. Avoid using it for simple step transitions inside the same OmniScript. 

1. https://trailblazers.salesforce.com/profileView?u=0053A00000FTqkWQAT

I have been doing this successfully for a while now. I use Tableau Prep 2020.1 to extract data from files in SharePoint. it allows us to collect data from people across the whole organisation, just by running tableau prep files.

1. Open the Excel file in the Desktop app.
2. Click on FILE | INFO | CopyPath
3. Go to Tableau Prep
4. Add a new connection of type Excel.
5. Paste the path into the 'FileName' space in the dialog box.
6. Delete the stuff in the path after the .xlsx i.e. usually this is '?web=1' that gets deleted.
7. Click OK/open
8. Select the Excel tab and drag it into the prep working are.

NOTE - sometimes you can't connect. - just because windows insists you use Internet Explorer or EDGE-(with this Edge workaround added - https://docs.microsoft.com/en-us/sharepoint/sharepoint-view-in-edge. It appears to provide the solution via Policy changes to turn on the ‘view in file explorer’ facility.

It says...   “Enable the ConfigureViewInFileExplorer policy for Microsoft Edge that allows URLs with the viewinfileexplorer: scheme to open WebDAV URLs in Windows File Explorer.)

AND FINALLY...

And you might need to prep the whole connection regime with this. - which describes configuring Trusted Sites as well as doing the mapping.

https://support.microsoft.com/en-us/office/map-a-network-drive-to-a-sharepoint-library-751148de-f579-42f9-bc8c-fcd80ccf0f53 - .

Hope it helps - it took me a while, but it definitely works, and the Edge trick SHOULD (unproven) mean it can continue after IE gets retired.

Erika,

I'm not exactly sure what you're looking for here, but if you take your Change... pill off the level of detail, and then convert it to a dimension, then change it to 'continuous' (green), then put it back on the level of detail shelf and recreate the reference line using a simple sum, then you'll get the totals I think you're looking for. (Miss any of these steps, and the Change... field won't be available in the reference line box.) See attached.

Hope this gets you going in the right direction.

--Shawn

@Saurabh Kashyap, I suppose you could ease the overall architecture to only query once, and to get quantity (not available will be understandable when quantity = 0). Indeed you have to queue the calls (queuable apex). You should handle the error code in each call as you normally do testing the getStatusCode from the http send request's response.

PS : A detail, I suppose you could be able to trigger on product required (instead of product consumed) but that does not change the logic of the integration :)

Eric

Hi @Saurabh Kashyap

Check the example below which worked for me. 

I wanted to create button under Opportunity related list. 

Hi @Michael Brown, thanks for the answer, the only HTML part I have access to is on the "Form" tab of the layout. It goes like this:

<form accept-charset="UTF-8" method="post" action="%%form-action-url%%" class="form" id="pardot-form">

%%form-opening-general-content%%

%%form-if-thank-you%%

%%form-javascript-focus%%

%%form-thank-you-content%%

%%form-thank-you-code%%

%%form-end-if-thank-you%%

%%form-if-display-form%%

%%form-before-form-content%%

%%form-if-error%%

<p class="errors">Please correct the errors below:</p>

%%form-end-if-error%%

%%form-start-loop-fields%%

<div class="form-field %%form-field-css-classes%% %%form-field-class-type%% %%form-field-class-required%% %%form-field-class-hidden%% %%form-field-class-no-label%% %%form-field-class-error%% %%form-field-dependency-css%%">

%%form-if-field-label%%

<label class="field-label" for="%%form-field-id%%">%%form-field-label%%</label>

%%form-end-if-field-label%%

%%form-field-input%%

%%form-if-field-description%%

<span class="description">%%form-field-description%%</span>

%%form-end-if-field-description%%

<div id="error_for_%%form-field-id%%" style="display:none"></div>

%%form-field-if-error%%

<p class="error no-label">%%form-field-error-message%%</p>

%%form-field-end-if-error%%

    </div>

%%form-end-loop-fields%%

%%form-spam-trap-field%%

<!-- forces IE5-8 to correctly submit UTF8 content  -->

<input name="_utf8" type="hidden" value="☃" />

<div class="submit">

<input type="submit" accesskey="s" value="%%form-submit-button-text%%" %%form-submit-disabled%%/>

</div>

%%form-after-form-content%%

%%form-end-if-display-form%%

%%form-javascript-link-target-top%%

</form>

Unfortunately, the code you gave me does not match the info I get when I inspect my form (screen attached) - especially the name and ID that change depending on the form. Any idea how to solves this?