FormMule stopped sending notifications

--
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/56d13684-5f92-4d20-8e1b-ffbb627e0089n%40googlegroups.com.

Katarzyna Rogowska-Kot

unread,

Feb 7, 2024, 4:12:10 AM2/7/24

to nv-form-m...@googlegroups.com

Hi Joe,

Thanks for the note

Nothing changed that I am aware of

Status column is blank, does not work in incognito either

Also, when I go to extension -> FormMule, I first have to open it to see any other actionable options. At opening, it keeps adding a blank New Submitted Form Template. I delete it each time as well as I delete new status columns appearing either at the end of the Form Responses sheet or at the end of the current/proper New Form Submitted sheet.

Can you help me with this?

bests

kasia

Katarzyna Rogowska-Kot

Finance Controller

Global Core Team: Technical Accounting and Policies

The Nielsen Company

Mobile +48 661 953 313

www.nielsen.com

Please consider the environment

before printing this email

Nielsen Media Services Poland Sp. z o.o., ul. Burakowska 14, piętro 3, 01-066 Warszawa

You received this message because you are subscribed to a topic in the Google Groups "NV Form Mule Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-form-mule-add-on/PMYwM7QhcMY/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAPWPTOTEzEv05g1HwD_Zb2NTP8jUFW0%2BD41sH6xWqq10HKAwkg%40mail.gmail.com.

Joseph Schmidt

unread,

Feb 7, 2024, 11:34:05 AM2/7/24

to nv-form-m...@googlegroups.com

You might want to try a new destination from the Google Form. Basically, start over.

Joe Schmidt

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

Kurt

unread,

Feb 7, 2024, 12:33:37 PM2/7/24

to NV Form Mule Add-on

I know how to fix this.

This has happened to me several times. The weird thing is that it stopped happening and hasn't happened for the last few years, until today it happened again.

The problem is that for some reason the first panel that sets the triggers and allows you to select the tab that it will be looking at somehow "forgets" and resets to a generic option. I have learned to always double check which tab is identified on this panel before going any further. Sometimes formmule does not open on this panel. In that case your first clue is that the template name has changed (with the addition of the word "template" appended to the real name) and it has defaulted to "send for all rows". For this reason I never use "send for all rows". That way I know that if I see that, something has gone wrong. Even if I want it to send for all rows, I will choose "Timestamp" and "NOT NULL".

Solution:

