1. Fabrik 3.8.1 has been released. It is mostly bug fixes and feature enhancements, but does include two new plugins (push notifications, and the sequence element). As usual we strongly recommend testing the new release on a sandbox if your application is mission critical, and always do an Akeeba backup before updating.

Retrieve values from db using JS

Discussion in 'Community' started by andre00silva, Jun 8, 2018.

  1. andre00silva

    andre00silva Member

    Level: Community
    Hello!
    I'm my list "Pedidos de Orçamento" I have a php button which, when clicked, inserts into my "Orçamentos" list the respective row values (which are quotation requests and in the moment the button is pressed, they become quotations too). This button also creates a new dir and a new excel file inside of it in a specific path (moldes/Molde_{table_name___id}/Orcamento161.xlsm). Every quotation request excel file path is stored in my list "Settings" which has some elements: "file_name", "file_path" and an inner join with the "Pedidos de Orçamento" ... etc.
    In the list "Orçamentos" I have another php button with an excel logo that allows, when clicked, to open the excel file using JS:

    Code (Text):
    jQuery.each(rows, function(rowid, row) {
      window.open('../'+row.fzmms_settings___file_path+'/'+row.fzmms_settings___file_name);
    })


    The problem is, I can't seem to retrieve the values of that list. Using this I can only retrieve the values of the list "Orçamentos"... When I do this that you're seeing, the path becomes "unavailable/unavailable". How can I retrieve those values from the db and use them in the link?
     
  2. andre00silva

    andre00silva Member

    Level: Community
    friendly bump :)
     

Share This Page