Use Forms to populate the Canvas not in a form

1

I created a very complex form with around 40 fields. I laid it out in a nice digestible format for the reader. When I reviewed the submission it populated the table properly but it is now hard to read and digest in table format.

I tried to change the view on the submission table to “Form” per the online video but only a few fields showed up in the form and it was 90% useless to view in a form. So my question is whether there is a shortcut to get all of the answers back into the form layout. I don’t actually want it to be in the same form since it is not to be published again and I don’t have required fields, etc.

The use case is that my team uses the form to create a business plan filling out all the fields I need. Then I want the submission to populate a document that looks like the same form but is not technically a form. Then either me or them can make edits to the document until it is agreed.

So I am trying to see if there are any tricks to essentially copy and paste the data into something that looks nice. I thought about creating another Form where I connect it to the form submission table and pull everything into the document but this seems crazy to have to rewrite all 50 field formulas again. And if everything is a formula I don’t know how to overwrite it when we need to change things.

Any help or thoughts on how others would do this is appreciated. Also, to double check, was there a way to create the equivalent of a form in the beginning without actually creating a form (basically a table with flexibility to move fields around the canvas anywhere that is needed?)

3

View as form didn’t work but detailed view seems close

4

You could use format() to present the data from all the relevant columns in a single canvas column in a readable way. You just have to create a template with placeholders like {1}, {2}, etc. that later are substituted by values.
You can also do some fancy formatting with it.

Here you have a little example. I only used one column as an input, but it takes up to 99.

5

Thanks. I thought about that and thanks for the format() idea. I really want it to lay out in the same fashion as my form because a long table is not nice. Consider tracking 3 objectives with dates. If they are below each other it is ugly. And I don’t want a Frankenstein of tables. Seems detail is working pretty well as it seems to have adopted the original form style and is not longer a form - so I think I solved it. Will see how it works.