How to filter Joomla categories and capture Full text in the Form

Discussion in 'Professional Support' started by sunnyjey, Sep 8, 2017.

  1. sunnyjey

    sunnyjey Member

    Level: Community
    This is my first question and the reason to join Fabrik.

    I have Fabrik form where I would like auto-populate the Full text of the Joomla article in TEXT area field. Is this possible ?

    We have Wiki like information available in Multiple Joomla Articles under Main and its Subcategories. When Fabrik form loads, it should provide Cascading options to filter Categories and Subcategories and choose Title of Article. After selection of Title, the Text area should auto populate the Full Text of the selected Article.

    I have been trying to achieve this since last week. Had gone through multiple thread in forum. Tried Cascading and Join database fields. But due to limited knowledge of PHP and Javascript, I couldn't achieve.

    Would really appreciate if someone walks through with me and guide me. Thank you in advance.
     
  2. sunnyjey

    sunnyjey Member

    Level: Community
    Friendly bump.

    I'm sorry, I know hugh is on vacation after long time and finding difficult to access forum. But, I have been desperately waiting for the reply as my whole Project depends on this. I have been checking this forum almost every 2 hours for any answers.

    Need some guidelines so that I can initiate my project.
     
  3. troester

    troester Well-Known Member Staff Member

    Level: Standard
    .the textarea should auto populate...'
    Do you only want to display the full text or do you want to edit and save (overriding the Joomla article or saving in some other DB table)?

    Gesendet von meinem GT-I9300 mit Tapatalk
     
  4. sunnyjey

    sunnyjey Member

    Level: Community
    Thank you for replying.

    Yes, I want to display the full text, edit and save it in DB table of the current Fabrik form. I don't want to alter primary Joomla Article after saving form.
     
  5. cheesegrits

    cheesegrits Support Gopher Staff Member

    Level: Professional
    Sorry, I got caught up in Hurricane Irma, when I went to retrieve my dogs from where they'd been staying while I was in the UK. Got stuck on the road for a couple of days. Had my laptop, but limited Internet and sketchy power.

    Do you need the text to populate 'live' on the page as the user makes the selection, or is it good enough to populate it on the server side during form submission?

    Do you have your category joins working? The problem there is that Joomla's content table uses the "nested set" structure, which doesn't lend itself to our join / cascading dropdown approach.

    -- hugh
     
  6. sunnyjey

    sunnyjey Member

    Level: Community
    Oh! I hope everything is fine at your end.

    Yes, I want to populate the text (article content) live in the text area (html) field of Fabrik as the user makes the selection, so that they edit/alter the populated text and store their version of article in the Fabrik DB.

    No, I haven't tried whether Joomla category joins.

    What would be the best way to populate basic preformatted HTML Text from database into TEXT field of Fabrik, so that they can edit and store within same form DB after SAVE.

    If Joomla content tables do not provide 'nested set', then I can create one more Fabrik form to store the HTML information content under Categories / Subcategories filter of Fabrik DB.
     

Share This Page