Basic question: Automatically linking info from multiple tables into one

Topic Labels: Base design
531 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I would like to have one table in a base display information from multiple tables in the same base (or another if that’s the only way to do it).

My situation:
We have an online ‘program’ and participants complete a series of forms to complete each step - each form is its own table.
We’d like to have one table that gives us a ‘snapshot’ overview of each participant’s progress in completing the forms.

The only way I can see doing this is by creating a “Link to another record” field and manually selecting the participant each time. Is this right?

If there is a trigger or other automation we can set up, I’d love some help!


0 Replies 0