RangeToTable

[ala...@ept911.com]

How do I use the RangeToTable function?  Do I put the formula in the body of the email to be sent or do I create a new sheet with this?  I can't seem to figure it out or find any guidance on this.

[glua...@gmail.com]

See Range to Table by Martin Molloy.  See the Range to table on the Student Emails sheet column L.

You then use the column containing the rangetotable in the email.  The rangetotable summarizes the information from another sheet so it can be presented as a table in the email.

You might have to use CopyDown to get the formula in new responses.

[AJ Langa]

Thanks.  I was able to get the formula to take in the spreadsheet, but now I am getting this error:

dataRange and header arrays must be the same width 

My formula is this:  =RANGETOTABLE(FILTER('Last Month Data'!A3:K, MONTH('Last Month Data'!F3:F) = MONTH(B2)-1), 'Last Month Data'!$A$1:$K$2)

Any thoughts on how to fix this? 

Thanks,

AJ

--
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/d7c263e9-d2ef-4c0e-943b-13fca50c3a05%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Joseph Schmidt]

You have two rows of headings.  I don't think rangetotable  allows that.  Try changing it to one row and see if the error goes away.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CADDT8V1%2BrUwjODsagdxFO7SEiMBsY6_WZhw6g4L24h4Jyu_BDQ%40mail.gmail.com.

[AJ Langa]

Thanks Joe.  I gave that a try but unfortunately got the same error.

Current Formula:   =RANGETOTABLE(FILTER('Last Month Data'!A:K, MONTH('Last Month Data'!F:F) = MONTH(B2)-1), 'Last Month Data'!$A$1:$K$1) 

Error: dataRange and header arrays must be the same width

Any other thoughts? 

Thanks,

AJ

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CAPWPTOQrLdDdHDsmgZG_BhSbpqH3WeNToiTrg4utk2iRiXknNg%40mail.gmail.com.

[glua...@gmail.com]

I'm not sure you can use the Month function inside of the filter.  Try changing the filter to not have the Month function.  You may have to add two columns that contain just the month and then compare them using the filter in rangetotable.

On Sunday, May 5, 2019 at 9:39:39 AM UTC-4, AJ Langa wrote:

Thanks Joe.  I gave that a try but unfortunately got the same error.

Current Formula:   =RANGETOTABLE(FILTER('Last Month Data'!A:K, MONTH('Last Month Data'!F:F) = MONTH(B2)-1), 'Last Month Data'!$A$1:$K$1) 

Error: dataRange and header arrays must be the same width

Any other thoughts? 

Thanks,

AJ

On Sun, May 5, 2019 at 9:29 AM Joseph Schmidt <glua...@gmail.com> wrote:

You have two rows of headings.  I don't think rangetotable  allows that.  Try changing it to one row and see if the error goes away.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

om> wrote:

Thanks.  I was able to get the formula to take in the spreadsheet, but now I am getting this error:

dataRange and header arrays must be the same width 

My formula is this:  =RANGETOTABLE(FILTER('Last Month Data'!A3:K, MONTH('Last Month Data'!F3:F) = MONTH(B2)-1), 'Last Month Data'!$A$1:$K$2)

Any thoughts on how to fix this? 

Thanks,

AJ

On Sat, May 4, 2019 at 11:11 AM <m> wrote:

See Range to Table by Martin Molloy.  See the Range to table on the Student Emails sheet column L.

You then use the column containing the rangetotable in the email.  The rangetotable summarizes the information from another sheet so it can be presented as a table in the email.

You might have to use CopyDown to get the formula in new responses.

On Saturday, May 4, 2019 at 10:32:49 AM UTC-4, ala...@ept911.com wrote:

How do I use the RangeToTable function?  Do I put the formula in the body of the email to be sent or do I create a new sheet with this?  I can't seem to figure it out or find any guidance on this.

--
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-add-on+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/d7c263e9-d2ef-4c0e-943b-13fca50c3a05%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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-add-on+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CADDT8V1%2BrUwjODsagdxFO7SEiMBsY6_WZhw6g4L24h4Jyu_BDQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
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-add-on+unsub...@googlegroups.com.

[AJ Langa]

That worked.  I was able to get it to email a table of the data.

The dates / times are coming across as global dates / times in the email.  I am trying to get the times (i.e. 1 PM) and dates (5/4/2019) to stay in their original formatting like it is on the spreadsheet.  Any suggestions on how to get it to stay that way?

Thanks,

AJ

om> wrote:

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/d7c263e9-d2ef-4c0e-943b-13fca50c3a05%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CADDT8V1%2BrUwjODsagdxFO7SEiMBsY6_WZhw6g4L24h4Jyu_BDQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CAPWPTOQrLdDdHDsmgZG_BhSbpqH3WeNToiTrg4utk2iRiXknNg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--

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/48d65a1d-feaf-4726-b7ee-c79ff93cd891%40googlegroups.com.

[Joseph Schmidt]

Format the dates in a new column using the text function.  That will preserve the format.

Joe Schmidt

God Loves US All

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CADDT8V0NofwD2j6bk1Wkbizj3LQ7ZPYfuQ8bie5TuwvnN6PDKQ%40mail.gmail.com.

[AJ Langa]

That worked perfectly.  Thanks for your help, I really appreciate it.

Thanks,

AJ

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/CAPWPTOTB33sgo7w6voDT6zuRtFBDLsXax1nusVe%3D%3Dpp5%3D8NVGA%40mail.gmail.com.