0

Table records user control

Hi, I have an expenses table shared by different users but I want that each user only sees the records created by themselves. Is this possible. They have the same role and need to access the same table with the same rights but they shouldn't see other user records in that table.

Thanks

3 replies

null
    • Carlos_Martinho
    • 3 yrs ago
    • Reported - view

    One more thing, I have tried this with filters but they could remove the filter so itsn't a solution 

    • John_Halls
    • 3 yrs ago
    • Reported - view

    Hi Carlos this is an easy and powerful feature of Ninox.

     

    In Edit fields... do you see Readable if in the lower left had side. If there is a formula placed there it has to evaluate to true for the record to be seen. There is a field called 'Created by' which you can't see in Edit fields..  but you can see it in the Available Columns of the list view. This keeps track of the user that created the record. There is also a function called user() which returns the current user. Put this all together by placing the following in Readable if

     

    'Created by' = user()

     

    Regards John

    • John_Halls
    • 3 yrs ago
    • Reported - view

    In addition

     

    The Readable if also relates to the child tables if Compsition is set to Yes but if Composition is set to No the children of a non-readable parent remain visible, and the parent can be shown from this record, so you may want to scope these as well.

     

    Regards John

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 345Views