About the issue of allowing edits only when conditions are met…”
![](https://s3-us-west-2.amazonaws.com/media.forumbee.com/i/04a5f5e6-25c0-4dd5-bd92-e1ab3cabd526/h/547.png)
I have created two tables for employees’ orders. I want to allow modifications to Customers.text only when Orders.Salesman is the same as Customers.Creator. How can I implement this? Thank you for your response.
10 replies
-
If you have a professional subscription a whole lot of power comes with the upgrade. The Readable if... and Writeable if... sections are available at a table and a field level.
Regards John
-
FYI, when you want to do a report on all orders your current setup will make it difficult to script as you have to get data from different tables. What happens when you add a new sales person? Are you expecting to create a new table?
Try to keep similar data in one table. What differentiates the two Orders tables, besides the sales person?
-
said:
(Or is there a better way to achieve this effect?)Yes there is. Try not to mix security/permission with DB structure design.
You can view this video
to give you the basics on role based security.
Nioxus also have training videos around security and permission. You may want to subscribe and watch them.
-
Hi, as suggested and mentioned, there is a simpler way.
Open the Gear icon of the 'Customers' table then click on 'Edit fields...' and inside the 'Readable if' function put the following code:
userName() = text('Created by')
Could you try this and let us know if it works?
Content aside
- Status Answered
- 1 mth agoLast active
- 10Replies
- 57Views
-
4
Following