Manage Coda User Profiles with Formulas

[Tommy_Lambert]

Hello,

I’m trying to find a way to integrate Coda User Profiles with formulas. I’m developing a Project Management system and need to show a Coda user’s manager’s name in a specific column.

My setup includes an Employee Table with columns for User (formatted as People) and Manager (also formatted as People). In a To Do List Table, I want to display the manager’s name associated with a Coda user, as indicated in the Employee Table.

Here is a screenshot of my current setup:

Formulas:

// Formula 1:
[DB - Employés].Filter([DB - Employés].[Liaison du compte coda]=thisRow.[Created by]).[Manager - N+1].First()


// Formula 2:
[DB - Employés]
  .Filter([DB - Employés].[Liaison du compte coda].Email = thisRow.[Created by].Email)
  .[Manager - N+1].First()


// Formula 3:
[DB - Employés]
  .Filter([DB - Employés].[Liaison du compte coda].Email = thisRow.[Created by].Email)
  .[Manager - N+1].First().Concatenate([Manager - N+1].First())

Unfortunately, I’m struggling to display the manager’s Coda User profile. Could anyone offer some guidance on this?
Cheers,

Tommy

[Math_24]

@Tommy_Lambert

[DB - Employés].Filter([DB - Employés].[Liaison du compte coda]=thisRow.[Created by]).[Manager - N+1].First()

Hi tommy
use this solution :

[DB - Employés].Filter(
      currentValue.[Liaison du compte coda]=thisrow.[Created by]
).first().[Manager - N+1].First()

[Tommy_Lambert]

Thanks a lot @Math_24 ! It worked.