I know that, according to this support article that "Multiple records can [only] be selected one at a time from the list of linked records (there isn't a way to link multiple records at one time).
I have a base with records for items to photograph. Each of those records has a Checkbox field for marking whether the item has been photographed or not. So each record has that field checked off or not.
My end goal is to see what percent of items have been photographed.
Because I can only create formulas by "row" and not by "column," I understand that I need to create a second table to start tabulating photographed and not photographed. So, I have a single record called "Whole Project" in that second table that links to all of the records in the first table. Then individual count fields in the "Whole Project" record in the second table show records in the first table that are marked complete and that are marked incomplete. A formula field then divides completed records by total records to give me a percentage "complete".
The problem is that I have to link all the individual records in the first table to the "Whole Project" record in the second table one-by-one. With over 200 records, this is tedious. Is there some workaround for this? If not, how can I submit it as a feature request
Ultimately, I want to have this all feed into an interface to give my team an idea of how far along photography is on a project.
Attached are screenshots of the first table, second table, and a quick mock-up of the interface.
