Photo by JOSHUA COLEMAN on Unsplash

Combining multiple Forms in Coda

How to integrate feedback

The idea for this blog came when I responded to a question in the community. It was about how to bring data together of 3 tables into one table. My response was to create a forth table that brings in the values from the separate tables via formula.

The contribution of Piet was to only use one table. The main advantage of the Piet proposition is that you have all your data in one single table. You need to create a lookup showing the events and per form one is selected. You cannot preselect the event for the user. However you can limit the mistakes by relating the date to the event.

First I show you how you create separate tables — one per event — and bring all the data into one table. Second I create one table and one form.

3 tables — 3 forms

When you have per event a table and a form and you want to have the outcomes aggregated, you set up an automation. A form generates a new row in the table is is a view of. Forms, cards, time lines etc are all views of the same table. The look is different, the underlying fundament is the same. You use an automation to bring all data you automatically in the table the form is based on, also in an other table. In our example this other table is table 05. Below how it goes. With three tables, you…