• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

Users editing own records

  • Views Views: 16,866
  • Last updated Last updated:


         Form Article Plugin Tutorial
      Autofill form plugin
      Clone form plugin
      Comment form plugin
      Email form plugin
      EXIF form plugin
      FTP form plugin
      J2store form plugin
      Kunena form plugin
      Limit form plugin
      Logs form plugin
      Mailchimp form plugin
      Paginate form plugin
      Paypal form plugin
      PHP form plugin
      Pingdotfm form plugin
      Receipt form plugin
      Redirect form plugin
      REST form plugin
      Slack form plugin (+)
      SMS form plugin
      Twitter form plugin
      Upsert form plugin
      VBforum form plugin
      Create a Search Form
      Accordion Form Groups
  • There are two main scenarios in which you may want to restrict access to a users own records - in Forms and in Lists.


    For Forms, there is a video on this concept available for subscribers at https://fabrikar.com/help/tutorials called 'Access Control'.

    The basic premise behind the concept is that in the menu item that links to the form you are adding the specification to only display the row in the table that has the user's id is the 'userid' column.

    You are therefore required to specify in menu link > Options:

    Row id: -1​
    Key: userid​
    To implement this, there is the additional step required of creating a 'user' element and adding it to your form so that the user's id is in fact automatically grabbed and added to the data that is submitted with the form.

    The video tutorial mentioned above makes this concept and its implementation clearer as it demonstrates its usage in a 'user profile' scenario.


    For Lists, access control, in the context of limiting the display of records to those who created them, is achieved by adding prefilters.

    This can be done in the backend by going to Lists > [click on your list title] > Data > Pre-filter or in the frontend by setting the prefilter in the fabrik list menu Options.

    There you can define the filters that are applied to your list before it is displayed.

    So for example, to restrict the contents of the list so that it only displays records added by the user, you would add the following pre-filters:

    WHERE name(raw) EQUALS {$my->id}, Type: Text, Apply To: Registered​
    WHERE id NOT EQUAL TO 0, Type: Text, Apply To: Special​

    This last condition enables Super Users to be able to administer and view all records.

    URL links to a form​

    Alternatively, you can create a URL link to the form:

    Limit Form plugin​

    It is recommended to additionally use the limit form plugin (currently available only in github) to ensure that users can not bypass these Options by manually altering the URL.