We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Yes, that's what I mean, the standard calculation of the amount counts data from the database that relate to this column, and I would like to count the data that comes in the $data array, because they are different from those in the database, there is an element of calc with a sample of data from the database, how would I count the data from the array, I read the description, but how to make a query I did not understand, please tell me?Do you mean the calculations in element's [List view settings]?
http://fabrikar.com/forums/index.php?wiki/elements/#custom-calculation
Did you set the "Custom Access" you need?
In general you'll find hints in the tooltips (hover labels).
That's just what I would like for the "user calculation" to work as a calc element, but I did not understand how to achieve this, thank you very much for telling me, I will continue to understand.In "Custom calc" you can only calculate (MySQL functions) on the element (=column, addressed via %s) values in the database.
In each of the element calcs you can "Split on" some element (which will do a GROUP BY)
I can't see what "Split php" in "Custom calc" is doing (or if it's doing anything at all), "Split on" is working as in the other calc types.
- Custom query - Query fragment to generate result using %s to represent the field name for this element (do NOT use the actual field name, you must use %s). So to generate the population standard deviation for this element, this would be
STDDEV_POP(%s)
Something like this should do (doing it "manually", without %s)
((select sum(tt.your-column) from `your-table` tt where tt.your-column = "A")-(select sum(tt.your-column) from `your-table` tt where tt.your-column = "B"))
I don't know if this helps in your case, but you can filter a list in the content plugin.
http://fabrikar.com/forums/index.php?wiki/content-plugin/#filtering-lists
So {fabrik view=list .... your-table___custom_id=[rowid]}