Linked Properties allow you to add and/or retreive data from multiple Record Types onto your view.
Tips, Tricks, and Examples
In this example we have two record types. One is a list of currency types and exchange rates. The second record type contains items, the currency type, and a value. We want to be able to calculate an item's value using the exchange rate in the first record type. In order to do this we need to do the following steps:
- Create the Currency record type with the following properties: Currency, Exhange Rate, Serial #
- Create the Order record type with the following properties: Order ID, Amount, Currency, USD Amount and Serial #.
- On the Currency Property select the Currencies record type as the Drop Down Source
- Once this is setup, create a view that is based on your Orders record type and add the Exchange Rate property from the Currencies record type using the Add Linked Property button on the Data tab of the View Editor and refresh the view.
- The exchange rates are now visible on your view.
- Add an action to calculate the USD Amount.
- To calculate, use the Set Value action to set the value of USD Amount to an expression like this:
Anytime you execute this action chain for a record, the USD Amount will be calculated. You can use a For Each action to call this action chain to update multiple records at the same time.
PRO TIP: You'll probably want to do this with an action chain rather than setting the Formula in the USD Amount field so you can control when the calculation occurs as exchange rates will vary and you might not want to change old order amounts based on today's exchange rate.
When using a linked property as a drop-down, data in that field will be limited to entries in the list. That said, if you plan to import records into a grid containing a linked property, it's important you remember to populate the linked field's view with any value you want to import and store in the view.