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).
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!