https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Checkfordifferences Checkfordifferences - Revision history 2026-04-04T04:22:00Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Checkfordifferences&diff=35&oldid=prev Smtxwiki: 1 revision imported 2020-05-25T20:44:27Z <p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:44, 25 May 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table> Smtxwiki https://wiki.smt-x.com/index.php?title=Checkfordifferences&diff=34&oldid=prev Smtxwiki at 07:27, 3 April 2017 2017-04-03T07:27:28Z <p></p> <p><b>New page</b></p><div>If you want to know is a fieldB is different from Field A :<br /> - make a read-only display field<br /> - mark for calculations<br /> - put this in a default value<br /> <br /> IIF(&#039;#REPLACE-FORMFIELD-HRcheckforerror||veldA||#&#039; = &#039;#REPLACE-FORMFIELD-HRcheckforerror||veldB||#&#039;,&#039;&#039;,&#039;difference detected&#039;)<br /> <br /> Explanation : We check if &#039;VeldA&#039; equals &#039;veldB&#039;. <br /> If TRUE : we do nothing : &#039;&#039;<br /> if False : we show &#039;difference detected&#039;<br /> <br /> text always needs to be between quotes.<br /> <br /> You can also merge IIF statements, like in this example:<br /> <br /> IIF(&#039;#REPLACE-FORMFIELD-HRcheckforerror||veldA||#&#039; = &#039;#REPLACE-FORMFIELD-HRcheckforerror||veldB||#&#039;,&#039;&#039;,IIF(&#039;#REPLACE-FORMFIELD-HRcheckforerror||veldB||#&#039; = &#039;&#039;,&#039;E&#039;,&#039;X&#039;))<br /> <br /> so IF &#039;veldA&#039; is different from &#039;veldB&#039;, we do a second check:<br /> IF &#039;VeldB&#039; = &#039;&#039; (empty), then we put an &#039;E&#039;, if not, we put an &#039;X&#039;.<br /> <br /> To check if field &#039;veldB&#039; is empty, you can do this:<br /> <br /> IIF(&#039;#REPLACE-FORMFIELD-HRcheckforerror||veldB||#&#039; = &#039;&#039;,&#039;B is empty&#039;,&#039;B is not empty&#039;)<br /> <br /> Link with sample form : [http://dev.smt-x.com/Forms/Admin/formDetail.aspx?tab=1&amp;id=249&amp;ActiveFieldId=5046]<br /> <br /> [[File:wiki03.png]]</div> Smtxwiki