Multiple instances of autoCrat script on same spreadsheet.

[André Castanheira]

Hello.

I´m trying to use the autoCrat script to pull data from a spreadsheet and merge two different documents, but I can´t seem to find a way to do it...

I can successfully pull data from the spreadsheet and create a document, but I would like to create two docs, using two different templates, at the same time.

Is there a way to achieve this?...

Thank you in advance for your help.

[Henry Thiele]

You have to split your data out to separate sheets and then run autocrat. Check out the pushData script to accomplish this easily.

Hank

Henry C. Thiele Ed.D.
http://about.me/henrythiele

--
--
You received this message because you are subscribed to the Google
Groups "Google Apps K12 Technical Forum" group.
To post to this group, send email to k12ap...@googlegroups.com
To unsubscribe from this group, send email to
k12appstech...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/k12appstech?hl=en?hl=en
 
---
You received this message because you are subscribed to the Google Groups "Google Apps K12 Technical Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to k12appstech...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[André Castanheira]

Thanks Henry, I´ll give it a go tonight and will report back.

It just seems a shame that there isn´t an option in autoCrat to merge multiple docs from different templates. This is one extra step that isn´t necessary.

[Henry Thiele]

I certainly can't complain about such a powerful free resource :)

Let me know if you need a hand.

Henry C. Thiele Ed.D

http://www.hcthiele.com

twitter.com/henrythiele

[André Castanheira]

I managed to get it working, and it´s just what I needed!

Thanks Henry! :)

[André Castanheira]

By the way, is it possible for autoCrat to update an existing merged document if one makes changes to the spreadsheet that holds the original data? I seem to always end up with a duplicate of the first merged doc if I try to do it.

One last question... If someone submits a form, is there a way for them to access the same form, change or add what they need to change, and be updated on the spreadsheet with the new information?

Thank you...again! :)

[Henry Thiele]

Check out Doc Appender

People can update responses if you allow it by checking the box to allow this when you create the form

Henry C. Thiele Ed.D

http://www.hcthiele.com

twitter.com/henrythiele

[André Castanheira]

Fantastic! I didn´t see that little option on the bottom of the form... Silly me!

Doc Appender is great, but it requires you to chose a specific doc to alter and it creates data. I just want to update existing cells in an automatic, on form submit kind of way. It´s not feasible for me. I need something similar to what formMule does to calendar events. Any change in dates, gets reflected straight away (albeit only works for one change. As soon as that Event Status Update field is populated, that´s it...)

Thank you Henry.

[Henry Thiele]

I have never done that - I just make a new document.

Hank

Henry C. Thiele Ed.D.
http://about.me/henrythiele

[André Castanheira]

Hmmm, I´ll give it a go tomorrow. It´s 3:30 am, and I need some rest :)

Many thanks for all your hep!