Database Input from Canvas

[Paul_Danyliuk]

Hey!

You can try this template/hack to split canvas lists into separate table rows:

Pro hack: Convert checklist to separate rows

I was playing around with the idea of being able to enter meeting notes in a Big Cell mode, and then quickly convert those into separate rows in a Tasks table. Here’s what I managed to do: [ezgif.com-optimize (72)] This is a hacky solution that relies on deep object modification (props to @Filmos). I added the logic to include sub-lists etc when copying each task. reducing nesting level by one. I haven’t implemented the way to preserve character-level formatting (bold, color etc) because that…

You still need to copy the full text into a cell, but the splitting is then done automatically.

The template above splits based on checklist items. It is possible to set up splitting by any other paragraph style (e.g. a header) but that’d require more work and knowledge of these things. If that’s what you need, perhaps I can update the sample with more options how to split.