driver can see only their job?

[Rott_Roma]

Hi everyone, I created an app on appsheet starting from the template called "Field Delivery" because it reflects 100% what I need. The problem I am unsuccessfully trying to solve is to show the "drivers" only the jobs that are assigned to them.

The process is as follows:
I create a new "Job"
I assign it to the "driver"
The "driver" in the app only sees his jobs and not all the jobs on the list.

In the excel on google sheet I have only two sheets, "job" and "driver".

what I would like is to filter the jobs of the "job" sheet for each "driver"

Has anyone solved it using this template?

[Marc_Dillon]

https://help.appsheet.com/en/articles/1128148-limiting-users-to-their-own-data

[Rott_Roma]

hi Marc, i know this practise but i need assistance to apply it to my app. i'm using Field Delivery template. how can i set the email of the driver automatically on a column when the job is assigned to the driver? for the moment the app assign only the unique id KEY and i can't replace it with the email field.