Sending an Email on Form Submissions with Column Name and Values of submission

[SeanGroomes]

There doesn't seem to be a way to just inject all values and their corresponding column names for sending a notification email that's a summary of the Form responses.

Appsheets seems to be restricted to needing to statically name a column to do anything.

I've seen this behavior in other products that intentionally try to restrict dynamic calls, but I wanted someone to confirm that this is the case for Appsheet.

While I can manually name the column and reference the current submissions value, I'd really like to not have to update a template manually every time a form changes.

If it's not possible I'll have to do this entirely in Apps Script which would be a bummer.

[Steve · Accepted solution]

---

@SeanGroomes wrote:

There doesn't seem to be a way to just inject all values and their corresponding column names for sending a notification email that's a summary of the Form responses.

---

Correct.