Generating Spreadsheet

[Erik Christensen]

Much the same way we generate google docs for new engagements, I need spreadsheets to boot.

I can't seem to find the functionality to build out a spreadsheet from a template, such as I do with Google Docs.

Can you give me guidance?

[Daniel Florey]

Building spreadsheets is not (yet) supported and technically very challenging.

But thanks for the feature request, noted.

--
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+...@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.
Visit this group at http://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

[Erik Christensen]

What about just duplicating a spreadsheet?

I just need the file available. 

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/RcS4uThXqHI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to floreysoft+...@googlegroups.com.

[Daniel Florey]

I've put this on my todo list and hope to be able to provide something soon.

[Erik Christensen]

Thank you!

[Daniel Florey]

I've added the "Copy file" building  block in the drive section. It may be used in after the  "Find file" block to set the source file id.

[Erik Christensen]

Thanks!

[Jason S]

Thanks so much for the fast implementation, Daniel.

Quick question for you: is there a way to then load the sheet using the newly-copied file or is this simply at this point a way to refer to / point to the new file for external editing?

[Daniel Florey]

Right now there are some bit and pieces missing to fully take advantage of the new file.

I'm working on enabling the use of the new copy for loading/updating the data instead of the picked default sheet.

But this will take some more days...

[Mark E]

Copy file is working great for making a copy of a Google Spreadsheet; however, how can I specify the folder of the copied file to be a variable?  I would like to create a new folder with the name of an output variable (this part is easy).  I would then like to make a copy of a spreadsheet and place it in the newly created folder (named as the output variable).  

I can't seem to figure out how to set the folder destination of the copy file building block to be a variable.  It only accepts an absolute folder name.  I have tried to place a find folder building block before the copy file, but this does not specify the folder path.

Thanks,

Mark

[Daniel Florey]

Thanks for the catch!

I'll try to add the folderId as input variable in the next days to allow you to use the tracked down folder as target folder.

Follow Agosto: Twitter / Blog / LinkedIn
Learn More: www.agosto.com

CONFIDENTIALITY
The information transmitted herein is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use of or the taking of any action in reliance upon this information is prohibited. If you receive this email in error, please contact the sender and delete or destroy this message and all copies.

--
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+...@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.

Visit this group at https://groups.google.com/group/floreysoft.

[Mark Erlandson]

Daniel,

You do that and you are my hero!

Cheers!

Mark

Mark Erlandson | Agosto, Inc. | Director of Cloud Services | Direct: 612.605.3564 | mark.er...@agosto.com

[Daniel Florey]

I've added the folderId variable (you'll have to click on the reload icon in the copy block), but I did not test ;-)

Can you do a test?

[Mark E]

Daniel,

I am amazed at how quickly you turned this around!  My testing confirms that this is working great.  Below is are the steps to make it work.  

1. Create a folder and name it as the variable specified as a value entered in a spreadsheet  (use this as the folder name in step3)
   
2. Find the file named "Ultradox Input Test" in the folder "Templates (use this for the source file in step 3)
3. Make a copy of the file specified in step 2 (${fileId}) and place it in the folder specified in step 1 (${folderId})

Many thanks on getting this added so quickly!

Thanks

Mark

[Daniel Florey]

Thanks a lot for testing + for the feedback! Looks great!

[in...@themissingmiddle.org.uk]

Thanks for this.

I followed Mark's steps to create a folder based on a variable name. I succeeded to do so, although I was wondering whether this could be done in an automatic fashion.

For example, I am now trying to create a folder with the name of the applicant for each Google Forms submission. I am able to do this one-by-one (i.e. for each new entry I have to define the cell, such as ${sheet1:B2} than ${sheet1:B3) etc.) But is there a way to make this automatic? I have tried to do this by entering ${sheet1:B}, but that does not work.

Any ideas?