Question regarding Docmerge date and document URL integration

Good afternoon,

We currently want to use docmerge for creating an orderform. We used to use the PDF manager in the quotes module, this works well, but as we are reorganizing our processes we would like to use docmerge instead of the PDF manager for this. I created a docmerge Quote template using the currently existing docmerge template from Sugar: 

https://support.sugarcrm.com/files/2824d1aa-8294-11ec-82e7-02ebdbabe2e2.docx

A lot of the fields we want to use are in there, but not all. I am currently trying to implement date fields from the quote module but they don't seem to come through in DocMerge. I can put in the current date. That is no problem, but I also want to put in a date field which can be manually changed on the quotes module by the user. One field for start date and one field for end date. 

Secondly, we would like to integrate the URL linked  to the documents that belong to the opportunity after an opportunity is converted to a quote using docmerge for our finance department.

I haven't found the option to link a URL to a document in Sugar under a different module. For this I also tried to use  the related button on Sugar Logic and the dynamic elements, but I did not  find this specific function. Is there a specific code that I can use to get the URL from the attached documents to an Opportunity?

Lastly, the numbers in docmerge are shown as a price, with commas and dots. We just want the data to be clear, so without commas and dots. (Example below). In the PDF manager we see only numbers without any additions. 

Thank you in advance for your answer.


Best regards,

Maike 

Parents
  • Hi Maike, 

    I was able to use Doc Merge to populate a manually-edited date field. This is what I did: 

    1. Go to Admin > Studio > Quotes
    2. Add a new Date field and name it appropriately (I named mine "Manual Date Field")
    3. Go to Layout and add the new field to the layout and deploy changes
    4. Set the field on a quote record 
    5. Open the Doc Merge Template Assistant and choose the Quotes module, then search for desired field (e.g., Manual Date Field)
    6. Click the gear icon next to the field, configure the format as you wish, and then click "Copy to Clipboard"
    7. Paste that field into your doc merge template. Mine was pasted as "{manual_date_field_c}". 

    I'm not entirely sure if this is what you're asking about for the URL portion. I included a link to the opportunity on my doc merge result like so:

    1. Go to Admin > Studio > Quotes
    2. Add a new URL field 
    3. Click the Generate URL checkbox
    4. Set the Default Value to <your instance URL>.com/#Opportunities/ and then select "opportunity_id" from the dropdown above and click "Insert Field" so that it gets added to the end.
    5. Save this field. You do not need to put it on a layout, unless you want to check it. This field will get populated when there is an opp selected in the Opportunity Name field on the Quote record. 
    6. Again, go back to the Doc Merge Template Assistant and select the Quotes module and the new field you created. You can then paste this new field into your document template.
      Note: You can choose to format the link to have different text (e.g., "Click Here!"). But as I've said in this other Club post, there's an issue with it currently. However, there is a workaround available. If you are interested in seeing this fixed, please contact Support and ask to be added to issue 92701 to give us a better idea of who is waiting for it. 

    It looks like Doc Merge is taking the 1000s separator and decimal symbol from whatever is set in Admin > Locale: 

    I'm asking around to see if anyone knows of a way around this and will post back if I hear anything. If you'd like to file a case with Support to suggest this as a future area of improvement, you are welcome to do so!

    Let me know if any of this isn't quite what you were asking and I'll try to help!

    Lydia Manger

    Product Manager — Sugar Discover

  • Good afternoon Lydia,

    Thank you very much for your reply! I used your solutions yesterday in our instance and it works! This helped us tremendously :) 

    I am now only looking into using the quote template in Word. We are mostly working with chromebooks and Google Docs. I created the Quote in Google Docs and then converted it to a Word document. Then uploaded it in Sugar. For me this works perfectly.

    However, my coworker uses a Macbook and when he opens the exact same Docmerge template in Word, he does not see the records being filled in the table in the document. 

    I am going to try to create this exact same template in Word on a Macbook. I hope this resolves our issue. 

    Thank you again for your answer and help!

    Best regards,


    Maike Mak 

Reply
  • Good afternoon Lydia,

    Thank you very much for your reply! I used your solutions yesterday in our instance and it works! This helped us tremendously :) 

    I am now only looking into using the quote template in Word. We are mostly working with chromebooks and Google Docs. I created the Quote in Google Docs and then converted it to a Word document. Then uploaded it in Sugar. For me this works perfectly.

    However, my coworker uses a Macbook and when he opens the exact same Docmerge template in Word, he does not see the records being filled in the table in the document. 

    I am going to try to create this exact same template in Word on a Macbook. I hope this resolves our issue. 

    Thank you again for your answer and help!

    Best regards,


    Maike Mak 

Children