Get data from other table through USEREMAIL()

[Marcel1]

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

[1minManager]

First question
Any(Select(Attendants[nameattendant],[emailattendant]=UserEmail()))

Second question
IF(
ISNOTBLANK(Any(Select(Attendants[nameattendant],[emailattendant]=UserEmail())))
,
Any(Select(Attendants[nameattendant],[emailattendant]=UserEmail()))
,
“Missing Attendant”
)
So if it would have been blank it will put Missing Attendant in that cell. Then simply create a workflow with a creation tigger of [Coach]=“Missing Attendant”

Hope this helps

Simon@1minManager.com

[Marcel1]

Hello Simon,

Thanks for you quick reply and answers. The expressions works well.

Kind regards,
Marcel