How to trigger embedded spreadsheet functions from BO form

bondicoffee

Hi,

I have created an attribute with embs document type, and I have uploaded a spreadsheet with a template consisting of tags and formulas. I have also mapped the result from a cell to B.O attribute.

I need to fetch the result from this spreadsheet without opening the spreadsheet, meaning I need to trigger 'Read Data' and 'Save data' directly on BO form without opening this embedded spreadsheet.

Is this possible using a process or by adding a js button?

bondicoffee

Resolved by adding below code on render script of form :

($('[id ^="AW_SPREADSHEET"][id $="tb_wrapper"]').find('a.k-button:first').trigger('click'));
($('[id ^="AW_SPREADSHEET"][id $="tb_wrapper"]').find('a.k-button:eq(1)').trigger('click'));

Jaymer

Sweet! thanks for the tip

tford

Looks like this will be valuable.

Would you mind sharing your use case?