• Fixed what is hopefully the last of the quirks in the formatting (prefix, suffix, CSS etc.) on number and currency fields.

The updated files can be found in the DFFS download section.

• Fixed a regression bug with the “formatNumber” introduced in v2.263. This more or less skipped the numberformatting, and did not apply any of the “Special configuration” formatting to the field value.

The updated files can be found in the DFFS download section.

• Fixed a bug that halted the script in SP2010 with the error “Object doesn’t support property or method ‘get_stringValue'”.

The updated files can be found in the March 01 DFFS download package, or in the “IncrementalReleases” folder here.

• Fixed a bug where the suffix was written two times when using the “formatNumber” option.

The updated files can be found in the DFFS download package.

• PageId detection changed slightly to support a site named “forms”. This would previously not work because /forms/ was mistakingly interpreted as part of the path to the forms in a document library.
• Changed to use the full path on icons in the vLookup table to support printing these images.
• Fixed a bug where you could not bring the value in a hyperlink column over to the child item from NewForm.
• Fixed a bug with uploading documents to another site from vLookup. This fix involves forcing the upload page to open in a dialog.
• Fixed a bug with the “Connect to list” functionality when using {currentsite} in vLookup backend, and not having the DFFS_Backend configuration page in the same site as the one where the form is located.

The updated files can be found in the DFFS download package. Please note that these files are currently in the “DFFS v4.365 BETA 6” package, but it is only the DFFS files that are actually in BETA.

• Fixed a bug occurring when you use the “Prefill values in child” try to pull the value from a managed metadata field in the parent item and write it to a field in the child, you would end up with [Object object] in the field. This is tested in SP 2013.
• Made some changes to the functionality used to restrict the number of child items returned, and then using a “show more” link to view the full dataset. This functionality did not work as expected in a list view.
• Changed how number formatting is handled. As this did not work in a consistent way cross browser, I have now written a custom function to handle the decimal point and thousands separator. Please note that when trimming the decimal points, the decimals will be cut off and not rounded up.
• Added support for negative numbers in the number formatting functionality. You can now prefix with “-“, wrap in “(…)” or use red color on negative numbers. See help icon in the vLookup “ViewFields” section.
• Added option to set a mouseover text on the upload to folder and open folder icons that show when hovering over a folder in a vLookup table.

The updated files can be found in the DFFS download package. Please note that these files are currently in the “DFFS v4.365 BETA” package, but it is only the DFFS files that are actually in BETA.

• When you expand a folder it will now resize the form dialog.
• Added buttons to “Export”, “Import” or “Delete” the configuration for a vLookup field.

The updated files can be found in the DFFS download package. Please note that these files are currently in the “DFFS v4.365 BETA 1” package, but it is only the DFFS files that are actually in BETA.

• Fixed an error in the description on the “Totals” on how to use “Average”.
• Fixed a problem where vLookups would not render in EditForm when using the “Action History” column from Infowise.
• Fixed a minor bug where an URL parameter passed in from vLookup (in the In URL configuration) would show twice.
• Added support for pulling the value from a Hyperlink or Picture field in the parent and passing it on to the child in the “In URL” configuration.
• Fixed an issue where a PDF file opened from a form in a dialog made the PDF open in the same window, but the viewport was to small, and the window could not be resized. The fix was to open the PDF in a new window.
• Fixed a bug with broken links on files with a single quote in the file name.
• Fixed a bug occurring in IE8 when using vLookup in NewForm (unknown pseudo).
• vLookup backend: Moved the controls for “Show upload button on folders” and “Show open folder in new window button” to the Misc seciton in the vLookup configuration.
• Fixed an issue where “false” was shown below the field when using “Action” = “Average”, and using progressbar presentation.

The updated files can be found in the DFFS download package.

• Changed how the ItemID is extracted from the URL as it failed on upload of documents when the ID parameter was not the first parameter in the URL. This made vLookup columns not render at all when uploading documents in a document library.
• Made a workaround for a problem with expanding folders in a vLookup table when the library contains more items than the list view threshold (by default 5000 items). This fix is necessary as the “FileDirRef” column cannot be indexed and therefore cannot be used to filter contents of a folder when the list view threshold is exceeded. The fix involves splitting the query up in batches of 5000 items each.
  Currently there is a problem with sorting, as this query will only use ID. I’ll look into making a better sorting solution in the next release.

The updated files can be found in the DFFS download package.

