Allowing Driver to read all table data and edit element only

Hello all, If I have a table called “Orders” which has for instance the following columns

Id

Date

Item name

Item photo

Item Description

Item price

Customer Detail

order status

Delivery Status (Delivered - Not Delivered)


Now suppose that I have a driver who delivers orders to customers.

at this point I create a slice called driver that linked to the main order table, and then sow driver view in navigation menu for drivers to see.

** THE PROBLEM** is how can I allow the driver to read all order columns data and just give him/her permission to only edit the column (delivery status)

Conditionally allow column edits (Editable_If) - AppSheet Help

More info at SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community

2 Likes