Skip to main content
M
Melynda29844467f7qi
Participant
November 29, 2023
Question

Dynamic Pricelist Updatable from Excel Sheet

  • November 29, 2023
  • 1 reply
  • 564 views

Ok y'all. I have scoured the questions and answers here but can't find what I'm looking for.

 

My company would like to put a pdf price sheet on our website that folks can bring up and print if they feel the need, but we need it to be dynamic. Our prices fluctuate with the market a lot and it is so time consuming to update a pdf and reload it to the site every single day. My questions are:

 

1. Is there a way to take a dynamic PDF (or some other file if you have suggestions) and load it to our website, viewable as a page, and link it to our excel sheet that houses our pricelist as it is updated daily? 

2. Would it be best to make this with InDesign or somewhere else?

 

Thanks!

    This topic has been closed for replies.

    1 reply

    Thom Parker
    Community Expert
    Thom ParkerCommunity Expert
    Community Expert
    November 29, 2023

    There are a few ways to do this. First, an FDF file is a native PDF data format that can contain a document URL, so a link to the FDF will automatically load the associated PDF and merge the data.  This method can have it's issues.

    A better method is to link to a web app that merges the data into a PDF and returns a static PDF.  This can be done with Cold Fusion, comercial apps built specifically for this purpose such as ActivePDF and Logitech, the very expensive AEM servers, or you could build the app yourself using a PDF library.

     

     

    Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices