Conditional add, edit & delete

Set conditions on who and what can be added, edited or deleted

Allowing users to add, edit & delete records can be very powerful, but sometimes you want to restrict this to only certain items or to certain users. With conditional add, edit & delete you can do this.

Example 1: Make only certain items editable

If you only want certain items to be editable, you can setup a condition that achieves this. For example, in the GIF below we make only one of our items editable - by adding a condition of Name = Coconut & Almond. This results in only that item being editable.

This is a simple example and will cause only one item to be editable. However, you could choose another column where a number of your items share the same value and this would result in multiple items becoming editable.

Example 2: Let users edit only their items

You might also want only give edit access to items that 'belong' to the signed in user.

In the GIF below we enable editing on our list items. After that we add a condition where the item is only editable if the signed in user's email matches the email column in our table.

This means that Marie Rao (who we are signed in as) is able to edit her record, but not any of the others.

You can use User Profiles and Roles in your conditions, allowing you to give editing rights to multiple users on the same item.

Example 3: Let only admins add items

Using user-profiles, you can enable only people with a certain 'Role' to be able to add items. You can add this condition on the 'Add' panel of a list screen's configuration