References
How to refer to another event or data.
Sometimes you need to pull the value of another event into a SEL expression. This is called an event reference, and looks similar to a worksheet reference in a spreadsheet.
Event References
Formulas
We use event titles to refer to events from elsewhere. For example, if we have an event called "Other Expenses", all of the following are valid:
=!'Other Expenses'
=!'Other Expenses' + 10k
+ !'Other Expenses'
Notice the exclamation point and title wrapped by single tick marks: '.
Generators & Containers
You can also use event references as the initial values for the construction of a generator or container:
=Source(!'Developer Salary')
=Funnel(!'Initial Deposit', !'Spending Rate')
Unlike formulas, these values will only be used for the initialization of the event. Once the event is initialized, these references dissolve and the values of the event will no longer depend on the value of the referenced events.
Use Unique Event Titles
Since event references rely on titles, you will run into issues if you give multiple events the same title. Make your event titles unique!
Data References
You can also reference data connected through a data import. These data references take a special format:
${name_of_data}
To reference your monthly recurring revenue, for example, you'd write:
${recurring_revenue}
Like event references, data references can be interspersed in formulas or used in the construction of events.
=${recurring_revenue} * 0.15 # app store commission on revenue
=Source(${cash_balance})
The full list of data names can also be found by expanding the details of your data import (Account settings >> Import data).
Updated 10 months ago