Solved: Start Expression Help - Email Table Formatting - Page 2

djnguyen

Hello AppSheet Community!

I'm having some trouble with starting a START expression for an email template.

I have a table called Projects and I need to import some information onto it. I have a column named "Role Type" and this is an EnumList with 10+ options [Consultant, Sr. Consultant, Architect, Project Manager, etc.]

If a role is chosen - I also ask for the number of hours (Consultant Hours) and rate (Consultant) for each of the row.

I'd like to create an email with a dynamic table in which only the roles selected will be shown on the table - I don't want records with no input to be shown.

Any suggestions on how to start this? I've read up on the Start Expressions page and I just cannot wrap my head around it.

Thanks!

Example:

For a Project record - if I choose Consultant and Project Manager, I'd like this table to be outputted via email and would not need the other roles that were not selected on the email:

Role	Hours	Rate
Consultant	20	$100
Project Manager	30	$200

a_aleinikov

Hi @djnguyen ,

✔ To set this up, you can use a START expression in your email template like this:

<<START: SELECT(Projects[Related Roles], AND([Project ID] = [_THISROW].[Project ID], ISNOTBLANK([Hours]), ISNOTBLANK([Rate])))>>
Role: <<[Role Type]>>
Hours: <<[Hours]>>
Rate: <<[Rate]>>
<<END>>

✔ Key points:
— Use SELECT() to pull only related role records for the project.
— Add ISNOTBLANK([Hours]) or ISNOTBLANK([Rate]) in the filter so empty roles are excluded.
— Inside START, you loop over just the matching rows.

If your EnumList is stored inside a single record (not as child rows), you may need to restructure it or use a bit more advanced template logic.

View solution in original post