I have 4 tables (Employees, Jobs, Customers, TimeSheet), I need to constrain the employees to only see Jobs they are signed to. I also need to be able to sign each job a customer so they Jobs can be attached to a customer for billing.
Constraints for Table Timesheet Field Customer (Customer table is referenced)
a.employee.name=a.customer.name=a.job.name
Constraints for Table Timesheet Field Job (jobs table is referenced)
a.employee.name=a.customer.name=a.job.name
5 replies
-
Hello,
That would be a good question for our webinar and it would be nice if you could bring it up there.
Thank you very much.
At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for a live support where the participants' concerns will be solved.
You can register here for the webinar, which takes place every Tuesday at 18 o'clock CEST: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg
Best, Jörg
-
Hi Jorg,
I have the same question. Is there a solution written somewhere?
John Byrnes
-
Is there any solution
-
Would love a solution
-
Hello! To make sure that the user can only see where his name is selected you must:
1. Add the field 'User' in the table
2. In the 'Readable if()' field of the table edition screen you have to put the code:
user()=User or userRole()="admin".
With this, the assigned User (editor role) will be able to see only the records in which his account has been selected
And the Admin will also be able to see everything.
Content aside
- 4 yrs agoLast active
- 5Replies
- 2557Views