Repeated content

[skube]

I'm wondering if it's possible to use SlidesMerge to create a series of stickies (e.g. https://learninginhand.com/blog/print-custom-sticky-notes-with-google-slides)

[brucemcpherson]

Yes .. any text or images can be positioned with a placeholder in the template and populated from a sheet, one slide per row is generated.

Sent from my iPad

On Sep 7, 2017, at 9:49 PM, Skubie Doo notifications@github.com wrote:

I'm wondering if it's possible to use SlidesMerge to create a series of stickies (e.g. https://learninginhand.com/blog/print-custom-sticky-notes-with-google-slides)

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[skube]

Yes, but If I wanted multiple rows per slide, I can't seem to do it. I don't want to use one full 8.5x11" Slide just for each 3x3" stickie.

I was asking if it's possible to somehow have multiple rows merged into to one slide. For example, if I had 6 rows in Sheets, it would create and merge only 1 Slide (with 6 stickies). If I had 9 rows, it would make 1 full Slide and only partially fill the second Slide, for a total of 9 stickies across two Slides.

I understand that's not the intended purpose of your Add-on, so I was wondering if there was either some trick to merging or if your add-on could easily be updated to have such feature. 😄

[brucemcpherson]

You could simply repeat the placeholder multiple times on one slide, if it's the same one repeated, or you could have just have multiple columns in a row.

Sent from my iPad

On Sep 8, 2017, at 1:16 PM, Skubie Doo notifications@github.com wrote:

Yes, but If I wanted multiple rows per slide, I can't seem to do it. I don't want to use one full 8.5x11" Slide just for each 3x3" stickie.

I was asking if it's possible to somehow have multiple rows merged into to one slide. For example, if I had 6 rows in Sheets, it would create and merge only 1 Slide (with 6 stickies). If I had 9 rows, it would make 1 full Slide and only partially fill the second Slide, for a total of 9 stickies across two Slides.

I understand that's not the intended purpose of your Add-on, so I was wondering if there was either some trick to merging or if your add-on could easily be updated to have such feature. 😄

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[skube]

I must be doing something wrong because when I repeat the placeholders on a slide, I get exact exactly that, multiple identical merges per slide and a new slide for each row of data.

[brucemcpherson]

And that isn't what you want?

Sent from my iPad

On Sep 8, 2017, at 3:01 PM, Skubie Doo notifications@github.com wrote:

I must be doing something wrong because when I repeat the placeholders on a slide, I get exact exactly that, multiple identical merges per slide and a new slide for each row of data.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[skube]

Nope. The final merged result should have all the rows on one slide.

So for the image above, the merged Slide would have:

My sub-task one, My sub-task two, My sub-task three, etc.

Not:

My sub-task one, My sub-task one, My sub-task one, etc.

[brucemcpherson]

So why can't you just have one row, with columns named subtask1, subtask2 etc... btw I couldn't see any images if you sent any.

Sent from my iPad

On Sep 8, 2017, at 3:47 PM, Skubie Doo notifications@github.com wrote:

Nope. The final merged result should have all the rows on one slide.

So for the image above, the merged Slide would have: My sub-task one, My sub-task two, My sub-task three, etc. Not My sub-task one, My sub-task one, My sub-task one, etc.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[skube]

I could have one long row, but that would mean creating unique headings in both Sheets and Slides. Besides which, it isn't a very good way to organize data in Sheets and makes exporting to CSV an issue.

I'm not sure why you can't see the images I've attached. Are you viewing this on github.com or in an email thread?

[brucemcpherson]

I got them now. No you can't do that, but you could maintain data in one sheet in use transpose formula to turn rows in to columns in the data.

Alternatively you could use your sheet as a globals sheet, which is organized rowwise, and your data sheet would just have a single dummy row.

[skube]

I see. Appreciate the suggestions however they each seem arduous and time-consuming thus defeating the whole point. Especially when dealing with multiple placeholders.

I guess there's no easy way to extend SlidesMerge to accommodate such functionality?