0

Is there a way to allow a user to see some records but not others in a table?

For example, if I add a customer as a user, could I make it that they can only view their invoices and not everyone elses?

4 replies

null
    • Xstra Group
    • Faz
    • 4 yrs ago
    • Reported - view

    ... or is there a way to set a filter on a table that users can't change?

    • Antonello_Stabile_71
    • 4 yrs ago
    • Reported - view

    Ciao, il filtro sulla tabella purtroppo lo possono rimuovere momentaneamente, ma lo ritroveranno alla successiva ripaertura della tabella. Potresti mettere nel campo "leggibile se" della proprietà della tabella il filtro più adatto. 

    nel mio caso ad esempio utilizzo il questo scritp :

    user() = Tecnico or userRole() = "admin" or userRole() = "Ufficio" or user() = Assistente or userRole() = "admin" or userRole() = "Ufficio"

    • Xstra Group
    • Faz
    • 4 yrs ago
    • Reported - view

    Grazie, that helped - for anyone else who is looking for similar - against the table you can use "Readable if" and "Writable if" :

    readable/writable

    with a formula such as:
    record.'Is Confidential'=false or userRole()="SuperUser" 
    meaning you can flag individual records as being confidential that only someone with the role "SuperUser" can see

    • Xstra Group
    • Faz
    • 4 yrs ago
    • Reported - view

    In my case, I wanted a particular user to be able to only see records pertaining to them - so my formula is like record.person.name = myUsersName or userRole()="SuperUser" and it is working as I wanted

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 2099Views