This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<apex:page> | |
<apex:form> | |
<!-- Please replace the following bookId/sheetId attribute values to the values of from book/sheet setting dialog --> | |
<apex:pageBlock title="Accounts"> | |
<msmxSheet:SheetView id="comp-01" | |
bookId="a002800001O6vOpAAJ" | |
sheetId="s1" | |
width="100%" | |
height="300px" | |
/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<apex:page | |
standardController="Account" | |
showHeader="false" | |
> | |
<script> | |
var bookId = "a002800000iNFMLAA4"; | |
var sheetId = "s1"; | |
var url = | |
"{!URLFOR($Page.msmxSheet__MsmxSheetView)}" + | |
"?bookId=" + bookId + "&sheetId=" + sheetId; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public with sharing class CustomActionController { | |
public Account[] accounts { get; set; } | |
public CustomActionController() { | |
// 「URLを開く」アクションボタンの詳細設定で指定したパラメータに選択したレコードの値が渡される | |
String idParam = ApexPages.currentPage().getParameters().get('id'); | |
if (idParam != null) { | |
// 「URLを開く」アクションボタンの詳細設定で"配列値のシリアライズ方法に「コンマ区切り」を選んでいる場合 | |
String[] ids = idParam.split(','); | |
accounts = [SELECT Id, Name FROM Account WHERE Id IN :ids]; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- standardControllerには実際に埋め込むオブジェクトのAPI参照名(例:商談 => Opportunity)を入力する --> | |
<apex:page standardController="Opportunity"> | |
<apex:form > | |
<!-- bookId/sheetIdに指定するブックID/シートIDはブックおよびシートの設定画面から取得したものに置き換える --> | |
<apex:pageBlock title="見積"> | |
<msmxSheet:SheetView id="comp-01" | |
bookId="a000I00001eaVtQQAU" | |
sheetId="s1" | |
recordId="{!Id}" | |
width="100%" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<apex:page> | |
<apex:form> | |
<!-- bookId/sheetIdに指定するブックID/シートIDはブックおよびシートの設定画面から取得したものに置き換える --> | |
<apex:pageBlock title="取引先"> | |
<msmxSheet:SheetView id="comp-01" | |
bookId="a002800001O6vOpAAJ" | |
sheetId="s1" | |
width="100%" | |
height="300px" | |
/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<apex:page standardController="CustomObject__c" showHeader="false"> | |
<script> | |
var bookId = 'a01280000179IMaAAM'; | |
var sheetId = 's1'; | |
var recordId = '{!JSENCODE(id)}'; | |
location.href = '/apex/msmxSheet__MsmxSheetView?id=' + recordId + '&bookId=' + bookId + '&sheetId=' + sheetId; | |
</script> | |
</apex:page> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<apex:page sidebar="false"> | |
<msmxSheet:SheetView | |
width="100%" height="600px" | |
bookId="a0I1000000MjZFXEA3" | |
sheetId="s1" | |
/> | |
</apex:page> |