Merge columns in view

(0) Share

Report

Posted on by Community Member

Hello!

I'd like to merge columns in a view. Here's the reason: I've 4 entities in my veterinary CRM: appointment, pet, dog and cat. Appointment contains a date, a client and a pet. I'd like in my view to display the name of the pet. The only solution I found was to create 2 columns for this. One with the cat's name and the other with the dog's name. So when the pet is a cat, the column 1 will display his name and the 2nd will be empty.

But this isn't a correct solution because in reality there's 20 species of pets! So I always have 19 empty columns. So what I would like to do is either don't display a column if it's empty or to merge the 20 columns in one.

I hope I was clear :) Thanks for reading this!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (1)

Report

Hi,

go to the view of appointment then click the active form then add column,

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Or design your column like this

date|customer name|pet type| name of pet|

I think it will be better

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks a lot, I will try this solution!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

You have 20 species, better do it an option set or Look up field. You can do it In one solution, so you less your work.

Was this reply helpful? Yes No