Go to the first panel. (If it doesn't open on the first panel it will give you a "back" button). Choose the correct tab for where you want formmule to look. (This has been enough to fix the problem some of the time.) Go to the second panel and make sure the email template has the correct title. Likely it will have the word "template" appended to the normal template name. Delete the extra "template" word. If you have reopened it muliple times you may have that word appended multiple times. Make sure the send condition is correct and click "save template settings". This should fix it.

In the early days before I figured this out, I would just recreate the form from scratch. Obviously that is not sustainable if you are making a lot of use of formmule. If you do need to do this, you can go to your google drive, right click on the form and click create a copy. Then you will have to create a new spreadsheet and set everything up again.

Dulce Perez Figueroa

unread,

Feb 7, 2024, 6:31:53 PM2/7/24

to NV Form Mule Add-on

Hi Guys!

I am having the same issue however I can not select a template or move on at all. When going to name my template and pick the trigger, it only gives me my first 3 columns.

Once I hit next it just deletes everything and restarts. I already attempted to start from scratch, I am at a loss.

Katarzyna Rogowska-Kot

unread,

Feb 8, 2024, 3:59:50 AM2/8/24

to nv-form-m...@googlegroups.com

Kurt,

thank you so much!

It worked - it sent mails when prompted. I'll see if it does it automatically when a new form is submitted.

But here is another question - I got this New Form submitted Template (redundant) tab added as a hidden sheet, as well as a new status column at the end of the 'desired' template and the Fom Response sheet - is it better now to keep these or delete them?

For illustration of what I mean, that's what my 'desired' new form submitted template looks like now:

And this is the Form Responses sheet:

Thank you

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/612d7d61-6767-41f7-a0bf-b237a94694dbn%40googlegroups.com.

Message has been deleted

Joseph Schmidt

unread,

Feb 8, 2024, 10:48:44 AM2/8/24

to nv-form-m...@googlegroups.com

Formmule adds a sheet with the merge information and a column to keep track of the status of the merge. If you name a merge something different during setup, a new hidden sheet and a new column will be added.

I hope this helps.

Joe Schmidt

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

Kurt

unread,

Feb 8, 2024, 12:56:29 PM2/8/24

to NV Form Mule Add-on

Why did you delete my post?

Katarzyna Rogowska-Kot

unread,

Feb 8, 2024, 1:27:56 PM2/8/24

to nv-form-m...@googlegroups.com

Me? I did not - I am on email only, don’t even see these posts in a chat

And I am grateful beyond words for your advice 🤗

Pozdrawiam/Cheers, KRK

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/c75af8cd-7dfd-49b7-b0d9-e495fbf6acc1n%40googlegroups.com.

Message has been deleted

Bart van Dalfsen

unread,

Feb 8, 2024, 1:42:04 PM2/8/24

to nv-form-m...@googlegroups.com

Hi Kurt,

? Do you mean this one:

I know how to fix this.

This has happened to me several times. The weird thing is that it stopped happening and hasn't happened for the last few years, until today it happened again.

The problem is that for some reason the first panel that sets the triggers and allows you to select the tab that it will be looking at somehow "forgets" and resets to a generic option. I have learned to always double check which tab is identified on this panel before going any further. Sometimes formmule does not open on this panel. In that case your first clue is that the template name has changed (with the addition of the word "template" appended to the real name) and it has defaulted to "send for all rows". For this reason I never use "send for all rows". That way I know that if I see that, something has gone wrong. Even if I want it to send for all rows, I will choose "Timestamp" and "NOT NULL".

Solution:

Go to the first panel. (If it doesn't open on the first panel it will give you a "back" button). Choose the correct tab for where you want formmule to look. (This has been enough to fix the problem some of the time.) Go to the second panel and make sure the email template has the correct title. Likely it will have the word "template" appended to the normal template name. Delete the extra "template" word. If you have reopened it muliple times you may have that word appended multiple times. Make sure the send condition is correct and click "save template settings". This should fix it.

In the early days before I figured this out, I would just recreate the form from scratch. Obviously that is not sustainable if you are making a lot of use of formmule. If you do need to do this, you can go to your google drive, right click on the form and click create a copy. Then you will have to create a new spreadsheet and set everything up again.

</quote Kurt>

Op do 8 feb 2024 18:56 schreef Kurt <kbru...@jeffcoschools.us>:

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/c75af8cd-7dfd-49b7-b0d9-e495fbf6acc1n%40googlegroups.com.

Joseph Schmidt

unread,

Feb 8, 2024, 2:02:18 PM2/8/24

to nv-form-m...@googlegroups.com

No one deleted your post. See https://groups.google.com/g/nv-form-mule-add-on/c/PMYwM7QhcMY/m/u77zsJSeAQAJ

Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/c75af8cd-7dfd-49b7-b0d9-e495fbf6acc1n%40googlegroups.com.

Diane Berthoin-Hernandez

unread,

Feb 8, 2024, 3:09:39 PM2/8/24

to NV Form Mule Add-on

I can't even get the back button to show up. This morning I could see half of the right side scroll bar but now I can't even see that. No new templates being created on this sheet. However, we have another we create a week ago and it is making extra temples. One other sheet is also impacted... (Incognito did not work) Screen Shot 2024-02-08 at 11.49.48 AM.png

Screen Shot 2024-02-08 at 11.49.48 AM.png

Kurt

unread,

Feb 8, 2024, 3:30:40 PM2/8/24

to NV Form Mule Add-on

I reiterated my deleted post and now that one has been deleted too.

Kurt

unread,

Feb 8, 2024, 4:22:00 PM2/8/24

to NV Form Mule Add-on

Prior to this one, I have made 5 posts. Only three remain and there are two notices that say "Message has been deleted".

I have to assume at this point that I somehow violated a built-in automated blacklist item. Although I can't imagine how. My posts were benign.

I simply was trying to let Kasia know that it is ok to remove the extra tabs and columns that were automatically created. Doing that will not cause any problems.

Looking at a hidden tab causes it to be visible, but you can simply hide it again as well. I'm just glad I could help.

Katarzyna Rogowska-Kot

unread,

Feb 9, 2024, 4:32:14 AM2/9/24

to nv-form-m...@googlegroups.com

Thanks a million Kurt!

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-mule-add-on/46871463-1731-42d8-9cc5-fcb82ababf68n%40googlegroups.com.

Natanya Kinsey

unread,

Feb 22, 2024, 1:19:20 AM2/22/24

to NV Form Mule Add-on

I am having this same issue, and cannot seem to solve it. I've tried all of the suggestions and just can't get these emails to be sent out. Now tonight, my newest issue is formMule won't even open, it's just spinning. Ugh!!!!

Joseph Schmidt

unread,

Feb 22, 2024, 9:20:22 AM2/22/24

to nv-form-m...@googlegroups.com

From your previous email, it looks like you are using a CNTL-Enter to put a new line in the title of the columns.

Try creating a new spreadsheet and coping your data to the new spreadsheet. That should get rid of the spinning wheel.

Try removing the CNTL-Enter from the column titles.

Let me know if this works.

Joe Schmidt