Failed to insert row into spreadsheet... Error: BAD_REQUEST

[Pete Thorpe]

I am getting increasing frustrated with this error..

It doesn't tell me WHY it's a bad request, however;

I have changed the sheets document to a new one, have generated a new sheets document from within the forms trigger sidebar, from the forms 'destination spreadsheet' option, I have COMPLETELY rebuilt the form and then the whole ultradox procedure.. But I Still Get This Error!!!!   Grrrr

Below is what I am trying to do, I guess I need to know;

a) is it ACTUALLY possible to do this? or am I asking too much of the system?

b) what the heck am I doing wrong (assuming that it is ME that is doing something wrong, or missing something)?

Load values from the form

Insert row with 21 columns into worksheet of a spreadsheet

Generate a PDF from a Word document using the entries from the worksheet

Upload that PDF to drive

Send email of PDF to a specific address

Generate a different PDF from a different word document using the entries from the worksheet

Upload that PDF to drive

Print that PDF via cloud print

This HAS worked in the past, Something has happened to make it stop (what exactly, I have no idea), and hence me having to investigate, which lead me to rebuild the procedure, and result in this error/thread.

I am going slowly, slightly insane. Getting frustrated daily in not being able to resolve this, having spent many hours on trying to fix this most days, usually giving up because it's like bashing my head against a wall..

Please help me!

[Daniel Florey]

Hi Pete,

that sounds really bad ;-)

Could you share the involved files with me in edit mode so that I can reproduce the error and check why it pops up?

Regards,

Daniel

--
You received this message because you are subscribed to the Google Groups "floreysoft" group.
To unsubscribe from this group and stop receiving emails from it, send an email to floreysoft+unsubscribe@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.
Visit this group at https://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

[Pete Thorpe]

Hi Daniel

Will share for sure, just not sure how I do this :-D

--
You received this message because you are subscribed to a topic in the Google Groups "floreysoft" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/floreysoft/pE2u64u0nbU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to floreysoft+unsubscribe@googlegroups.com.

[Pete]

Hi Daniel

Will share for sure, just not sure how I do this :-D

On 19 October 2016 at 09:27, Daniel Florey <daniel...@gmail.com> wrote:

--
You received this message because you are subscribed to a topic in the Google Groups "floreysoft" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/floreysoft/pE2u64u0nbU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to floreysoft+unsubscribe@googlegroups.com.

[Daniel Florey]

Can you share the files (e.g. the red Ultradox file and the sheet) right from Google Drive with

daniel...@gmail.com

in edit mode?

[Daniel Florey]

Can you share the files that are producing the error and tell me how to reproduce the error on my end?

Thanks!

[Pete Thorpe]

I have shared the ultradox file and the spreadsheet.

I have it in test mode and run the procedure, that's all I'm doing to cause the error

Thanks

[Daniel Florey]

The flow has just 2 building blocks and runs like this (???). Are you sure you've shared the correct file?

	11:21:15	The execution has been started
	11:21:15	Loaded no rows from worksheet Form responses 1 of spreadsheet NW Car Sales Ltd. Warranty Form v2.0 (Responses)
	11:21:15	Failed to generate document, no template selected

[Pete Thorpe]

lol, no maybe not.. I have so many versions from trying to rebuild the flow/procedure..

let me try again

[Pete]

Oh boy, I'm not having a great day..

I have shared the correct flow (I think)

On 19 October 2016 at 10:21, Daniel Florey <daniel...@gmail.com> wrote:

[Daniel Florey]

I'm confused....

You have an update row block, but all rows to be updated are empty?

I guess you just want to run the flow when submitting the form and collect the responses in a sheet?

Then it is much simpler to trigger Ultradox from the responses sheet.

[Daniel Florey]

Can you also share the form with me?

We have to switch off the trigger in the form and just trigger from the sheet...

[Daniel Florey]

Can you please submit the form and check if it works?

[Pete Thorpe]

Hi Daniel

Trust me to overcomplicate things..

Thank you so much for your help.

I have another issue now, but I think it's down to some formatting as some of the fields are not being displayed on the PDF, and I am getting two emails with the same attachments.. but I think I can figure that one out.

Thanks again

[Daniel Florey]

I guess you have multiple trigger activated in some of your copies...

Make sure they are all switched off and only the one in the sheet is activated.

[tim...@lokion.com]

Daniel I am having the same issue.  Is it possible you can post the steps or assist to remove the error?