Field to summarise records with shared column value?

[oreocereus]

To group records for planning purposes, I use a unique code for each record, then a custom text field to assign one of those codes to records that need to be grouped. This is for planning vegetable plantings with multiple vegetables in a plot. 

Here's an example of how that works:

Where ID + Field Date is generated, and then I manually assign one of those codes to "planning ID" where those crops need to be considered as a group for certain planning activities. 

For planning purposes, I have a view that groups crop/records by planning ID. I also have one that sorts by crop in alphabetical order. 

However, I need a visualisation that does both - e.g. I need to be able to sort by crop AND visualise the other crops that are grouped by the same planning ID. I don't necessarily need an easy link to those other relevant records, but it'd help hugely with Day-to-Day if I can find "Bush Bean Xera - 300 Transplants" alphabetically, and easily see the names of the other records it relates to. 

Is there a way to do this simply?

[stevendasilva · Accepted solution]

Hello there, 

If I'm understanding correctly, you could set up a separate table with the planning ID's.

You could then link the crops to a given planning ID. In the crop table, you would then be able to sort alphabetically, and if you opened up the record you could see which ID it is connected with. 

By pressing on that ID you can then see the associated crops for a given ID.

Here's a loom to explain further 
https://www.loom.com/share/15cf709355dc4f35b08a3017a04a8a32

[wheeler500]

Thanks for the solution.

[oreocereus]

Thanks! That loom thing is neat and handy for this kind of stuff, cool tool!

Yeah, I considered a table for planning IDs - but I tied myself in knots as I wanted to be able to create the ID in the planning and records table (which you've called crops in your example). But I didn't realise you could do that with linked records - i.e. I can just type/copy & paste my planning ID in the linked record field and it creates a record in the planning ID table!

So, perfect - thanks!!