On the Canvas - Object Formula

Here’s how to create the Object Canvas Formula:

Write the desired text on canvas page

Within that text, choose the desired keyword and type the following formula:

At the point of the desired keyword (in the sample text above, that would be “Atlantic Ocean” , insert a formula, that will look-up the chosen keyword and populate it with the corresponding data from this table:

Pop-Up Text⁠

Formula Content:

⁠

Do remember to add “_merge()” to each variable. This avoids the automatic conversion to totext().

Decide whether you want your pop-ups to display column headers or not. The example below on the left does show the headers, whereas the example on the right does not.

Pop-Up with Column Headers

⁠

Pop-Up WITHOUT Column Headers

⁠

For this demo, in order to ensure better readability, I have included the parameter name in the formula. Here’s the formula to show headers (ie parameter names):

New York City

⁠

Here’s the formula to “blank out” headers (ie parameter names):

Atlantic Ocean

⁠

Naturally, the world is your oyster in accessing your table’s content within the Object-Formula. For ease of showcasing this demo, I have resorted to using “First” and “Last”.

⁠

Sample Canvas Text

hover over colored keywords to see pop-ups

Amelia Mary Earhart was an American aviation pioneer and writer. Earhart was the first female aviator to fly solo across the

Atlantic Ocean

⁠

. In 1932, Earhart made a nonstop solo transatlantic flight, becoming the first woman to achieve such a feat. Earhart's legacy is often compared to the early aeronautical career of pioneer aviator Charles Lindbergh.

Charles Augustus Lindbergh was an American aviator, military officer, author, inventor, and activist. At the age of 25, he achieved instant world fame by making the first nonstop flight from

New York City

⁠

to Paris on May 20–21, 1927.

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.