I would like to create if-then logic for multiple rows of a table based on a value in the table itself. Example:
Name | Type | Date |
Richard | A | 4/7/2025 |
Chase | B | 4/7/2024 |
Melissa | A | 4/4/2025 |
The merge tag would essentially state that, "if the Type=A, then state, [Name] enrolled in services on [Date]", but "if the Type=B, then state, [Name] cancelled services on [Date]".
Is there a way to create one merge tag that evaluates all the rows in the table based on the "Type" column, then creates different outputs based on the "Type?" What type of "field type" should I use in the Form for the Configuration, too? I have it now as a "Custom Table," but I'm not sure if that's the right field type to use.