I am displaying related opportunity line items data in a table using TableRow for an opportunity. Number of rows depend on number of opportunity line item records for an opportunity. I want to calculate grand total of TotalPrice column for all the opportunity line items which are displayed dynamically. As i don’t know how many rows i will get in the table, how do i proceed with the formula field? In formula field set up, i don’t see such option anywhere. Any help is much appreciated!
Hi
Are you using the “eSignature for Salesforce” product? Or are you using “Gen for Salesforce”? I assume you’re using the eSignature merge fields based on your description, but please correct me if I’m wrong.
Unfortunately, the eSignature for Salesforce merge fields do require you to set up a template in advance, and to specify the TableRow number if the merge field is linked to a related list object field. There’s no way to place one row and expect it to generate additional rows dynamically based on how many rows in your table there need to be. However, this is something our Gen for Salesforce can absolutely do.
Gen for Salesforce is designed to dynamically generate documents, including custom tables with related list data, and can be quite flexible when trying to produce a table of data, including calculating a grand total.
Many customers utilize Gen to produce this kind of dynamic table on a document, then use eSignature to send that document out for additional data collection and/or signature.
Hope this helps!
Hi
Hi
<#<Content Select=”sum(//Opportunity//OpportunityLineItems/Total_Cost__c)” /> #>
P.S. whatever your total cost field is, make sure you also select that field in the “Fields” step within your Gen template.
Hello
If you found the provided response to be a useful solution to your question, please mark it as the best answer by clicking “Select as Best” to make it easier for other users to find.
Best regards,
Nathaly | Docusign Community Moderator
"Select as Best" below if you find the answer a valid solution to your issue!
Reply
Sign up
Already have an account? Login
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationDocusign Community
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.