So to start off I needed to populate the UUID’s with data so I used this online tool to generate UUID’s https://www.uuidgenerator.net/
Next step was to “normalize” the data. I linked all the UUID’s and then deleted the columns that had the Play Name in all Sheets except the Play sheet.
There is a short coming of Glide at the moment in my opinion with the Choice Component where you can’t have is show one column but save the data from another column to the destination sheet column. So you can’t fully “normalize” the Actors List and have to save the name of the actor instead of the actors UUID.
Anyway then I created a few columns in Glide to link everything up and do a few lookups. Once you copy the app take a look at the Data tab and you will see those within Glide created columns. The start with rel_ (Relation) or lu_ (Lookup)
Here is the link to the app: https://vlpxo.glideapp.io
It needs a lot of work and testing but you can add an actor to a play and add a play date. I have about an hour into it, you are on your own now.