I am trying out to use the sample app, Field Delivery,
and there is a Driver and Job sheet. I saw the other examples everywhere in order to get login user to view their own data is to use the [EmailColumn]=USEREMAIL() and set them in the Security Filter,
but I saw the Job Sheet does not have the EmailColumn, only a Driver’s id column, which can be used to search in the Driver sheet,
so if we wish to enable the Driver to be able to login to the App and view only their own Job, are we able to use the user-id to set the security filter for their own data?
What I mean is without adding the driver’s email address which can be found on the Driver sheet, is that able to do the filtering?
Or do we need to create a separate APP just for the Driver in order to do the security filter with Email Column ?
Do appreciate any help, thanks a lot.