Recent content by dewebkrant

  1. dewebkrant

    Calculation using Plotalot sql shortcodes

    Thanks for the FabrikHelperHTML::runContentPlugins hint - that helps to return a value in the details view instead of the shortcode so I guess the outcome can be used in the calculations element also.
  2. dewebkrant

    Calculation using Plotalot sql shortcodes

    Ok thanks @troester but can you please explain how I can test this and where to add var_dump($dienstena);exit; ? I tried by putting this code in the calc element where I use $dienstena-$dienstenb; with the plotalot shortcodes as described but outcome is still 0 - And if "Maybe the plotalot...
  3. dewebkrant

    Calculation using Plotalot sql shortcodes

    I "solved" this by using the calc element solution proposed by Nick on http://fabrikar.com/forums/index.php?threads/simple-solution-for-sum-total-in-element.44417/#post-228180 - instead of a sql query from Plotalot, I placed the $db strings in the elements used for calculating...
  4. dewebkrant

    Calculation using Plotalot sql shortcodes

    Unfortunately, this does not seem to work out of the box although logically it should I think: $dienstena='{plotalot id="37"}'; $dienstenb='{plotalot id="36"}'; $totalBTW=$dienstena-$dienstenb; return $totalBTW; But totalBTW is showing 0 while return '{plotalot id="37"}'; shows 1328 and return...
  5. dewebkrant

    Simple solution for SUM total in element

    Yes Nick, that is working also! So now we have two solutions. Great, thanks a lot.
  6. dewebkrant

    Simple solution for SUM total in element

    Managed with the Plotalot solution (http://fabrikar.com/forums/index.php?threads/fabrik-and-plotalot-with-variables.44027/) - using sql string in Plotalot single item and placing the plotalot shortcode in calc element and disabling the Ajax option in the calc element. Ok, this opens a lot more...
  7. dewebkrant

    Simple solution for SUM total in element

    Thanks Nick for your quick reply. Trying to implement the proposed solution and have: $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select SUM($db->quoteName(array('Bedrag'))); $query->from($db->quoteName('boekingen_inkomsten')); $db->setQuery($query); $results =...
  8. dewebkrant

    Simple solution for SUM total in element

    Just seeking for a simple solution to show the sum total of column in a form element. Sum total in list is what I have but I want this value to be shown in a form field. Tried calc element with many options but nothing worked sofar. Hoped to have an option to enter a simple SQL query like...
  9. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Tried 'http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml', map: map and http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml Turned group by sidebar off. Removed the first instance of overlay URL (Germany) and yes, http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml is...
  10. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Tried with some KML files by searching on google filetype:kml (examples I tried: https://www.globalgiving.org/globalgiving.kml and www.visualtravelguide.com/Germany.kml ) But I do not really know were to look for. Just need one (or some) working examples. Filled in the Chicago example...
  11. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Thanks again for your quick reply. I will remove the firewall rule.
  12. dewebkrant

    Use of (KML) overlay in googlemap visualization

    Googled around and tried this evening to get it working but failed in showing any overlay in the overlay section of the googlemap visualisation ( https://resfarm.info/index.php/en/results-farmers-survey/map-overview-results ) - Yes the sidebar is showing but no data in the map. Tried a few...
  13. dewebkrant

    Having visualization only load data from certain elements

    Ok, tested in the live application and used your method: copying the list and de-publishing all elements which I do not need for visualization. (Great idea, I can use the elements for visualization later). Tested first with list 1, result is Gateway timeout 504 - Have visualization read from...
  14. dewebkrant

    Having visualization only load data from certain elements

    Thanks o lot for your quick replies. I managed myself in the meantime by adding a new list and selecting under "data" the same table as list 1. Effect seems to be the same as copying the list: 91 elements with unique ID are created and added to the newly created list. After this I trashed the 85...
  15. dewebkrant

    Having visualization only load data from certain elements

    Tried to work this out but did not manage sofar. Have a list (list 1) with 91 elements (questions). Till sofar, more than 700 interviews have been submitted. Want to show certain outcomes in a googlemap. Managed to do so but have server issues (504 bad gateway - timeouts etc.) because the system...
See more

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    No members online now.
    Total: 199 (members: 0, guests: 199)
    Back
    Top