Coda Template Transpose Forms

Explore

Transpose Forms

DB Trip

overview participants per destination

HLPR Trip

When a form is submitted a row is created, values transposed and afterwards the table is cleared

Form View of HLPR Trip

Page where I create and fine tune the form

DB Trip

DB Trip

Name

participants

gender

birthday

idDoc

idDate

destination

Notes

1/29/2024 12:25:54 PM

Jean Legrand

male

4/13/1975

2/24/29403

Amsterdam

Open

1/29/2024 12:25:54 PM

Pierre Leduc

male

11/11/2011

2/24/29403

Amsterdam

Open

1/29/2024 12:25:54 PM

Claire Dupont

female

3/13/1986

2/24/29403

Amsterdam

Open

4/25/2024 11:32:52 AM

Jean-Pierre

male

4/24/1968

4/30/2025

Ghent

Open

4/25/2024 11:32:52 AM

Joost Mineur

male

2/14/1964

4/14/2028

Ghent

Open

4/25/2024 11:32:52 AM

Max Verstappen

male

4/25/1986

5/22/29403

Ghent

Open

4/25/2024 11:32:52 AM

5/22/29403

Ghent

Open

There are no rows in this table

⁠

How to run checks

People can forget to fill out names or other data or simply have - in this example - only 2 participants. Via an automation you can set up the cleaning as you see fit. In case of blanks I put a ‘ -’ and when a date is blank we generate a date so far in the future that it cannot be true.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.