Putting a customised view into a node/add form for entity referencing

Hey everyone,

If anyone could help me with this problem, I would be so grateful.

Basically what I need to achieve is the ability to reference an entity during the node/add process using a view. I know how to reference an entity using 'Entity reference' functionality with the autocomplete fields etc, and using an entity reference view (list format), and I've also tried the entity reference view widget which almost gets me there (grid format) - but...

The client wants the ability to see all of the entities in a table displaying specific fields in the 'field' format (some retrieved from other content types using relationships). Then the user will be able to use exposed filters (searching multiple fields) to narrow their options. Then basically to select the entity using a radio button etc.

Is there any way of achieving this?

I feel like I've exhausted trying to use available modules to achieve this and even considered a solution whereby I would embed a table view into the node/add form, and try and use jquery to allow someone to select an entity from the table which would then populate the entity reference autocomplete field and they can select it that way. But again, I'm not 100% sure how to do that.

If anyone has any idea how this would be achievable and can point me in the right direction, I would be over the moon! Thanks for reading.