Now, you might say: “Why would I go through the trouble of creating an Object Formula for a pop-up? When I could simply reference a row, by typing @row, and voilá, a pop-up appears.
You’d be right, because that does work, of course.
But there are situation where it might be worth your time to set the references up differently. Let’s compare the differences between the two approaches:
Hover Pop-Up with Direct Cell Referencing
Limitation No. 1: BaseTable Layout
Direct Cell referencing will always display the visible columns of the base table. You can’t directly reference the cell of a view. Hence, you’re source table’s layout will have to show all the columns (and only the columns) which shall be displayed upon hover. As the column “Image” is set to hidden in the base table, it does not show in the pop-up above.
Limitation No. 2: “@”-Symbol
Direct Cell referencing will display the “@”-Symbol. Now, you could of course get rid of it in a number of ways (easiest approach would be to use totext()). That, however, also removes the referencing itself.
See for yourself, no hover possible here:
Limitation No. 3: Multiple Rows
What if you’d like the pop-up upon hover to display the information of multiple rows? Well, that won’t fly with Direct Cell Referencing (it’s sort of implied in the name, isn’t it ;-)
Hover Pop-Up with Object Canvas Formula
Limitation No. 1 - no longer a limitation
Within the formula, you decide which parameters to show upon hover (regardless of whether these are visible or hidden in the source table. You can even choose to show or hide the parameter names (ie column headers).
Limitation No. 2 - no longer a limitation
It’s a named Canvas Formula, so you’re free to give it any name you’d like.
Limitation No. 3 - no longer a limitation
You can merge several rows into one pop-up, more on how this is achieved here
With the object canvas formula, you are free to combine several different data sources! Maybe you’d like you’re pop-up to show the image from your main Coda page, alongside a column from Table 1, next to a column from Table 2. That’s possible with the Object canvas formula. Read on below how it’s done.