Linking Records

[Francoloco23]

Good day,

I have a column named Final report type (Link to RPC) wherein if this is the company, then this should be the report type that should be seen. However, there are instances if the company is seen 2 or more times, the report type is not being disclosed (see screenshot). I would like to ask if this would be done via an automation script? or a simple editing of the field column?

Thanks

[TheTimeSavingCo]

Could you provide a screenshot with an example of what you would like to happen if a company is seen 2 or more times?

[Francoloco23]

Hi Adam,

For example, once I see this company on the endorsement, the final report type should automatically populate just like in this screenshot. Currently, that is not what is happening when it comes to other companies.

Thanks

[TheTimeSavingCo]

Hm okay, how are you currently populating the "Final Report Type (Link to RPC)" linked field?

[Francoloco23]

Currently, if the company would do their endorsement, they would be choosing a report type. The picture here shows the report type and the corresponding company, but do note that the report types can be used for other companies as well. Then on another table, I would have a column that would link to the picture and just autopopulate it.