• Fixed a bug appearing in SP2010 related to some “viewFields” not being returned by the query. This bug was introduced in the previous version because SP 2013 behaved slightly differently, and I mistakenly assumed that this was true for SP2010 also.
• Added class to view and edit button for vLlookup child items to be able to hide these using rules in DFFS.

The updated files can be found in the DFFS download package.

• ShowHelp lost the tooltip when you saved a vLookup section and did not reload the page.
• Fixed the “toggle group” function as this contained a method that failed in IE8.
• Added more options to control the “prefix” and “suffix” in “totals” when using the progress bar in a % Completed column. See help icon in the “Special configurations” section for details.

• Added support for adding vLookup children from NewForm: link
• Fixed the indent of files in nested folders in the vLookup child table.
• Added all vLookup data to a variable “spjs.vLookup.dataObj”: link
• Fixed a bug with 100% values in vLookup table showing as 1%.
• Fixed a bug with “Action = Average”.
• Added option to format a “% completed” column as a progress bar. See “Special configurations” section in the ViewFields.
• Added support for using a custom function to manipulate the value returned by vLookup: link
• Fixed a bug related to adding new vLookup child when having DFFS configured in the child list, and setting the field as readonly directly. The value set in the field did sometimes not show up in the form. The value would however be saved when the form saved.
• Changed the icons for view, edit and refresh.
• Added “vLookup receiver for NewForm: link
• Various small fixes and updates in the code.

• Fixed a duplicated “New folder” link if you used the “New folder” option on a document library, and had the vLookup column in the first DFFS tab.

• Fixed a bug affecting IE8 (or IE8 mode in newer versions of IE) where the console would log an error like “expected identifier”. This caused the vLookup plugin to fail to load.

• Fixed a bug affecting IE8 (or IE8 mode in newer versions of IE) where the console would log an error like “expected identifier”. This caused the vLookup plugin to fail to load.

• Fixed a bug when using the v2.2x version in NewForm. This caused {currentUser:prop} to not work when trying to set it from the parent item.

• Another try to fix the set multilookup field when creating children. The previous attempt in v2.204 turned out to select the item as expected, but SharePoint failed to recognize the selection.
• Fixed an issue when the “set from URL” triggered multiple times – resulting in multiple identical selection in people pickers when creating children.

• Fixed a bug with pulling field values from the current item to set metadata when creating new folders using vLookup.

• vLookup columns are now dynamically loaded when the column is first made visible in a DFFS tab. This can dramatically reduce the load time for a form with multiple vLookup columns if you put the vLookup columns in separate DFFS tabs.
• Fixed a bug with DFFS and vLookup where a selector looking for the ID of the current item was returning the tab number (&sTab=x) and not an empty string in NewForm.
• Fixed bug with setting multilookup columns from ID.

The latest version of vLookup (v2.204) requres DFFS v4.300 or later.

Please note that the CEWP code for use in list views must be changed to include a call to the function “spjs.vLookup.init” like this:

<script type="text/javascript" src="/SPJS/DFFS/plugins/jquery.js"></script>
<script type="text/javascript" src="/SPJS/DFFS/plugins/SPJS-utility.js"></script>
<script type="text/javascript" src="/SPJS/DFFS/plugins/SPJS-vLookup_frontend.js"></script>
<script type="text/javascript">
ExecuteOrDelayUntilScriptLoaded(spjs.vLookup.init, "sp.js");
$(window).on('hashchange', function(){
	spjs.vLookup.init();
});
</script>

• Added option to disable individual vLookup columns.
• Added option to specify additional dialog options (SP2010 and 2013 only).

• Fixed a bug related to totaling percentages. The problem was related to summing floating point numbers where instead of 100% in total, it ended up as 99.999999 and this was rounded down to 99%.

• Added support for ordering the returned items using the new “Order by” setup introduced in v2.117 backend. See changelog for backend below.

• Added support for using multiple fields in the “Order by” field. Hover over the help icon for details.

• Added support for handling the new dialog options described in v2.116 backend.

• Added more configuration options to the dialog when adding new items using vLookup. In the backend, you can now set these dialog options: x-offset, y-offset, width, height, allow maximize, show maximized, show close and auto size. Please note that you must update both backend and frontend script to support this change.

• This version make use of the new changes in vLookup backend where you can set the column width for individual columns. Please note that you update to vLookup backend v2.115. Use this new option to distribute the space better between columns, and to ensure grouped views of vLookup items are lined up correctly.
• Added new option to specify the location of the configuration list by setting a variable in the CEWP like this example:

  <script type="text/javascript">
  var vLookup_configListBaseUrl = "/Sites/MySite";
  </script>

  This variable must be set in the frontend, the backend, and in the CEWP code used in list views. Please note that you must place this variable ABOVE the script tag that refers the vLookup script

These files that have changed:
vLookup_frontend_min.js: v2.115 > v2.116

• Added new option to specify the column width for individual columns in the “ViewFields” section. Hover over the help icon in the “ViewFields” section to learn more.
• Added new option to specify the location of the configuration list by setting a variable in the CEWP like this example:

  <script type="text/javascript">
  var vLookup_configListBaseUrl = "/Sites/MySite";
  </script>

  This variable must be set in the frontend, the backend, and in the CEWP code used in list views. Please note that you must place this variable ABOVE the script tag that refers the vLookup script

These files that have changed:
vLookup_backend_min.js: v2.114 > v2.115

• Fixed an alignment issue with grouped vLookup tables by applying table-layout:fixed to the grouped vLookup tables. This way, columns line up properly when expanding different groups.

These files that have changed:
vLookup_frontend_min.js: v2.114 > v2.115

• Fixed a bug when using groups and no column headers. The refresh icon would appear on an empty row above the table in subsequent groups.
• Fixed a bug where the “totals” row would show only for the first group when using “totals” with grouped views.

These files that have changed:
vLookup_frontend_min.js: v2.113 > v2.114

• Added support for SP2007. Please note that you must use a dedicated vLookup frontend file for SP2007, but this backend file is shared between SP2007, SP2010 and SP2013.

These files that have changed:
vLookup_backend_min.js: v2.113 > v2.114

• Fixed some bugs in the “url:UrlNameOfList” functionality as this failed to get the lists if you used this on the root site of a site collection.
• Fixed a bug where the vLookup child table did not render (and an error was thrown in the developer console) if you used only number columns, and did not have the view or edit buttons visible.

• Added a try/catch to the list base URL to alert the user if this is wrong.
• Changed the detection of [currentItem:FieldInternalName] so that the “currentItem” part is case insensitive.
• Fixed a bug with the align right for number columns that did not use the “css” option in the “Special configuration”.
• Added option to use “Totals” for all number columns. Currently only “sum” is supported, and all number columns will be summed. You can however override this in the “Special configuration” to exclude selected columns. See the help icon in the “Totals” section for details on “totalsPrefix”, “totalsSuffix” and MUI setup.
• Added a table over all FieldInternalNames below the “ViewFields” section.
• Added the possibility to use the URL name of a list in the “List name” field. Please note that you must prefix the URL name like this: url:The_URL_name. This will cause a little overhead to the query as it will trigger an initial query to get all the lists to match up the URL name. This means you should not use this if you do not plan to save this site as a template in a MUI environment.
• Changed “Special configuration” from a single line of text field to a textarea.
• Fixed a bug where the “help icons” stopped working when closing a config section and then reopening it without reloading the page.
• Fixed a bug where you could not remove a translation below the “default”.

These files that have changed:
vLookup_frontend_min.js: v2.105 > v2.110
vLookup_backend_min.js: v2.105 > v2.110

• New in this version if the ability to use “replace” to translate for example the moderation status form its number value to a proper text value – like 0 = Approved, 1 = Rejected and 2 = Pending.
  Use the “Special configuration” like this:

  {"replace":{"0":"Approved","1":"Rejected","2":"Pending"}}

  You can also use JSON string format to have the value multilingual:

  {"replace":{"0":{"1044":"Godkjent","default":"Approved"},"1":{"1044":"Avvist","default":"Rejected"},"2":{"1044":"Avventer","default":"Pending"}}}

These files that have changed:
vLookup_frontend_min.js > v2.105
vLookup_backend_min.js > v2.105

It is mainly the “vLookup_frontend_min.js” that have changed to add the functionality, but the file “vLookup_backend_min.js” have changed to add a description of the new option in the “help icon” for the “viewFields”.

Currently the frontend is in BETA version 2.104. The following has changed from the current production release:
In v2.100:

• Fixed a bug where number columns could not use the “CSS” set in vLookup setup.
• Changed how the list name is picked up from the URL as this would fail in some cases – as described here.
• Added support for settings SPFieldLookupMulti fields when creating children – as requested here.
• Changed the $ to spjs.$ as I did in the latest BETA of DFFS due to an error in SharePoint when using rich text fields and “Insert > Link > From SharePoint” as the file “assetpicker.js” will “kill” jQuery by overriding the global $ variable.

In v2.103 BETA:

• Added option to configure the “display” and “edit” buttons individually for DispForm, EditForm and list views.

In v2.104 BETA:

• Fixed another glitch in how the list URL name is picked up when using the solution in a document library form. Sometimes the list name ended up as “Forms” and not the proper list name.
• Fixed a bug where the script failed to get the value from the current item when using [currentItem:FieldInternalName] in the query in a document library with folders.
• Some small internal script changes.

• Related to the fix in v2.003 I have made sure that both these formats in the configuration list identifier are supported: “My list name:vLookupColumn” and “My%20list%20name:vLookupColumn”. This is to ensure backwards compatibility.

• Fixed a bug where vLookup would not work in a list view if the list had a space in the list name (in the URL).

• Fixed a bug that broke the vLookup script if it was used in a calendar with recurring events (you would get an error in the function “fillInVariables”). This fix will make all recurring events that has not been individually edited, pose as the “source element”. This is because unedited recurring events does not actually exist, they are merely shadows of the original item.
• I have also made some changes to the debug output you get when you add

  &vLookupDebug=1

  to the URL. Previously the debug was alerted, but now it is appended to the page.

• Small change to the CSS that highlights any missing fields in the configurations that prevents saving the configuration.

• Fixed error in library name detection: The name of a document library was not calculated correctly in vLookup backend. This caused the config to be saved as “forms:vLookupFieldName” and not “libraryName:vLookupFieldName”. In vLookup frontend, the field appeared to be not configured.

• Fixed a bug where a discussion board list item was mistaken for a folder (the Discussion content type actually inherits from the folder content type).

• Integrated the solution better in the DFFS backend. Please note that this version cannot be used without DFFS as you need the DFFS backend to be able to configure vLookup.
• Split the solution into a frontend and a backend part to make it more lightweight.
• Added support for creating folders (in document libraries). You can now add a folder as a “child” and have vLookup show all documents and subfolders added to this folder.
• Added more configuration options to control where the new item button is shown (DispForm, EditForm and list view).
• Added support for taxonomy fields in SP2013 in table and in group headers.
• Tried to make vLookup timezone aware by adding “set_datesInUtc(false)” in the CAML query. This works in my setup, but I cannot guarantee that this is a general fix. Add any issues to the forum.
• Created a user manual

• Fixed a bug when setting a date column in a child and specifying the format in the “To column” in the GUI like this: MyDateColumn[dd.MM.yyyy]. This produced an error message stating that the field cannot be found.

• Minor update for compatibility with DFFS v4 “direct to backend script”.

• More information in an error message.

• Fixed a bug from the previous version when using [URL:Key] in the CAML: NOT supplying the URL parameter generated an error.
• Changed how the debug also alerts the values set in NewForm of the child item when using ?vLookupDebug=1 in the url

• Fixed first column width if header row is hidden.
• Uses png icons in SP2013 and fallback to white icon for file types not recognized.
• Added icons to show the view state of the groups.
• Added option to use a URL querystring variable in the CAML. Hover over the help icon for the “Build Query” or the “Write your own CAML-query” to learn how to use it.

• If you leave all display names in the viewFields section empty, the header row will be hidden.

• Fixed a compatibility issue with “fixQuirkyLookup” in the function “init_vLookupFields”.
• Added option for selecting whether or not to open “new child” in a dialog.
• Added “Show all option” when using “Rowlimit”.
• Added support for grouping the items.
• When using “Attachments” as viewField you will now get the paperclip in stead of “Yes” or “No” to indicate that an item has attachments.

• Fixed an issue with IE 11 for SP 2013: L_Menu_BaseUrl is undefined.

• Changed to to fix a bug with discussions (that are in fact folders).
• Added option to refresh all vLookup columns when one has changed.
• Added option to open links in the same window, and not in a new dialog.
• Minified the code.

• Added L_Menu_BaseUrl and L_Menu_LCID to the script for IE 11 compatibility in SP 2013.
• Wrapped the table cell values in a div for better handling of “ViewField Special configurations CSS”.
• The “ViewField Special configurations CSS” will also be applied to empty cells.
• Fixed missing refresh in list view when a vLookup item is added or edited.

• A new Action: “Comma separated list” is added. See instructions on the help icon for the “Action” field.
• Custom style now works for all column types and not only text and note columns.
• Date format can now be specified in the “In URL” section. See the help icon for details.
• A few small bugfixes.

• Child table max-height: changed overflow:scroll > overflow:auto to hide the scrollbar if it is not needed.

• Added option to pass an URL parameter to the child list NewForm when adding children. Hover over the help icon for instructions.
• Added option to set the max-height on the child table to have vertical scrollbars.
• Changed how the page id is calculated when storing and retrieving the configuration. In some cases it came out wrong.

• Added the number formatting support for “Action” sum, average and count.

• Added padding with 0 for numbers with less decimals then the value set in the numberformat option “decimals”.

• Updated the number formatting support and added separate setting for “thousandsSeparator” {“decimals”:2,”thousandsSeparator”:”.”,”decimalSeparator”:”,”}

• Fixed set multichoice column from URL.
• Added automatic refresh of the vLookup table when editing a child.

• Fixed a bug where documents in subfolders did not show in the vLookup result.

• Fixed a bug regarding multi choice people pickers. Changed the available “events” you can use. Look here for details: https://spjsblog.com/2013/08/20/vlookup-for-sharepoint-2013-v1-5

• Fixed bug where you get multiple view selectors in grouped list views.

• Fixed bug in multiselect viewfields (checkboxes, multilookup and multiuser)
• Changed some ids and variable names in the code.
• Added rowlimit setting for the query.

• Fixed bug in formatting the viewFields (like dateFormat).
• Added numberformat support for the viewFields: {“decimals”:2,”decimalSeparator”:”,”}

• Fixed typo regarding license code.

• See this article for details: https://spjsblog.com/2013/08/20/vlookup-for-sharepoint-2013-v1-5/

• Added {currentSite} as option in “List base URL” to dynamically use the current sites base url. Use this if you plan to save the site as a template.

• Aligning numbers right.

• Added formatter for percentage in the viewfields: {“percentage”:true,”suffix”:”%”}
• Applied “toLocaleString” to numbers that are not formatted as “percentage”.

• Fixed bug related to Dynamic Forms for SharePoint and reloading form when creating a child element
• Fixed a bug regarding prefix and suffix for currency and number columns. Suppresses the prefix / suffix if the field is empty.
• Added event hooks:
  • To have something done before a child element is creates, add a function with this name: “vlookupAddChildPreCheck”
    This function must return true to proceed with the add child action.
  • To have something happen after a child had successfully been added, add a function with this name: “vlookupChildAddedCallback”
    This function must return true to proceed with the updating of the “vLookup child table” in the form.
  • To have something happen after the vLoolup solution has finished loading the “Add new item button”, add a function with this name: “vLookupIsLoadedCallback”

• Added SP2013 support
• Added option to write your own CAML-query freehand
• Added dateFormat option to specify the returnvalue for a date and tinme column using a string like this: yyyy-MM-dd HH:mm:ss

• Added padding of day and month, like 17.2.2013 > 17.02.2013.

• Added more options to process the values pulled back from the query. In addition to the previous substring, you can now have prefix and suffix and additional date formatting options.
• Please note that you must reconfigure any existing “substring” after upgrading to v1.3.
• Added support for hyperlink columns and added count to the “Action menu”.
• Fixed bug with “hide field” when using a text string enclosed in curly braces in the “In URL” configuration.

• Added option to split the string by a specified separator, returning a selected array index.

• When the “parent list” is placed in a webpage and not the native list, the parameter “parentListGuid” in the URL will be
  wrong when creating children. This will prevent the solution from getting values from the parent to prefill fileds in the child.

• Fixed a bug occurring in DispForm when using [currentItem:FieldInternalName]

• Fixed a bug occurring when used in Office 365 for SP2013.

• Small fix to enable “Add new document” by uploading documents and automatically selecting the parent item in a lookup column.

• Made a little change so that you are directed out of a dialog if you enter setup.
• Removed width:100% for the vLookup table in a list view.
• Changed how the listID is found when in DispForm.

• Removed an extra “/NewForm.aspx” from the url generated in the “addChild” function.
• When creating a child in a subsite or a parent site, the setting of values from the “parent item” failed due to a wrong baseUrl parameter in the URL.
• As suggested by “advacomp”, added an option to use a text string to set a field in the child list.
  See instructions on the help icon in the “In URL” section of the setup.
• Added an option in the GUI to hide the form label in DispForm and EditForm.

• Fixed a bug that sets the wrong ID for the settings when editing the configuration from DispForm or EditForm.

• Initial release