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
Is accessible!Maybe an element used in your calculation is not accessible?
Yes, all is accessible for public (view list, record and id element too).table1 is accessible for public? view list, view record, id element itself?
BTW:"& JFactory" is deprecated
But.... How it works?You can install the jDump extension to debug what '{Table1___id}' is returning for admin and for public.
Install +enable
https://extensions.joomla.org/extension/j-dump/
Perhaps this is a slight confusion.
As I understand it you want the actual calc value only to be visible to administrators - and you are suggesting that for non-administrators you display zero.
So it seems to me that you have two choices:
1. Make the calc element visible in the list (and forms) only to administrators using Access Levels. If you still want to display zero to other users, maybe have another calc element containing zero which is only shown to non-administrators; or
2. Add code to the calc php to check the user's admin rights and return zero if they are not administrators, and run the SQL only if they are administrators.
If it were me, I would do 1. and simply not show the calc element unless they are administrators.
I am definitely confused now. AFAIK there is no reason why non-administrators would get a different result from the calc - the php code runs on the server in the same security context regardless of the Joomla View Access Levels. I could understand that non-administrators might not see the calc element at all if you had set Access / List View to something other than Public, but I cannot understand how they would see a different value.
What is the value of "Only Calc on Save"?
For this type of SQL query "Only Calc on Save" will need to be set to No to run the SQL every time you display the List - and you will need to be careful about performance because it will run that SQL individually for every row in the List that is displayed which could take some time.
(I have previously written about how to resolve these performance issues by setting Only Calc on Save = Yes and using a List PHP Event plugin and running a single Update SQL statement to update the entire table before you display the list instead of running one SQL per row.)
What are the exact "Access" settings of your table1___id element?