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
)