Dynamically select fields based on condition

[knozawa]

Hello,

I would like to dynamically select fields based on conditions.

If there is a "New Email" field, then select "New Email" field and do not select "Email" field.  If there is no "New Email" field, then select "Email" field instead.  Similarly, if there is a "New Phone" field, then select "New Phone" field and do not select "Phone" field.  If there is no "New Phone" field, then select "Phone" field instead. 

The tricky part is that sometimes there is no "New Email", "Email", "New Phone" or "Phone" fields.  In this case, there is no field to select.  When I was trying to use the dynamic select tool by using formula contains([Name],'New Email'), I got an error message Dynamic Select (50): RecordInfo::CreateRecord: A record was created with no fields.

Does anyone know how to dynamically select fields based on conditions?

Sincerely,

knozawa

[Inactive User · Accepted solution]

Solution attached.

[knozawa]

@Inactive User,

Thank you very much!

I've chanced the cross tab configuration and it worked well.

Sincerely,

knozawa