Action: Passing an enum status value from parent to child

Hi.

What it the best way to pass an enum value from a parent record to a child record when building a simple action type: Data: set the values of… ?

I thought this [Opération ID].[Statut] would work since I have the REF to the parent (Opération ID) on the child table but it indicates: Error in expression…

This works but I do not feel it is the best way.
INDEX(SELECT(Opérations[Statut],[Opération ID]=[_THISROW].[Opération ID]),1)

Solved Solved
0 10 712
1 ACCEPTED SOLUTION

The Opération ID colum is of type ‘Text’ instead of ‘Ref’. This is why de-referance fails and the select expression works

View solution in original post

10 REPLIES 10
Top Labels in this Space