Excel Add-in – Insert Hidden Fields

Business Background

Use the Titan add-in for Microsoft Excel to insert hidden fields in a spreadsheet template with access to Salesforce. You can create spreadsheets that can update Salesforce objects without logging in to Titan or Salesforce.

Titan Solution

Titan lets you add hidden fields in templates and spreadsheets with dynamic data from Salesforce directly in Microsoft Excel.

If you want to add conditional logic based on a Salesforce field or record but you don’t want the field or record visible in the document, use the hidden fields functionality.

How to Video

Video Coming Soon!

How to Guide

1. Open Microsoft Excel. The Form Titan tab is added to the right of the spreadsheet if you have installed it successfully.
2. Select the Insert Hidden button. The Manage hidden fields screen opens.

3. Select the Add field button.

4. Type a name in the Name field. This is mandatory.
5. Use the drop-down list to select an option:
   • Static
   • Dynamic
6. If you selected Static, type the value in the Value field.

8. If you selected Dynamic, use the drop-down list to select the object, for instance, Account. This is mandatory.
9. Type a comment in the Comment field. This is mandatory.
10. Use the drop-down list to select the field, for instance, Account Number. This is mandatory.

11. Select the Save button.

Interested in the Titan/ Salesforce Integration? Read more about our Dynamic Forms.