Understanding Hyperlink Options in Formula Columns

Joe H. · 2025-12-08T05:51:04.172Z

when hyperlinking a column in a Formula, there are two options, despite only one column existing in the table. Why

Understanding Hyperlink Options in Formula Columns | Clay

9 comments

· Sorted by Oldest

Clay Support
APP
·
·
This typically happens when you have both a parent column and a child column with the same name. The "T Work" column likely has child columns created from it, which creates duplicate entries in the dropdown. [1]
To identify which is which, click on the column header and select "Go to parent column" to see the relationship between parent and child columns. [2] You can also rename one of the columns to make them easier to distinguish. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Joe H.
·
·
The parent column is a column that receives data from another table. The child column is taken from the payload. I used "Send Table Data" to send data to this table. Does it matter which one I link my Formulas and Prompts?
Clay Support
APP
·
·
It depends on what data you need to reference. The parent column contains the full payload from "Send Table Data," while the child column contains specific extracted values. [1]
For formulas and prompts, use the child column if you need the specific extracted value - it's cleaner and more direct. [2] Use the parent column only if you need to access other parts of the original payload that weren't mapped to child columns.
You can reference either using / in your formulas and prompts.
Clay Support
APP
·
·
Did that answer your question?
Joe H.
·
·
Yeah. So the parent column is the one with the arrow next to it?
Clay Support
APP
·
·
Yes, exactly! The parent column is the one with the arrow next to it. [1] You can also identify parent columns by clicking on any child column and selecting "Go to parent column" from the dropdown menu. [2]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help understanding how to link your Formulas and Prompts to the correct columns, please let me know. Would you like to share more about what you're trying to achieve with your table setup?