Work around for lack of table and rows in forms

When we set up projects internally we use an alignment document where each team member clarifies their understanding of their objectives and creates their own set up milestones with metrics (how they will be tested) and dates to accomplish them. To collect the data I added 6 milestones fields, six metric fields and six date fields. The problem is that each of these is in a column instead of a row so now I am trying to figure the best way to fix this.

Question 1 - is there a way to use in rows in a reasonable way or do I need to figure out how to bring each milestone, metric and date form 18 columns into 3 columns?

Question 2 is there a better way to do this. Could I send out a form with an attached table or a link to a table so people could input them directly?

Any other ideas? I saw a few other requests for tables in forms so I guess others have struggled here.

Thanks

1 Like

:wave: @Chris_DeAngelis

from what i understand of your desired outcomes-

question 1 - have 2x tables. one is projects, the other is milestones. you can then have per person and project per row in the milestones table and then have a relation column in your projects table to summarize into the 3 columns.

question 2 - you can send pre-filled form urls so people can input them directly. and also if you need to display project info you can with the relation column.

hope this helps!

Cheers!
Mel

1 Like

Thanks again Melanie. I ended up having most questions in a form. Then the users submits the form with their feedback which populates information from various source into a consolidated project overview. Then I ask them to fill out a table with their milestones directly into Coda since the form is not so useful when I don’t know how many rows may be needed. Inside coda I create this milestone collection table and have another simple form there that adds milestone by milestone as much as is needed to add. Thanks again for all your help. Hope my approach can help someone too.

1 Like

@Chris_DeAngelis

Then I ask them to fill out a table with their milestones directly into Coda since the form is not so useful when I don’t know how many rows may be needed.

there is an option on the forms to allow for multiple submissions. Go to “Edit Layout”, then under “Confirmation”, toggle on (blue colour Eye icon) “Submit again”.

Hope my approach can help someone too.

Please see this thread https://community.coda.io/t/filter-only-showing-one-result-in-embedded-table

1 Like