Download page Using the X-Author Designer Ribbon.
Using the X-Author Designer Ribbon
All of the controls you need to use X-Author Designer are located in the X-Author Designer ribbon menu in Microsoft Excel.
Before you start designing apps, you should familiarize yourself with the X-Author for Excel components that are accessed through the X-Author Designer ribbon menu. Click the link in the first column to learn more about the component.
|Apps||Click this button to create a new app, change the app type, or open an existing app. (Click the Quick App button to instead create a simple single-object app or a parent-child-type app.)|
|Data Migration||Click this button to create a new app using the Data Migration Wizard, or edit an existing Data Migration app.|
Click this button to specify the objects and fields you will use in the app. (This section only covers single object and parent-child objects.)
For Salesforce, the button is.
For Microsoft Dynamics and Omni, the button is.
|Display Map||Click this button to define the associations between Excel spreadsheet cells and fields for the environment data to be retrieved. When data is retrieved, using one of the X-Author data invoking actions, it is temporarily stored in Excel memory before being placed into the worksheet. X-Author then uses a Display Map to place the data in the correct Excel cells.|
|Matrix Map||Click this button to define a matrix map. Matrix maps extend the capabilities of X-Author for Excel well beyond list formats. In lists, one record is represented per Excel row or column. Using matrices, a record can be represented by one or more cells by mapping columns and rows (the X and Y axes) of a matrix as well as the data contained in the cell at the intersection of the mapped column and row. Depending on the type of matrix, various data cells can be updated by a user. If no value exists in a cell, adding a value can create a new record depending on the matrix design.|
Click this button to define relationships between fields and Excel cells for data that will be saved to your environment.
|Actions||Click this button to assign actions to your app. Actions can be used to retrieve, display, and save data. They can also automate tasks in Excel worksheets and call environment methods.|
|Action Flow||Click this button to define a sequence of one or more actions that will be executed when end users click buttons on the app's ribbon menu.|
|User Menus||Click this button to create the ribbon menus that your end users will see in the X-Author for Excel ribbon in Excel.|
|Save App||Click this button to save or clone your application.|
|App Settings||Click this button to restrict runtime functions (such as saving, printing, rich-text editing) and password-protect worksheets.|
|Sync App||Click this button to identify mismatches and missing objects or fields after any import or data migration is complete.|
|Source Data||Click this button to easily migrate data from one instance to another using X-Author for Excel.|
|External Library||As an application designer, you can choose to create additional custom actions apart from the ones provided in the X-Author for Excel executable packages. For example, you can create a custom action to populate missing External IDs for the Custom Objects in your instance.|
Click this button to import a previously exported app from a different instance.
Note: All objects used in the source instance must also exist in the destination instance.
|Export||Click this button to export an app from one instance for the purpose of importing it to another.|
|Preview||Click this button to preview your app in Runtime mode.|
|Connect||Click this button to connect to your instance.|
|Switch Connection||Click this button to switch your connection to another instance, add additional connections, or revoke a previously configured connection.|
|Support||Click this button for general settings or changing the source environment. General settings include changing the language and proxy settings.|