http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 08:46:38 +0000 http://www.perfectforms.com/forums/topic/remove-newline-from-text#post-2383 Wed, 28 Sep 2011 23:10:27 +0000 Laura Debello 2383@http://www.perfectforms.com/forums/ <p>Hi pmeidinger, Thank you so much for this, it worked! You're a champ! </p> http://www.perfectforms.com/forums/topic/remove-newline-from-text#post-2382 Wed, 28 Sep 2011 18:15:23 +0000 pmeidinger 2382@http://www.perfectforms.com/forums/ <p>Try using [\r\n] (including the brackets) in the Pattern parameter of the Replace function to match the newline. </p> http://www.perfectforms.com/forums/topic/remove-newline-from-text#post-2381 Wed, 28 Sep 2011 15:48:22 +0000 Dennis @ PerfectForms 2381@http://www.perfectforms.com/forums/ <p>If you need all of it in one text input field, I would create individual text inputs for Street, City, State/territory, and zip. Then Use a formula in a Set Field to concatenate them all into one field.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/remove-newline-from-text#post-2380 Wed, 28 Sep 2011 11:58:45 +0000 Laura Debello 2380@http://www.perfectforms.com/forums/ <p>Hi,</p> <p>I have 2 fields; one is a multi-line field and the other is a text field. I need to be able to copy the data from the multi-line field to the text field and remove any newlines or carriage returns. </p> <p>The multi-line field will typically contain an address; such as:</p> <p>ABC Company P/L<br /> Lvl 12, 100 City Road<br /> Sydney NSW 2000</p> <p>And I need this to copy to the text field as:</p> <p>ABC Company P/L Lvl 12, 100 City Road Sydney NSW 2000</p> <p>I have tried using replace but it doesn't recognise regexp "\n".</p> <p>Do you have any suggestions? </p> http://www.perfectforms.com/forums/topic/set-a-field-result-to-only-display-dollars#post-2307 Mon, 08 Aug 2011 16:37:02 +0000 Dennis @ PerfectForms 2307@http://www.perfectforms.com/forums/ <p>I am a bit confused by "A spot for defining the result". The field to hold a table column total is usually best placed under the subject table, but it doesn't have to be. The sum of a table column can be set into any field.<br /> The source of the calculation does not matter. If the total field only allows 2 decimal points the value in the total field will only have 2 decimals.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/set-a-field-result-to-only-display-dollars#post-2305 Mon, 08 Aug 2011 01:07:40 +0000 glwolverton 2305@http://www.perfectforms.com/forums/ <p>I did see this documentation, however my field is a calculated result field from adding a table column. I did not see a spot for defining the result.</p> <p>thanks very much for the quick reply </p> http://www.perfectforms.com/forums/topic/set-a-field-result-to-only-display-dollars#post-2302 Thu, 04 Aug 2011 15:56:13 +0000 Dennis @ PerfectForms 2302@http://www.perfectforms.com/forums/ <p>There is a setting in the properties of a numeric input field for decimal spaces. Please refer to the page in our help documantation about numeric inputs: <a href="http://www.perfectforms.com/Documentation/manual/html/?fl_numeric_input_properties_refer.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?fl_numeric_input_properties_refer.htm</a><br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/set-a-field-result-to-only-display-dollars#post-2298 Thu, 04 Aug 2011 15:27:03 +0000 glwolverton 2298@http://www.perfectforms.com/forums/ <p>When I do a field calculation it returns the value with xx.xxxxxxxxxxxx how do i only display only 2 decimal places </p> http://www.perfectforms.com/forums/topic/if-field-contains-formula#post-1902 Wed, 12 Jan 2011 18:36:53 +0000 Dennis @ PerfectForms 1902@http://www.perfectforms.com/forums/ <p>The formula function called Index Of: </p> <p>Searches for an occurrence of the text string (search text) within another string (text) and returns the starting position of any matching occurrence. The first character in the text is position 0. A return position of -1 indicates that search text was not found.</p> <p>Use Index Of in a simple branch behavior object. </p> http://www.perfectforms.com/forums/topic/if-field-contains-formula#post-1899 Wed, 12 Jan 2011 17:26:34 +0000 dtaylor 1899@http://www.perfectforms.com/forums/ <p>Is it possible to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain word e.g. IF this statement in Field 1 contains the word "dog", write "dog", otherwise, write nothing.</p> <p>I went to the pet store and I bought some dog food.</p> <p>Thanks<br /> Dan </p> http://www.perfectforms.com/forums/topic/hiding-items-on-form-based-on-date#post-1892 Thu, 06 Jan 2011 23:44:12 +0000 Dennis @ PerfectForms 1892@http://www.perfectforms.com/forums/ <p>Set the state of the group to hidden. When the form is opened (or when the date field is filled) use a simple branch behavior object with an advanced condition: Date is equal to or great than June 1 AND gate is equal or less than July 15. If true, exit behavior, if false use a set state behavior object to set the state of the group to normal. </p> http://www.perfectforms.com/forums/topic/hiding-items-on-form-based-on-date#post-1891 Wed, 05 Jan 2011 20:15:22 +0000 lhitchcock 1891@http://www.perfectforms.com/forums/ <p>I have a group of items on a form that I want to be either hidden or disabled based on the time of year that the form instance is filled out. If an instance of the form falls between June 1 and July 15, I want the items to be shown and mandatory; if the instance of the form falls any other time of the year, I want it to be hidden and not mandatory. </p> <p>Any help on figuring out how I can make this happen would be greatly appreciated! </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-1311 Wed, 24 Mar 2010 15:26:39 +0000 ijobling 1311@http://www.perfectforms.com/forums/ <p>maybe have a look at the 'call javascript' function. I think that javascript would enable you to do such things </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-1310 Wed, 24 Mar 2010 14:03:56 +0000 tmrhymer 1310@http://www.perfectforms.com/forums/ <p>Just got to reading through all the functions and found the search function. That looks like it works similarly to regular expression. It doesn't look like it has full regex support though. I'm looking for something that I could take a pattern like ones listed here - <a href="http://regexlib.com/DisplayPatterns.aspx" rel="nofollow">http://regexlib.com/DisplayPatterns.aspx</a> - check if some text matches the pattern. </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-1153 Thu, 18 Feb 2010 14:48:16 +0000 ijobling 1153@http://www.perfectforms.com/forums/ <p>have a look at 'functions'<br /> <a href="http://www.perfectforms.com/Documentation/manual/html/functions.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/functions.htm</a></p> <p>there are a number of things you can do here that may be of use to you. check that a text field contains a specific character for instance I've heard being used before </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-1152 Thu, 18 Feb 2010 14:14:35 +0000 jimmyc 1152@http://www.perfectforms.com/forums/ <p>I mean to where you could put a regular expression in that field and create any kind of variable format. And yeah i think for most things the masked input would suffice but if the format property supported regular expression that would be awesome. I myself would find tons of uses for that. </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-1148 Thu, 18 Feb 2010 11:16:28 +0000 ijobling 1148@http://www.perfectforms.com/forums/ <p>It is how you see it 'static' comparison. but what do you mean 'regex' capability ? if you want to control what users enter in a field look at the masked text input for instance? that is more commonly used </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-1144 Wed, 17 Feb 2010 19:05:50 +0000 jimmyc 1144@http://www.perfectforms.com/forums/ <p>Can you give us some practical applications of this feature? It seems that this is a static comparison. I could see something like this being useful if it had a regex capability, but not as is. Please enlighten us! </p> http://www.perfectforms.com/forums/topic/dropdown#post-665 Mon, 17 Aug 2009 08:19:26 +0000 ijobling 665@http://www.perfectforms.com/forums/ <p>Check here:<br /> <a href="http://www.perfectforms.com/forums/topic/how-can-i-set-up-a-behavior-to-change-drop-down-menu-data" rel="nofollow">http://www.perfectforms.com/forums/topic/how-can-i-set-up-a-behavior-to-change-drop-down-menu-data</a> </p> http://www.perfectforms.com/forums/topic/dropdown#post-664 Mon, 17 Aug 2009 06:43:39 +0000 aditya 664@http://www.perfectforms.com/forums/ <p>I have two drop-downs, I want that if i select A in first drop down then in 2nd drop down 1-10 numbers will display. </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-503 Fri, 12 Jun 2009 00:02:42 +0000 Laura Debello 503@http://www.perfectforms.com/forums/ <p>Thanks for the reply. It is as you stated above. It only allows the user to enter the exact value as stipulated in the design. However I am sure how you would use this feature. </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-502 Thu, 11 Jun 2009 19:30:53 +0000 rgatson 502@http://www.perfectforms.com/forums/ <p>Hi Laura, If you chose 'none' for the format in the example you specified above, then you would be able to enter any of these characters. In the current product, unfortunately, there is no way to say a-z, symbols and NO NUMBERS. I will raise this to see if it can be included in the product. </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-413 Wed, 20 May 2009 05:41:10 +0000 Laura Debello 413@http://www.perfectforms.com/forums/ <p>Does it mean that it has to match exactly, or can it just contain the values somewhere in what was entered, or does it match a pattern?</p> <p>For example, if I wanted to ensure that in the login name field the user can enter only characters a-z and the symbols @ _ - and spaces, how would I go about this? </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-400 Tue, 19 May 2009 02:51:17 +0000 rgatson 400@http://www.perfectforms.com/forums/ <p>Hi Laura, when you choose the custom format, the blank field will allow you to type in the area. In this area, whatever you type becomes what the text that the text input field has to match.</p> <p>ie, if in the blank field under the 'custom' format, you type the word "Hello". When you preview your form, if the word "Hello" is not in the text input box, the field will have a red outline, and when the mouse hovers over the field, it will display a message which states that the field is invalid. </p> http://www.perfectforms.com/forums/topic/custom-format-for-text-fields#post-395 Mon, 18 May 2009 02:16:08 +0000 Laura Debello 395@http://www.perfectforms.com/forums/ <p>Any news on this item? </p> http://www.perfectforms.com/forums/topic/date-format-in-formulas-can-it-be-changed-to-us-standard#post-372 Fri, 08 May 2009 13:16:49 +0000 ajobling 372@http://www.perfectforms.com/forums/ <p>A: The date in formulas is supposed to be general (Example 15 Apr 2009) however by using functions you can extract the day, month and year parameters to construct virtually any format that you want DD/MM/YYYY MM/DD/YYYY etc. </p> http://www.perfectforms.com/forums/topic/text-caculation-break-out-1st-and-last-name#post-195 Thu, 26 Feb 2009 16:10:40 +0000 rgatson 195@http://www.perfectforms.com/forums/ <p>If you have a 'name' field on your form where the first and last name are separated by a space, or any separator,and you want to have the first and last name stripped out, here is how to do it.<br /> First make sure you have the objects to collect the first and last name, as well as a hidden object to store the index.<br /> Choose a behavior to script on, then first drag a 'set field' object to set the index. Use the 'Index of' function to search for the separator in the name field.<br /> Next, drag another 'set field' for the First name and use the 'sub-text 1' function. In the function, set the start index to 0 and the end index to the field you created for the 'index'.<br /> Next, drag another 'set field' for the Last name. You will use the 'sub-text 1' function. In the function set the start index to the field you created for the 'index' and the end index to 99.<br /> Last, drag another 'set field' to remove the leading space from the last name. You will use the 'Left Trim' function to do this. Make sure you write this value back into the 'Last name' object. </p> http://www.perfectforms.com/forums/topic/text-caculation-break-out-1st-and-last-name#post-193 Wed, 25 Feb 2009 20:26:25 +0000 wliang 193@http://www.perfectforms.com/forums/ <p>I need to store 1st and last name seperately, yet the user input field is the combine of the two. How do I seperate them? Thx. </p> http://www.perfectforms.com/forums/topic/variables-in-formula-via-compose-button#post-181 Mon, 16 Feb 2009 12:01:24 +0000 ijobling 181@http://www.perfectforms.com/forums/ <p>Laura</p> <p>not a problem, please do let us know if you see areas that you feel could be better, as mentioned, we are always keen to see where we can 'improve' </p> http://www.perfectforms.com/forums/topic/variables-in-formula-via-compose-button#post-180 Mon, 16 Feb 2009 11:57:23 +0000 Laura Debello 180@http://www.perfectforms.com/forums/ <p>Ian,</p> <p>Thanks for confirming that I had done the right thing. As I am only new to this application, I was worried that I was not correctly understanding the functions and the code to insert in each row. I am used to more traditional and less GUI design and development environments. </p>