0

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

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    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

    • Road Information Technology (RIT)
    • John_Byrnes
    • 3 yrs ago
    • Reported - view

    Hi Jorg,

    I have the same question. Is there a solution written somewhere?

    John Byrnes

    • cyan_silver
    • 3 yrs ago
    • Reported - view

    Is there any solution

    • Shawna
    • 3 yrs ago
    • Reported - view

    Would love a solution

    • Customer Service Ninox
    • Maria_pasini
    • 3 yrs ago
    • Reported - view

    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.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 5Replies
  • 2553Views