I have a table with several columns (“Calendar”). It contains address, employee, date, etc. When I am connecting this to another table (“Payments”). When I make the connection, it defaults to the first column of the connection. Is there a way to change this to specify which field/column I want it to pull from?
Hi Meagan,
Thank you for sharing your question!
I could be wrong, but I believe what you’re looking for is the display field setting. You can learn about the display field here in this article: Table Settings
If you need to learn how to update the display field, here’s an article/guide for that: How to Update Your Table’s Settings
Please feel free to let me know that my assumption here is wrong.
And as always, please feel free to reach out to our support team with any how-to questions like this: Create Support Ticket
^Responding to the above here
Since connection fields will use the parent table’s display field, if you want to get data from other fields in the parent table, you will need to use a text formula, regular formula (sum, min, max. etc.), equation, or possibly a conditional rule/task.
Maybe this article can be of assistance to you:
How to Show Multiple Fields in Your Connection Dropdown
Also, @CarlHolmes 's reply in this thread may also be a solution you’re looking for: Connected record selection view - #4 by CarlHolmes
(Thanks Carl )