Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • 🎯  Solution Guides

  • Low Code Solutions

    Add "Tabs" to your app

    ID Target Link

    Use an address field to display a static street view thumbnail

    Turn your menu into a fixed menu

    Auto close mobile menu

    Display record information in a card

    How to add a back button to your app

    Add a collapsible accordion element to your app

    Code Snippets

    PHP Curl Create New Record

    PHP Get Records With Filters

    Google Scripts - Get record and create new records from connected table

    Save Tables and Fields into Spreadsheet

    Google Scripts - Export all records

    Webhook to save deleted records

    Send Messages to Slack

    Restrict Space and Force Uppercase in a Form

    Building Advanced Features

    Use Validation Rules to Ensure Unique Votes Per User

    Use Record Rules to Create an Audit Log

    Track current inventory with transactions

    Schedule Bookings and Prevent Double Bookings

    Create orders with multiple items and varying quantities

    2 Step Forms

    Unique Record Validation

    Restrict Editing Records to Record Owners

    Sum date/time field

    Duplicate Records

    Advanced App Customization

    How to embed a Tadabase page on another website

    Adding external fonts

    Custom Favicon

    Making apps mobile friendly

    Show date/time as a countdown

    Importing many images at once

    Adding QR Codes

    Adding charts to PDFs

    Customizing your app shortcut for mobile phones

    Animate parts of a page

    Design Customization

    Changing background colors

    Set background colors to the edge of a page

    Change the background of a column

    Add padding around a component

    Using an image as background for a page

    Adding a background image to a row, column, or component

  • Duplicate Connected Records

Categories
🎯 Solution Guides
Building Advanced Feat...
Restrict Editing Recor...

Restrict Editing Records to Record Owners

In this article we'll look at how to restrict a page to only be editable by the owner of the record. 

 

Objective: 

We have a Projects table that is seen by many of our logged in users. We want to enable only the user who created the record to be able to edit this record. 

This scenario assumes that multiple users can see the same records. If the only records shown are the records that belong to the logged in user, this approach is not necessary. 

 

Structure

We have a customers table with several fields, one of which is a connection to the users table and have added an edit link which opens a new page where we can edit the record. 

As you can see the Created By field is the connection field to the logged in user. Each time a record is added, we set this to the value of the logged in using record rules. 

 

 

Since this table is visible to many users we want to ensure that when someone clicks on the Edit link and it opens the Edit page, it should only be editable by the user who created this. 

 

Implementation

To achieve this goal, we'll ensure the Edit page is secure then simply set the second parameter to the logged in user. 

  1. Open the edit page
  2. Click on Settings
  3. Secure the page to only logged in users or users of a particular role
  4. restrict page based on logged in user field. 

 

2021-02-01_17-41-22.png

If you set the edit link in the table to open in a modal window, this feature will not work. 

 

How did we do ?

Previous Article
Unique Record Validation
Next Article
Sum date/time field
Article Navigation
  • Objective:
  • Structure
  • Implementation
  • Back to top
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational