WrapLinkList

Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-wraplinklist-widget/

Populate a drop down list of unique key values from another wrap. This is a useful way to create dynamic lists rather than static lists created using Excel data validation lists. The XLW WRAPLINKLIST() function is inserted into the cell.

NOTE: Download XLW Package using 'About XLW Subdomain' button. This should be updated periodically to sync XLW with your site contents.

REMEMBER: Use a Holder Cell if you intend to use the value in forward calculations. The WrapLinkList cell formula calculates a string defining what information needs to be extracted from the cloud database and the holder cell is where the server will put the value.

The use of WrapLinkLists in combination with Unique Keys is highly recommended. Often Excel data validations lists are used to define the extents of a unique key, this is perfectly acceptable but Excel data validations lists are static lists and will require rewrapping if you need to add a new item to the list. Managing the list in a separate wrap and using WrapLinkLists allows you to extend the list of possible unique keys easily and will not require any rewrapping. For example imagine you would like a drop down list holding available widget colors (red, green and blue, say). Create a wrap called WidgetColor and define a cell called color as a unique key. One wrap instance holds the color red, another green and another blue. A WrapLinkList to WidgetColor would produce a dropdown allowing a users to select red, green or blue in any wrap it is included in. If a new color yellow is introduced then it is simply a matter of adding a wrap instance of WidgetColor using the unique key yellow. Now the WrapLinkList to WidgetColor would produce a dropdown allowing a users to select red, green, blue or yellow.

The WrapLinkList Formula Builder Form requires that all but one unique key is specified. The dropdown list is populated with all the possible values of the unspecified unique key by examination of all existing wrap instances. In this case it will be a dropdown list containing (395001, 395002, 395003 ...etc). The following cell formula is inserted in the cell.

=WRAPLINKLIST("Class395-Bogie-PackPredictor?mileage=2000000&car=MS2&end=2&Filter=unit")

This can be edited to include Excel formulas e.g. if the mileage is in cell A1, the car type is in A2 and the car end is in A3 we could use the following formula.

=WRAPLINKLIST("Class395-Bogie-PackPredictor?mileage="&A1&"&car="&A2&"&end="&A3&"&Filter=unit")

WrapLinkLists can dynamically update as the spreadsheet calculations change. This may mean that value held is not available in the updated drop down list. In this situation the cell background will be colored red to alert the user to the issue, although you may submit the data without error.

Any input cell or any data validation drop down selection can become WrapLinkLists in new versions of the wrap. Data collected in the 'old' input cells or data validation cells will be displayed in the WrapLinkList in the new version of the wrap. If the data held in the WrapLinkList is not available in the WrapLinkList's dropdown selector then it will be highlighted with a red border.

WrapLinkLists Never Update Frozen Wraps - Once a freeze signature is signed then Wraplinks, WraplinkLists and WrapLinkAggregates will not update. This is so that the loaded wrap always reflects the condition when the freeze signature was signed.