I feel like what I’m trying to do is achievable, but I can’t find the solution. I’m trying to create a table that will track the dates individuals submit certain documents to us. I need each column to have a button that will send an email to person missing that column like this:
I know I can manually make these buttons, or use SwitchIf(), but there’s something like 30 columns, so I’m looking for a more dynamic way to create those buttons, and make it easy for editors to create new ones if they need.
I’m hoping there’s a way to achieve something like this:
Hey Samuel, thanks for reaching out! It is possible to create a button like this, though it depends on how you want your email organized. We have templates in the gallery that can serve as a starting point.
For the button formula, you can set up a Filter() formula with a SendEmail() Gmail pack formula for each Item column. E.g. I’m thinking the Item 1 button formula could look something like this: