Code

Codehttps://www.infopathdev.com:443/forums/45.aspxenCommunityServer 2007 SP3 (Build: 31118.962)Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69879.aspxWed, 31 Aug 2011 15:53:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69879Lockdown0https://www.infopathdev.com:443/forums/thread/69879.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69879<p>Q. Why do I have to write "&&" in the "else if..." row?</p> <p>A. This is the logical "AND" operator. It basically says, If x AND y AND z are not true, then run the code contained in the brackets beneath the if statement.</p> <p>Q. random = ((Math.round(Math.random() * 10)) % 2) + 4: What is the % 2 doing? Why do you add 2, 4, 6 and 8?</p> <p>A. The modulo operator (%) gives you a remainder from a division equation. So 5/2 = 2 with remainer of 1. That means 5%2 will be equal to 1. Doing the % 2 to the random number will give you either a 0 or a 1 since those are the only possible remainders when you divide something by 2. Now I added the 2, 4, 6, and 8 because you has that specific set of numbers you wanted. 40% weight on 0-1, 15% weight on 2-3, and so on. Adding 2 4 6 or 8 to the original 0 or 1 you get, will put you in those ranges. You can modify that as you wish and add whatever values and weights you want from it. </p> <p>You are getting an error because you have your equal sigh(=) and greater than signs (>) mixed up. Just switch those and you should be ok!</p> <p> </p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69876.aspxWed, 31 Aug 2011 14:00:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69876Joern0https://www.infopathdev.com:443/forums/thread/69876.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69876<p>Hi Lockdown,</p> <p>one more thing, I have noticed:</p> <p>In the meanwhile I tried to modify what you have proposed. </p> <p>Here's what it looks like now:</p> <p>function CTRL2_5::OnClick(eventObj) </p> <p>{ </p> <p>var temp = Math.random();           </p> <p>if (temp >= 0 && temp < 0.001)            </p> <p> {                </p> <p>XDocument.DOM.selectSingleNode("/my:meineFelder/my:feld1").text = 6;                </p> <p>XDocument.DOM.selectSingleNode("/my:meineFelder/my:feld2").text = 2;          </p> <p>  }            </p> <p>else if (temp => 0.001 && temp < 0.003) </p> <p>{                 </p> <p>XDocument.DOM.selectSingleNode("/my:meineFelder/my:feld1").text = 6;                 </p> <p>XDocument.DOM.selectSingleNode("/my:meineFelder/my:feld2").text = 1;                         </p> <p>}            </p> <p>else if (temp => 0.003 && temp < 0.005)</p> <p> </p> <p>and so on....</p> <p> </p> <p>When I want to open the form I receive following message:</p> <p>Following failure occured:</p> <p>else if (temp =>0.001 && temp <0.003)</p> <p> </p> <p>What am I doing wrong?</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69873.aspxWed, 31 Aug 2011 08:37:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69873Joern0https://www.infopathdev.com:443/forums/thread/69873.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69873<p>Thank you for your quick response.</p> <p>Still some questions:</p> <ul> <li>Why do I have to write "&&" in the "else if..." row?</li> <li>random = ((Math.round(Math.random() * 10)) % 2) + 4: What is the % 2 doing? Why do you add 2, 4, 6 and 8?</li></ul> <p>Thanks for your patience.</p> <p> </p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69827.aspxTue, 30 Aug 2011 16:20:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69827Lockdown0https://www.infopathdev.com:443/forums/thread/69827.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69827<p>This does the trick, just tested it out. You will just have to convert the Xpath values and you should be good to go.</p> <blockquote>  <p>var temp = Math.random() * 10;</p></blockquote> <p>            var random = 0;</p> <p>            if (temp >= 0 && temp <= 4)</p> <p>            {</p> <p>                random = (Math.round(Math.random() * 10)) % 2;</p> <p>                XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = random;</p> <p>            }</p> <p>            else if (temp > 4 && temp <= 6.5)</p> <p>            {</p> <p>                random = ((Math.round(Math.random() * 10)) % 2) + 2;</p> <p>                XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = random;</p> <p>            }</p> <p>            else if (temp > 6.5 && temp <= 8)</p> <p>            {</p> <p>                random = ((Math.round(Math.random() * 10)) % 2) + 4;</p> <p>                XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = random;</p> <p>            }</p> <p>            else if (temp > 8 && temp <= 9)</p> <p>            {</p> <p>                random = ((Math.round(Math.random() * 10)) % 2) + 6;</p> <p>                XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = random;</p> <p>            }</p> <p>            else if (temp > 9 && temp <= 9.8)</p> <p>            {</p> <p>                random = ((Math.round(Math.random() * 10)) % 2) + 8;</p> <p>                XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = random;</p> <p>            }</p> <p>            else if (temp > 9.8 && temp <= 10)</p> <p>            {</p> <p>                random = 10;</p> <p>                XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = random;</p> <p>            }</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69815.aspxTue, 30 Aug 2011 13:36:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69815Joern0https://www.infopathdev.com:443/forums/thread/69815.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69815<p>In Excel I got what I want.</p> <p>Please find attached a screenshot for explanation:</p> <p>In Column C You find a couple of results.</p> <p>In Column B You find the corresponding cumulated probability of every result</p> <p>Cell G14 contains following formula: =VLOOKUP(RAND();B15:C52;2;TRUE)</p> <p>Is it possible to do this in code in IP 2003 so that the button click will generate a certain value considering the probabilities?</p> <p>Thank you very much in advance for your effort.</p> <p> </p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69809.aspxTue, 30 Aug 2011 09:34:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69809Joern0https://www.infopathdev.com:443/forums/thread/69809.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69809<p>I got it. </p> <p>As Karsten said, I needed to translate not only "field1" into German but also "myFields".</p> <p>Now, there is another question arising:</p> <p>Is it possible to weight the probability of a random integer? For instance: In 40% of the cases I receive the integer 0 or 1, in 25% of the cases I receive the integer 2 or 3, and so on.</p> <p>0 to 1: probability of 40% </p> <p>2 to 3: probability of 25%</p> <p>4 to 5: probability of 15%</p> <p>6 to 7: probability of 10%</p> <p>8 to 9: probability of 8%</p> <p>10: probability of 2%</p> <p> </p> <p>Thank you very much in advance for your efforts.</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69808.aspxTue, 30 Aug 2011 09:26:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69808Joern0https://www.infopathdev.com:443/forums/thread/69808.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69808<p>Hello Karsten,</p> <p>thank you for translating.</p> <p>Well, in the meanwhile I assumed by myself, that the mentioned  'Copy XPath'-possibility is for IP 2007, since I did not find any button to copy it.</p> <p>Is there any possibility to see the XPath of a field in IP 2003?</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69807.aspxTue, 30 Aug 2011 09:19:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69807Karsten Brocksieper0https://www.infopathdev.com:443/forums/thread/69807.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69807<p>Hello Joern,</p><p>... a short info in german for better understanding ...</p><p> "Es geht darum,. nicht nur 'field1' zu übersetzen, sondern es muss der Pfad zu Deinem Feld angegeben werden, den Du in der Datenquelle siehst, also, wenn der Pfad bspw. lautet "/my:meine Felder/my:Textfeld", dann muss EXAKT !!! dieser Pfad als Parameter bei selectsinglenode angegeben werden --- wenn´s diesen Pfad nicht gibt --- kommt die besagte Fehlermeldung..."</p><p>The mentioned 'Copy XPath'-possibility is for IP 2007 or above only !!!</p><p>Regards,</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69802.aspxTue, 30 Aug 2011 06:44:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69802Joern0https://www.infopathdev.com:443/forums/thread/69802.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69802<p>Thank you so much for your response.</p> <p>Unfortunately, I do not see the 'Copy Xpath'-possibility you advised me to select.</p> <p>Thus, I took your ("/my:myFields/my:field1") and simply translated 'field' into German, but then I receive following message: 'XDocument.DOM.selectSingleNode(...)' is null or no object.</p> <p>Any idea? Thanks for your patience :-)</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69767.aspxMon, 29 Aug 2011 16:48:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69767Lockdown0https://www.infopathdev.com:443/forums/thread/69767.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69767<p>XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = Math.round(Math.random()*10);</p> <p> The part in quotes is the Xpath of your field. So just right click your field1 element on the right task pane and select 'Copy Xpath", then place it in the quotes.</p> <p>Next, add a button to your form. Right click it and select Button Properties -> Edit Form Code.</p> <p>This will bring up the script editor. It will automatically start in the section for where your code will execute when the button is clicked. </p> <p>There will be the line //Write your code here. You can delete that line or just put your line of code underneath it(It's just a comment so it doesn't do anything).</p> <p>Just copy and paste that first line and it should work! Unless you need to change the Xpath first.</p> <p>Also, be careful when you copy and paste it becuase sometimes it will carry over some HTML tags from the webite as shown below.</p> <p><p>XDocument.DOM.selectSingleNode("/my:myFields/my:field1").text = Math.round(Math.random()*10);</p></p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69757.aspxMon, 29 Aug 2011 05:44:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69757Joern0https://www.infopathdev.com:443/forums/thread/69757.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69757<p>Thanks for your response.</p> <p>Well, it's a form that the user can download from Sharepoint. Then, he's sending his input via e-mail to me.</p> <p>I assumed to put code in the Microsoft Script editor. And how do I put the random integer in a certain field, let's say in field1?</p> <p> Thanks in advance for your effort.</p>Re: Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69701.aspxFri, 26 Aug 2011 14:36:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69701Lockdown0https://www.infopathdev.com:443/forums/thread/69701.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69701<p>Are these browser enabled forms?</p> <p>You can accomplish this with one line of code actually.</p> <p>It would look something like this in Jscript.</p> <blockquote> <p>XDocument.DOM.selectSingleNode("/myFields/ID").text = Math.random()*10;</p></blockquote> <p> That will give you a decimal point between 0 and 1. You will have to round it or format it as an integer.</p> <blockquote> <p>XDocument.DOM.selectSingleNode("/myFields/ID").text = Math.round(Math.random()*10);</p></blockquote> <p>That should be all the code you need for a random number! In C# it will be almost identical. You can take that route if you have browser enabled forms or really want to learn some C#.</p> <p><br /></p>Random figure with buttonhttps://www.infopathdev.com:443/forums/thread/69697.aspxFri, 26 Aug 2011 10:45:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:69697Joern0https://www.infopathdev.com:443/forums/thread/69697.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=45&PostID=69697<p>Hi All,</p> <p> unfortunately I am absolutely not familiar with programming in InfoPath.</p> <p>I want to have a button that generates a random integer between 0 and 10 and sets it in another field.</p> <p>Do you have any idea how I can do this in IP 2003?</p> <p> </p> <p>Thank you very much in advance for your efforts.</p> <p> </p> <p>Cheers,</p> <p>Joern</p>