http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 09:23:18 +0000 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-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-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-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-170 Wed, 11 Feb 2009 01:53:35 +0000 Laura Debello 170@http://www.perfectforms.com/forums/ <p>In a text field, under format, you have the option of "Custom" and a blank field appears underneath it. This field is greyed out for all other format options. What can be added in this field to indicate the "custom" format? </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/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-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-178 Mon, 16 Feb 2009 03:58:30 +0000 Laura Debello 178@http://www.perfectforms.com/forums/ <p>In Set Field Properties under Value, there is the option to use a Formula by clicking on the Compose button and then using the Compose Formula window to create your formula based on a variety of choices.</p> <p>I was trying to do a mathematical calculation (GST): Field1 divided by 1.1. The result of this formula was returning a value of more than 2 decimal points. For example 5.18 divided by 1.1 = 4.7090909. So I thought I could use the Round function, but I discovered that I can't place another formula in the "Number" row in the Round function. </p> <p>To get around this I have created a hidden field that calculates the first part of my formula, and then a second field that rounds the value in my hidden field. It works, but in other formula languages, I could achieve the same result by declaring a variable and then inserting the variable in the Round function.</p> <p>Does PF formula support any type of variable handling?</p> <p>Is there any other way that I could have achieved the same result? </p>