Hello Everyone. I am new to Airtable and so far i’m loving it. I work at a law firm and we are creating a database that shows the settlement amount for cases for our attorneys as reference. I have 2 columns that I want to work in tandem. One column is designed Surgeries, for the amount of surgeries that person involved in the case had. The next column is Injuries. This shows which body parts were injured during the accident. I have color coded the Surgeries section. Let’s say if someone had 4 surgeries, that number would appear in orange. Can I then, in the following injuries column, have all 4 of the injuries appear in the same color to denote, each one of these body parts were surgically operated on? Also, if someone had 1 surgery but 3 body parts were injured, can I somehow color in just the body part that was operated on to match the color designed for 1 surgery?
I apologize if this is confusing. Please ask any questions and I’ll try to explain it better. Thank you very much for your time.