Adding dynamic data as an array

Ask for Help
1

So i am building a task tracker project for my project managers.

Each project will have multiple meetings but we don’t know how many meetings it will take to complete the project.

Some project might take 2 meetings, some take 5 meetings so my project managers need to update the project multiple times.

I require all my project managers to upload an image of the MOM ( Minutes Of Meeting ) for every meeting.

Here’s an example:

1st jan 2022 → finish first meeting → take a picture of the mom → upload
3rd jan 2022 → finish second meeting → take a picture of the mom → upload
10th jan 2022 → finish third meeting → take a picture of the mom → upload

i know that there is an array column in glide by creating same column name and number each one sequentially but this requires us to know exactly how many meeting we need

What if we don’t know how many meeting we need ?

is there an efficient way to do this ? @ThinhDinh @Robert_Petitto @Darren_Murphy

2

You should create an extra table to store Meetings in my opinion.

A project can have as many meetings as you need. When you have a new meeting, open a form to submit a new row in the meetings table with the project ID can the MOM.

Then, create a relation using the project ID and show it in an inline list/collection.

2 Likes
3

Agreed. Verbatim what I would do :point_up:

2 Likes