I’m trying to write a script here to do a thing but I’m not a coder. I can usually reverse engineer examples to get by but right now I’m coming up short. Here’s what I"m looking to do.
I have Table A
Table A has records for projects taco, sandwich, and cereal.
The base has tables corresponding to each project and share the same name.
Tables taco, sandwich, and cereal have records for each project update, most importantly the Notes field.
For each record in Table A, I want to grab the latest record from the table that matches the record name and display the Notes field content in a field in Table A. I figure I’ll put this in an automation that runs when Table A is opened.
I can make various parts of my intent work but I can’t put it all together. Can any of you epic geniuses help out?