Hello,
I have a question that I can’t figure out to find the solution.
I have a table called ‘timesheet’ that is related to a child table called ‘attendants’.
In the table ‘timesheet’ I have the fields:
- useremailattendant (formula is: USEREMAIL() )
- coach (this is a ref to the table ‘attendants’)
In the table ‘attendants’ I have the fields:
- emailattendant
- nameattendant
- department
The fields in the table ‘attendants’ are be filled in automatically by an integration with a external system and cannot be changed by users. They always will have a value. It is just a reference table.
An attendant can only occur once and has only on emailattendant, nameattendant and department.
What I would like to happen is that when a user uses the app to fill in the timesheet, the name of the field coach will be fetched from the table ‘attendants’ field ‘nameattendant’, based on the corresponding e-mailadress (where emailattendant=useremailattendant).
Second is it possible to get a notification if there are no matching e-mailadresses? If os how can I set this up?
Help will be very welcome,
Thanks,
Marcel
LinkedIn
Twitter
