¿How can I slice ref rows in an entry form for each user?

[Rene_Casana_Ama]

I have three table slices: [doctors], [patients] and [appointments], all the table slices are sliced with the condition UserEmail=USEREMAIL(), doctors are the final users, so that each doctor see he´s patients only, he´s appointments only and he´s colleagues only. Everything works fine in each view.

My problem is that when (Doctor A) makes a new appointment in the new appointment form, the [Patient] dropdown menu displays all the patients unfiltered

[LeventK]

@Rene_Casana_Amaya
In your Patients table/slice, do you have the associated [Doctor] info? If so, you can set the below Valid_if expression to the [Patient] column in the Appointment_Form. Please change the tablename and column names as required by your table/app schema

SELECT(
	Patients[PatientName],
	[Doctor]=[_THISROW].[Doctor]
)

[Steve · Accepted solution]

For better performance and security, consider using security filters rather than slices.

help.appsheet.com

Security Filters: The Essentials

You can use Security Filters to control which records a user can see and update.

[Rene_Casana_Ama]

Oh that was easy, worked fine and I got rid of many slices.