Auto grab the rest of field from reference

[dexter]

I use reference to grab data from “CRM” to “before_quotes”.
When I selected name from the reference function, I would like to have email auto detect to enter as well.
How can I do that?

[dmitry-grist]

Try changing Email to a Formula Column, and setting the formula $Name.Email.

Another option is to select the Name column, and use “Add Referenced Columns” in its column config in the creator panel (see here). You can use that link to add columns bringing in other values from the CRM table.