Conga Grid currently supports copy-and-paste operations from Google Docs®, Microsoft Excel® (desktop only), and Apple Numbers®.
There are two ways to paste records into Conga Grid℠:
Paste to Batch Insert
his is the default operation. Conga Grid adds new rows with the records that you paste into the grid. This ensures that you do not override existing data.
Paste to Batch Update
When you paste data into Conga Grid, it updates and overrides existing records. You receive a warning message confirming that you want to do this.
You can set the default option using Feature Security:
- Click Conga Grid Setup.
- Click Global Defaults in the object list.
- Click the Feature Security tab.
- Scroll down to the Paste to Batch Insert and Paste to Batch Update features.
- Choose to Enable, Disable, or Inherit (from the user's Salesforce permissions) each option.
How to Copy and Paste
- Select the first editable field in that row.
- Copy the data you want to insert.
- Right-click paste or use the CTRL + V function to paste the copied data into the Grid.
- Click Save to save the new or updated records.
Ensure the column headers in the content you are pasting match exactly with the column headers in your Grid.
Tips for Copy and Paste
If data does not paste correctly into Conga Grid, formatting issues might be to blame. For example, Excel tries to automatically detect data types and apply formatting. Dates might convert to preferred cultural settings, or numeric totals might have currency symbol prefixes.
If data does not paste as expected, we recommend changing the formatting in Excel, Google Docs, or Apple Numbers to match the displayed data in Conga Grid. Cultural settings on your system might not match those of your browser or the Salesforce user. When data is pasted into the grid an extra row is created that allows you to paste additional data or create new records.