Skip to first unread message
Bradley Kennedy
Jan 17, 2020, 12:20:58 PM1/17/20
to NV Form Mule Add-on
Hello,
I had a really strange result today. The form mule add-on triggered normally but sent an old version of my template before sending the new version.
Any suggestions for why this happened? I've double checked the number of templates set-up and only my most recent one is there.
Any idea!?
Joseph Schmidt
Jan 17, 2020, 12:48:38 PM1/17/20
to nv-form-m...@googlegroups.com
Did you by chance set the merge jobs using a different email address?
Is this happening more than once?
--
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/b9e047c3-6b8e-4261-b55e-6f8af9230432%40googlegroups.com.
Bradley Kennedy
Jan 17, 2020, 1:00:45 PM1/17/20
to NV Form Mule Add-on
Hi Joe - I always make sure that i'm only ever logged into one google account at a time when using FormMule as i've hit problems with multiple accounts in the past.
When I made the change to the template it would have been with the one account.
I have noted that I made this change to the template back at the start of December. The emails sent after then had been fine! Just for some reason, the first trigger in January has used both the old and new versions!
I hope i've explained that well enough
Thank you
Brad
On Friday, January 17, 2020 at 5:48:38 PM UTC, Joseph Schmidt wrote:
Did you by chance set the merge jobs using a different email address?Is this happening more than once?
On Fri, Jan 17, 2020 at 12:21 PM Bradley Kennedy <mkenne...@gmail.com> wrote:
Hello,--I had a really strange result today. The form mule add-on triggered normally but sent an old version of my template before sending the new version.Any suggestions for why this happened? I've double checked the number of templates set-up and only my most recent one is there.Any idea!?
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.
Joseph Schmidt
Jan 17, 2020, 1:56:23 PM1/17/20
to nv-form-m...@googlegroups.com
That is strange and I have no answer for that.
On Fri, Jan 17, 2020 at 1:00 PM Bradley Kennedy <mkenne...@gmail.com> wrote:
Hi Joe - I always make sure that i'm only ever logged into one google account at a time when using FormMule as i've hit problems with multiple accounts in the past.When I made the change to the template it would have been with the one account.I have noted that I made this change to the template back at the start of December. The emails sent after then had been fine! Just for some reason, the first trigger in January has used both the old and new versions!I hope i've explained that well enoughThank you
Brad
On Friday, January 17, 2020 at 5:48:38 PM UTC, Joseph Schmidt wrote:
Did you by chance set the merge jobs using a different email address?Is this happening more than once?
On Fri, Jan 17, 2020 at 12:21 PM Bradley Kennedy <mkenne...@gmail.com> wrote:
Hello,--I had a really strange result today. The form mule add-on triggered normally but sent an old version of my template before sending the new version.Any suggestions for why this happened? I've double checked the number of templates set-up and only my most recent one is there.Any idea!?
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/b9e047c3-6b8e-4261-b55e-6f8af9230432%40googlegroups.com.
--
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/ce568ee7-252b-4f64-b3d0-246e6eafd3f6%40googlegroups.com.
Bradley Kennedy
Jan 24, 2020, 1:04:30 PM1/24/20
to NV Form Mule Add-on
Form Mule Team - User key: AOLcDSCmiYiaVy3FhIg/yVAOjMSZ3LMHYWdxegBdGIiyJukZ6UyFXZjIa00LfztYhz2RrL7qJLmN
This issue is still persisting.
I have only 2 email templates. An older version of one of these templates seems to be sending in addition to the newest version. I cannot find the old template in my spreadsheet anywhere (including hidden sheets). The spreadsheet history shows that the template was changed on 3rd Dec and sent normally after that. Do the logs show anything different?
Thank you in advance
Brad
Amanda Smith
Jan 24, 2020, 2:43:27 PM1/24/20
to NV Form Mule Add-on
Hello Brad,
Thank you for providing your user key and for explaining the issue so clearly.
Under your key (which provides error logging for every form mule job on your account so the results might not apply to the job you are inquiring about):
I see a few current errors:
"Manual send failure: failed to load sheet with id undefined" & "Error on time trigger, no item with the given ID could be found"
Both of these errors have to do with Form Mule pushing out the email and by a manual push by going to "Preview and Send all" and on an automatic time trigger, Form Mule can not confirm access to the spreadsheet. (These errors could be occurring on different sheets) Usually, these mean that the spreadsheet is on a Team or Shared Drive; the spreadsheet has been placed in the trash ( but the trigger is still on) or that the account trying to push out the emails does not have edit access to the file. ( I said you are diligent about only being logged into one account but that could also be another reason for these errors)
The other error being logged relates to Form Mule being connected to the wrong tab on the spreadsheet, you should be able to see if this an issue by going to the dropdown menu go to step1. "Choose source data and set merge type" and then make sure the correct sheet is selected. (If there is no sheet selected here, this can also lead to errors)
I can't see how any of the above-listed errors would cause the behavior you are seeing. Just to recap; you have two current templates so there are only two 'Send Status' columns on your spreadsheet. Within this spreadsheet, you do not have a hidden tab with the old version of the template. This Form Mule job runs on a trigger ( time/form or both?)
Can you see from the 'sent' tab in your inbox that both versions are being pushed out at the same time?
Can you turn the triggers off and then do a test email push to another email account your own, either by filling out a mock form or manual push in the module, do both versions still send out?
Thanks!
Bradley Kennedy
Jan 24, 2020, 3:15:15 PM1/24/20
to NV Form Mule Add-on
Hi Amanda,
Thank you so much for your speedy and comprehensive reply. I hope to provide some more details and answers to your questions.
Firstly - today I used the "Preview and Send all" feature to test Form Mule for a test row I added - it worked ok, it sent the email using the correct template.
I can confirm that the spreadsheet is not on a team or shared drive, it is not in the trash and the account sending the emails does have edit access to the spreadsheet.
I checked to see if form mule was connected to the wrong tab, in step 1 "Choose source data and set merge type" it shows as connected to the correct tab.
My form mule job runs on a day trigger (I've attached some screenshots).
Interestingly, when I check my sent box in the emails, the old template gets sent out at 1!:22am and the current template at 12:34pm.
I've just done another test, with the triggers turned off and used the "Preview and send all" - it sent the correct template.
Attachments:
- This one shows that it is connected to the correct tab, called "Sheet1" (no space).
This attachment shows that there are only two templates. The one which is causing a problem is the one called "Reminder". The final screenshot shows the only tabs in the spreadsheet.
I hope this information helps your investigation.
Thanks
Brad
Joseph Schmidt
Jan 24, 2020, 3:29:47 PM1/24/20
to nv-form-m...@googlegroups.com
I hope you don't mind a suggestion. Make sure you think through my suggestion so you don't lose any data.
I'm thinking that you have another merge that you can't see but that Google thinks is still connected to this Form / Spreadsheet combination.
I would try changing the output to a new spreadsheet via the Form Responses output.
Once you are sure that your data is in the new spreadsheet, make a copy of the old spreadsheet for history. Any jobs on the old spreadsheet will not be copied.
After you have double checked everything, delete the original spreadsheet and the go into your Trash folder and delete it there. That should kill any jobs associated with the old spreadsheet.
Are you using any other Add-ons with either the spreadsheet or the form?
Taking an educated guess. I don't see any other complaints of the same problem.
--
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/0c7b2789-9ba4-42d6-ad3d-782d9c1de304%40googlegroups.com.
Bradley Kennedy
Jan 24, 2020, 3:45:34 PM1/24/20
to NV Form Mule Add-on
Hi Joe -
Thank you very much for this suggestion, I think I agree with you that there is some sort of old Form Mule rule that I cant see which probably came about after I changed some wording in a template.
Your suggestion seems like the most efficient and practical solution to this issue. (I appreciate you considering any data loss!).
It is such a shame that it had to resort to "starting from scratch" - hopefully this issue doesn't appear again!
Brad
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-mule-add-on+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages