Smtxwiki: 1 revision imported

2020-05-25T20:44:26Z

1 revision imported

← Older revision	Revision as of 22:44, 25 May 2020
(No difference)

Smtxwiki at 13:51, 14 May 2019

2019-05-14T13:51:24Z

New page

When using a multi select list, it sometimes occurs that you want to pre-select items and track which of these items have been removed and which items have been added. With the NCALC functions displayed below you can get a list of items added and removed. Just like in the example screenshot below:

[[File:AddRemove.jpg]]

The NCALC fields look like this:
<nowiki>REMOVED: foreachstring('#REPLACE-FORMFIELD-formname||hidAlreadyInstalled||#','||','IIF(INDEXOF(\'#REPLACE-FORMFIELD-formname||hidCurrentSWSelection||#\',\'{0}\')=-1,\'{0},\',\'\')','')</nowiki>

<nowiki>ADDED: foreachstring('#REPLACE-FORMFIELD-formname||hidCurrentSWSelection||#','||','IIF(INDEXOF(\'#REPLACE-FORMFIELD-formname||hidAlreadyInstalled||#\',\'{0}\')=-1,\'{0},\',\'\')','')</nowiki>

Explained
The ForEachString function is used to break up the list with already installed items. For each occurence in that list, the IIF function checks if it is mentioned in the current selection list. When mentioned, it should be ignored, if not mentioned, there is a difference and the occurence is included in the Removed field. The Added and Removed fields are identical, except that the fields OLD/NEW are switched. You may want to additionally take care of the last , in the result string.

AddedRemoved from multi select - Revision history

Smtxwiki: 1 revision imported

Smtxwiki at 13:51, 14 May 2019