Dear Glide community,
I am looking for guidance to a problem that I am facing in data entr; I have two (2) sheets where
Sheet 1 has Play Title (key), Play Description (One Record / Row)
Sheet 2 Has Play Title (key), Actors (Multiple Records / Rows)
Where the relationship between Sheet 1 and Sheet 2 is one to many.
So, my questions are:
- How do I handle that in the Data Entry screen (i.e. One Play Title is entered and then all actors within that Play title are entered in a separate sheet)?
- How do I ensure that the Play Title from Sheet one is correctly entered/transferred/copied into Sheet 2?
- How do I prompt users to enter multiple-rows in one screen?