About David2

David2 · 10-16-2023

Hi,I've got three tables; User, Roles and NotesThe Users and Notes table has an ENUMLIST that references the Roles table.A User, or a Note can be assigned one or more Roles.I have this security filter on the Notes tableOR(useremail()=[Created By Emai...

User & Role Management Interface · 09-24-2023

I believe Appsheet could be greatly improved with a user and role management interface.This would allow new users of an app to be added and assigned to one or many roles.Inside the app builder, each table, view and field would offer the option to sel...

David2 · 10-05-2022

Hello,From time to time in my apps I use EnumLists with the base type Ref, what I was wanting to know, is if it's possible to keep back linking with this type of field?Like a normal referenced field, it's possible to click through to that referenced ...

David2 · 09-10-2022

Hello,Ive created an app which stores projects and information for these projects in one table.I currently have slices set up and have views as follows;Projects - Sales - In ProgressProjects - Sales - CompleteProjects - Production - In ProgressProjec...

David2 · 06-08-2021

I am looking to create timesheet and project labour within my app, where specific time on each project is allocated to a single timesheet for the day, to do this, I need a unique and identifiable field in the timesheet table, that the project labour ...

David2 · 10-23-2023

Thank you, @AleksiAlkio and @MultiTech for your input on this, security filters have been a long time struggle for me, I've finally got a number of security filters implemented into my apps, couldn't have done it without you both.

David2 · 10-17-2023

Thanks for this option @MultiTech. After seeing your post, and just as I thought I had this all sorted, I'm now questioning my knowledge a little further Is using a user slice, the preferred method for using security filters in an app, instead of us...

David2 · 10-17-2023

Thank you so much, really appreciate your help on this one.

David2 · 10-17-2023

Thank you so much @AleksiAlkio !That worked, I also found another working code, both belowOR(useremail()=[Created By Email],COUNT(INTERSECT([Available To], split(lookup(useremail(),"Users","User Email","User Role"), " , ")))>0)OR(useremail()=[Created...

David2 · 10-17-2023

It is an EnumList, allowing a user to be part of one or more Roles

My Stats

David2's Bio

Badges David2 Earned

Recent Activity

Security FIlter Issue

User & Role Management Interface

Backlinks with an EnumList Base Ref

Restricting Data Access

Self Populating Field Issue

Re: Security FIlter Issue

Re: Security FIlter Issue

Re: Security FIlter Issue

Re: Security FIlter Issue

Re: Security FIlter Issue

David2's Ideas (1)