FormMule with multiple rows in email

104 views
Skip to first unread message

Diane Berthoin-Hernandez

unread,
Sep 27, 2023, 5:54:38 AM9/27/23
to nv-form-m...@googlegroups.com
Scenario:
A google form collects registrations from ten counselors. I want to send a summary email to each counselor that shows them their registrations
Example: 
row 1, 4 and 5 belong to counselor Smith 
Row 2, 3, 6 and 10 belong to counselor Harris
Email to Smith shows the row 1, 4 and 5
Email to harris shows rows 2, 3, 6 and 10

Is it possible to accomplish this with formmule?

Diane 
-: -: -: -: -: -: -: -: -: -: -: -: -: -:
Diane Berthoin-Hernández
Principal
Learning & Credit Options
Canvas Administrator
(971) 284-6355

中文 | Chinese: 503-916-3585  
Español | Spanish: 503-916-3582  
Tiếng Việt | Vietnamese: 503-916-3584
Soomaaliga | Somali: 503-916-3586
Русский |Russian: 503-916-3583  
Other Languages: 503-915-3589

My name is of French origin. Here is how to pronounce it.


*from cell

Joseph Schmidt

unread,
Sep 27, 2023, 9:46:14 AM9/27/23
to nv-form-m...@googlegroups.com
You can do it with a Range-to-table.

See Range to table..  Not one of my better videos but I hope it helps.



--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/37CAEB9D-24B5-40C6-92E3-AEE5F4984106%40pps.net.

Ken Cheney

unread,
Sep 29, 2023, 12:21:39 PM9/29/23
to nv-form-m...@googlegroups.com
One idea might be to create multiple templates with the trigger being on if the names matched vs NULL or NOT NULL.

On Wed, Sep 27, 2023 at 5:54 AM 'Diane Berthoin-Hernandez' via NV Form Mule Add-on <nv-form-m...@googlegroups.com> wrote:
--
You received this message because you are subscribed to the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-ad...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/37CAEB9D-24B5-40C6-92E3-AEE5F4984106%40pps.net.


--
Ken Cheney

Diane Berthoin-Hernandez

unread,
Sep 29, 2023, 10:56:04 PM9/29/23
to nv-form-m...@googlegroups.com
We need all three rows of data in ONE email. 


-: -: -: -: -: -: -: -: -: -: -: -: -: -:
Diane Berthoin-Hernández
Principal
Learning & Credit Options
Canvas Administrator
(971) 284-6355

中文 | Chinese: 503-916-3585  
Español | Spanish: 503-916-3582  
Tiếng Việt | Vietnamese: 503-916-3584
Soomaaliga | Somali: 503-916-3586
Русский |Russian: 503-916-3583  
Other Languages: 503-915-3589

My name is of French origin. Here is how to pronounce it.


*from cell


On Sep 29, 2023, at 9:21 AM, Ken Cheney <k...@lan-tastic.com> wrote:



Joseph Schmidt

unread,
Sep 29, 2023, 11:26:23 PM9/29/23
to nv-form-m...@googlegroups.com
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/C766A5DB-A535-4C17-807C-6790D6F50800%40pps.net.

Diane Berthoin-Hernandez

unread,
Sep 30, 2023, 1:11:35 AM9/30/23
to nv-form-m...@googlegroups.com
Ohhhhhhh mind blown! Gonna give this a try!

Thanks, Joe


-: -: -: -: -: -: -: -: -: -: -: -: -: -:
Diane Berthoin-Hernández
Principal
Learning & Credit Options
Canvas Administrator
(971) 284-6355

中文 | Chinese: 503-916-3585  
Español | Spanish: 503-916-3582  
Tiếng Việt | Vietnamese: 503-916-3584
Soomaaliga | Somali: 503-916-3586
Русский |Russian: 503-916-3583  
Other Languages: 503-915-3589

My name is of French origin. Here is how to pronounce it.


*from cell


On Sep 29, 2023, at 8:26 PM, Joseph Schmidt <glua...@gmail.com> wrote:


Message has been deleted

Joseph Schmidt

unread,
Oct 17, 2023, 4:39:55 PM10/17/23
to nv-form-m...@googlegroups.com
Diane,

I added a link to the example spreadsheet to the description of the Video.

See Formtotable example.  I added a sheet with the columns rearranged.

=if(isblank(A2),"",RANGETOTABLE(FILTER(
{'formresponse with date'!B:J,'formresponse with date'!A:A}
,'formresponse with date'!K:K=A2),{'formresponse with date'!B1:J1,'formresponse with date'!A1}))

I used {squiggly brackets} to create an array in a different order.  You should be able to put the columns in any order and skip columns with that technique.

As for numbers in the table.  The formatting of a column doesn't get copied to the rangetotable.  You have to create a new column and use the TEXT formula to format the number as you want it.  You can use an array formula to get the column in every row.

On Tue, Oct 17, 2023 at 12:41 PM 'Diane Berthoin-Hernandez' via NV Form Mule Add-on <nv-form-m...@googlegroups.com> wrote:
Joe, 

I finally got this to work and it looks awesome. Two follow up questions: 
1. If I want to put in the table only SOME of the fields, how to I adapt? here is the rangetotable I used: 
=RANGETOTABLE(FILTER(ALL!B$2:J$39,ALL!A$2:A$39=A2),ALL!B$1:J$1)
i'd like to use columns B through E and then J and K. (for example) 

2. I noticed that I could not get percentages to show up correctly. In the original data, the percentages are rounded to the nearest whole number. In the table the percentage was a decimal. Example: Original is 59% (rounded) and the talbe shows .5879357432. Yikes! How do I make it NOT do that? I tried changing the data type in the sheet but nothing worked. 

Thanks in advance. This is s super cool function. I am still wrappign my head around it but dang it is good. 

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/4f44d2d7-c457-485a-b6ee-b08f408ebb7an%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages